Reading all SAS dataset from Zip File

[Leo9]

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;

[Reeza]

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..

[Leo9]

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. 

[Reeza]

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. 

---

[ballardw]

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.