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.

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
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...

 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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