topic Re: Read zip file in sas/window in SAS Programming

Read zip file in sas/window

arunrami — Mon, 15 Feb 2021 07:29:33 GMT

Can anyone explain how to read zipped dataset with the help of SAS and as well as zip command in sas /window platform?

Re: Read zip file in sas/window

andreas_lds — Mon, 15 Feb 2021 08:04:09 GMT

Please have look at the documentation of the filename statement and/or use the search-function. Dealing with zip-files has already been discussed in full-detail.

Re: Read zip file in sas/window

ChrisNZ — Tue, 16 Feb 2021 21:02:54 GMT

Is it an actual SAS data set (extension sas7bdat) in the zip file?

Otherwise, as mentioned, this question has been answered many times. Please expose a specific problem if you have one.

Re: Read zip file in sas/window

arunrami — Tue, 16 Feb 2021 20:36:37 GMT

Yes , it is a zipped sas dataset

Re: Read zip file in sas/window

ChrisNZ — Tue, 16 Feb 2021 21:29:36 GMT

I can't think of a way to use a sas data set without first extracting it from the zip file. Which you can do using SAS of course:

filename IN zip 'C:\temp\data.zip' member='mydata.sas7bdat' recfm=n;
filename OUT "%sysfunc(pathname(work))/mydata.sas7bdat" recfm=n;
data _null_;
   RC=fcopy('IN','OUT');
run;