topic Re: How to unzip sas7dbat file in SAS on demand for academics in SAS Programming

How to unzip sas7dbat file in SAS on demand for academics

greesamu — Tue, 18 Jan 2022 17:46:59 GMT

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!

Re: How to unzip sas7dbat file in SAS on demand for academics

Reeza — Tue, 18 Jan 2022 17:50:04 GMT

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

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

Re: How to unzip sas7dbat file in SAS on demand for academics

AllanBowe — Tue, 18 Jan 2022 18:13:23 GMT

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

Re: How to unzip sas7dbat file in SAS on demand for academics

Tom — Tue, 18 Jan 2022 18:47:01 GMT

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;

Re: How to unzip sas7dbat file in SAS on demand for academics

Reeza — Tue, 18 Jan 2022 18:56:28 GMT

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.