topic Re: Not able to unzip or read .gz file in SAS Enterprise Guide

Not able to unzip or read .gz file

ajitsingh1 — Fri, 03 Nov 2017 10:38:56 GMT

Hi ,

I'm using SAS Enterprise Guide 7.13 (sas 9.4) & I have file in the following format : filename.csv.gz
I've tried using the following command for filename:

1) Filename zipfile ZIP "/home/abc/filename.csv.gz" GZIP;

but I'm getting the following error :
ERROR : Error in the FILENAME statement.
ERROR : Invalid option name GZIP.

2) Filename zipfile PIPE "/home/abc/filename.csv.gz" ;

but I'm getting the following error :
ERROR : Insufficient authorization to access PIPE.
ERROR : Error in the FILENAME statement.

File contains csv file & I'm not able to unzip or read that file.

Please let me know how to read/unzip & after unzipping, again how to zip in .gz format .
Thanks in advance,
Ajit

Re: Not able to unzip or read .gz file

ChrisHemedinger — Fri, 03 Nov 2017 10:42:39 GMT

The GZIP feature was added to FILENAME ZIP in SAS 9.4 Maint 5. What version do you have? Run:

proc product_status; run;

To find out.

Re: Not able to unzip or read .gz file

nhvdwalt — Fri, 03 Nov 2017 10:49:18 GMT

Also, check if you have access to run OS commands (XCMD).

Run...

proc options;

run;

and check if you have XCMD or NOXCMD set.

Re: Not able to unzip or read .gz file

ajitsingh1 — Fri, 03 Nov 2017 11:00:06 GMT

I'm having 9.4 Maint 3.

Re: Not able to unzip or read .gz file

ajitsingh1 — Fri, 03 Nov 2017 11:01:05 GMT

NOXCMD : Disables the X command in SAS.

Re: Not able to unzip or read .gz file

nhvdwalt — Fri, 03 Nov 2017 11:03:31 GMT

On which OS is SAS 9.4 installed ?

Re: Not able to unzip or read .gz file

ajitsingh1 — Fri, 03 Nov 2017 11:08:29 GMT

It is on Windows

Re: Not able to unzip or read .gz file

nhvdwalt — Fri, 03 Nov 2017 11:09:19 GMT

For Windows, set -xcmd option in your sasv9.cfg file and restart your SAS Enterprise Guide session. Check that the setting has taken effect by running proc options first.

http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#p0xtd57b40ehdfn1jyk8yxemfrtv.htm

Re: Not able to unzip or read .gz file

nhvdwalt — Fri, 03 Nov 2017 11:10:24 GMT

ok, see my reply....