BookmarkSubscribeRSS Feed
ajitsingh1
Calcite | Level 5

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

8 REPLIES 8
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
ajitsingh1
Calcite | Level 5
I'm having 9.4 Maint 3.
nhvdwalt
Barite | Level 11

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

 

Run...

 

proc options;

run;

 

and check if you have XCMD or NOXCMD set.

ajitsingh1
Calcite | Level 5
NOXCMD : Disables the X command in SAS.
nhvdwalt
Barite | Level 11

On which OS is SAS 9.4 installed ?

ajitsingh1
Calcite | Level 5
It is on Windows
nhvdwalt
Barite | Level 11

ok, see my reply....

nhvdwalt
Barite | Level 11

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#p0xtd57b40ehdfn1jy...

 

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 8 replies
  • 5455 views
  • 0 likes
  • 3 in conversation