How to unzip sas7dbat file in SAS on demand for academics

[greesamu]

So I've uploaded plenty of .sas7dbat files with no issue, but for the first time I have one that's over 1 GB (it's 1.1 GB). I've been able to zip it and then upload the zipped file, but now I can't figure out how to unzip the file now that it's in SAS Studio.

I'd appreciate advice on how to unzip the file or some way to split it into two smaller files. Thanks!

[Reeza]

https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in...

This post shows how to unzip a SAS data set and work with it. 

[AllanBowe]

Here's a macro to do the unzip: https://core.sasjs.io/mp__unzip_8sas.html

[Tom]

Just to spell it out.

Point a fileref at the file inside the ZIP file.

Point another at the place you want to store the SAS dataset.

Use FCOPY() to extract the file.

You need to use RECFM=F and set a specific LRECL value to force BINARY copy.

filename in zip "myfile.zip" member='myds.sas7bdat' recfm=f lrecl=512;
filename out "/mydirectory/myds.sas7bdat" recfm=f lrecl=512;
%let rc= %sysfunc(fcopy(in,out));

If you want the file created in the WORK directory use the PATHNAME() function to find out where that is for this session.

filename out "%sysfunc(pathname(work))/myds.sas7bdat" recfm=f lrecl=512;

[Reeza]

If you need to work with large data sets, you can also use filename URL to access data sets on public sites and a similar method to Tom's solution to copy them over from a cloud site to your SAS On Demand session.