I am having difficulty trying to open a zipped SAS dataset. There seem to be very few examples of this that I can find online, and none of them offer a clue as to how to solve my problem.
If I run the following code, I can see that SAS is successfully recognizing the zip file and its contents (I edited out the path for anonymity, but "path" in the below is a valid path to an existing directory on the machine):
filename inzip ZIP "path\CoBISII-InterimAnalysis20190618.zip";
DATA contents(keep=memname);
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=contents noobs N;
run;
This produces the following output:
| mrsdata.sas7bdat |
| Readme.xlsx |
| N = 2 |
I want to read the SAS dataset (mrsdata) into SAS. I tried following the example here and used the following code:
filename wc "%sysfunc(getoption(work))/mrsdata.sas7bdat";
DATA _null_;
infile inzip(mrsdata.sas7bdat) lrecl=256 recfm=F length=length eof=eof unbuf;
file wc lrecl=256 recfm=N;
input;
put _infile_ $varying256. length;
return;
eof:
stop;
run;
PROC CONTENTS data=WORK.mrsdata;
run;
However, this produces the following error (again, I am editing out the path for anonymity's sake):
ERROR: Open failure for path\CoBISII-InterimAnalysis20190618.zip during attempt to create a local file handle.
NOTE: UNBUFFERED is the default with RECFM=N.
NOTE: The file WC is:
Filename=C:\tmp\wc.dat,
RECFM=N,LRECL=256,File Size (bytes)=0,
Last Modified=24Jun2019:14:39:38,
Create Time=24Jun2019:14:39:38
I am at a complete loss as to how to proceed.
