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.

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 3425 views
  • 0 likes
  • 3 in conversation