topic Re: Reading all SAS dataset from Zip File in SAS Programming

Reading all SAS dataset from Zip File

Leo9 — Mon, 05 Oct 2020 22:25:23 GMT

Hi All,

I am trying to read zip file which has lot of sas datasets. I want to extract all this sas datasets at once and placed them in a folder.

I am successful in reading the content of zip file but not sure how to extract sas datasets from this zip file and placed them in a different folder. Below is the code which reads content of zip file.

filename inzip ZIP "x:\test.zip";

DATA FLS(KEEP=MEMNAME);
FILENAME inzip ZIP "x:\test.zip";
LENGTH MEMNAME $200;
FID=DOPEN("inzip");
IF FID=0 THEN
STOP;
MEMCOUNT=DNUM(FID);
DO I=1 TO MEMCOUNT;
MEMNAME=DREAD(FID,I);
OUTPUT;
END;
RC=DCLOSE(FID);
RUN;

proc print data = fls ;
run;

Re: Reading all SAS dataset from Zip File

Reeza — Mon, 05 Oct 2020 22:32:45 GMT

If you google the topic with Chris Hemidinger name you'll find several fully worked examples in his blog posts, including some macros to help automate the tasks..

Re: Reading all SAS dataset from Zip File

Leo9 — Mon, 05 Oct 2020 22:37:34 GMT

I could not fine anything which specifically does this task. I example of reading excel file and reading one dataset at a time but nothing related to what I need.

Re: Reading all SAS dataset from Zip File

ballardw — Mon, 05 Oct 2020 22:49:12 GMT

My approach to something like this would be to

1) us appropriate tool to unzip to desired location with system tools.

2) assign a library to that location.

Re: Reading all SAS dataset from Zip File

Reeza — Tue, 06 Oct 2020 00:57:43 GMT

I'd recommend taking the example that does one file and figure out how to generalize it to all.

X commands definitely work though.

@Leo9 wrote:

I could not fine anything which specifically does this task. I example of reading excel file and reading one dataset at a time but nothing related to what I need.