SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

gzip file in unix server read into di Studio 3.4

Reply
Contributor SYN
Contributor
Posts: 39

gzip file in unix server read into di Studio 3.4

Hi All,

I have one .gz file in unix server location /aaa/dddd/ssss/file.gz

file.gz having .csv file inside.

Can any one provide me the command to gzip this file use in DI studio 3.4 job. Thanks in advance.

Super User
Posts: 5,256

Re: gzip file in unix server read into di Studio 3.4

gzip files are unzipped with the gunzip UNIX command.

You can call it in the pre-code of the job using the X statement (make sure that AllowXCommand is set in the workspace/batch server).

Data never sleeps
Contributor SYN
Contributor
Posts: 39

Re: gzip file in unix server read into di Studio 3.4

Thank you for the valuable suggetion LinusH.

I have given below code in job preprocess, job successful however file not uncompressed.

Please advise. Thanks in advance.

/* Access the data library */
LIBNAME xxx  "/aaa/dddd/ssss/file.gz" ;
%rcSet(&syslibrc);

/* gunzip file */
x gunzip "file.gz";

Super User
Posts: 5,256

Re: gzip file in unix server read into di Studio 3.4

The X statement does not unfortunately give a returnrn code.

If you are using the filename file pipe "gunzip file.gz"; you will be able to see the return code when called from a data step.

I don't that the file name should have any quotation...?

And, are you sure that the file resists in the current directory on the server?

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 323 views
  • 0 likes
  • 2 in conversation