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
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.
Also, check if you have access to run OS commands (XCMD).
Run...
proc options;
run;
and check if you have XCMD or NOXCMD set.
On which OS is SAS 9.4 installed ?
ok, see my reply....
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.