CODEWITHSUNDEEP
saszip
Siva Kg
Siva Kg

Reputation: 59

How to import a zipped ".sas7bdat" file?

I have a sas7bdat format file, but it's zipped.

I could unzip the file and work on it, but this makes me lose hard disk space and time.

So I tried this code on SAS : 

filename myfile ZIP 'C:\...\data.zip' member="data.sas7bdat" ;

data yoyo;
   infile myfile (data.sas7bdat);
   input; 
   put _infile_;
run;

But I get an empty yoyo table in the WORK library.

How can I successfully import the data.sas7bdat ?

Thank you,

Upvotes: 0

Views: 2977

Answers (1)

Tom
Tom

Reputation: 51581

You need to uncompress the dataset before SAS can use it. So you need to find a place that has enough space for the fully expanded file.

Note that your code is trying to specify the member name of the file within the ZIP file twice. You should only do that once. Either point the fileref to the aggregate location and use member name in the reference. Or point the fileref to the individual member and just use the fileref.

Here is a method to expand the file into your current WORK folder.

%let member=data.sas7bdat;
filename in zip 'C:\...\data.zip' member="&member" recfm=n;
filename out "%sysfunc(pathname(work))/&member" recfm=n;
data _null_;
   rc=fcopy('in','out');
run;

You can now work with the file using the name WORK.DATA.

proc print data=work.data(obs=1); run;

If you want to read data from a ZIP file directly then it either needs to be raw (text) data or in a streaming format, like a SAS V5 XPORT file.

Upvotes: 2

Related Questions