topic Re: how to unzip .sas7bdat.gz file in SAS Programming

how to unzip .sas7bdat.gz file

vnreddy — Tue, 06 Apr 2021 19:26:34 GMT

filename target "/sas/base.sas7bdat";
filename fromzip ZIP "/sas/base.sas7bdat.gz" GZIP;

data _null_;
	infile fromzip lrecl=256 recfm=F length=length eof=eof unbuf;
	file target lrecl=256 recfm=N;
	input;
	put _infile_  $varying256. length;
	return;
  eof:
    stop;
run;

Hi,

I am trying to unzip base.sas7bdat.gz file by using above script.

Unfortunately, i end up with below errors:

ERROR: Error in the FILENAME statement.
ERROR 23-2: Invalid option name GZIP.

ERROR: No logical assign for filename FROMZIP.

Could someone help me with this issue.

I am using SAS EG V7.11

Thanks,

vnreddy

Re: how to unzip .sas7bdat.gz file

Reeza — Tue, 06 Apr 2021 19:30:52 GMT

Please verify your SAS version, not EG. GZIP support was added quite late 9.4M5+, so I suspect your version doesn't support it.
Your code looks correct per https://blogs.sas.com/content/sasdummy/2017/10/10/reading-writing-gzip-files-sas/

You can verify your version with the following:

proc product_status;run;

Re: how to unzip .sas7bdat.gz file

vnreddy — Tue, 06 Apr 2021 19:41:56 GMT

It's :
For Base SAS Software ...
Custom version information: 9.4_M4
Image version information: 9.04.01M4P110916

Re: how to unzip .sas7bdat.gz file

Reeza — Tue, 06 Apr 2021 19:43:17 GMT

Unfortunately that version does not support GZIP. If you have XCMD enabled you can use your OS to unzip the software as a workaround.

Re: how to unzip .sas7bdat.gz file

vnreddy — Tue, 06 Apr 2021 19:52:54 GMT

I just tried :
PROC OPTIONS OPTION=XCMD VALUE;
RUN;
SAS (r) Proprietary Software Release 9.4 TS1M4
Option Value Information For SAS Option XCMD
Value: NOXCMD
Scope: SAS Session
How option value set: Site Administrator Restricted

Re: how to unzip .sas7bdat.gz file

Reeza — Tue, 06 Apr 2021 19:58:29 GMT

You'll have to talk to your IT team then about a different option - either upgrade to a later version, M5 is about 4 years old now, or allow you to pass system commands or they may require you to do it externally, outside of SAS.