topic Re: ZIP Engine for the INFILE/FILE statements with the file to extract has a parenthesis. in SAS Programming

ZIP Engine for the INFILE/FILE statements with the file to extract has a parenthesis.

Kevin_Viel — Mon, 01 Mar 2021 20:28:16 GMT

If the file in a zip archive has a parenthesis, is it possible to unzip using the ZIP engine to the INFILE/FILE statements?

data _null_ ;
infile inzip(one/two/test (2).xpt) lrecl = 256 recfm = F length = length eof = eof unbuf ;
file unzip lrecl = 256 recfm = N ;
input ;
put _infile_ $varying256. length ;
return ;
eof: stop ;
run ;

In LSAF, I get the following messages:

ERROR 23-2: Invalid option name .X.

ERROR 23-2: Invalid option name PT.

Thank you,

Kevin

Re: ZIP Engine for the INFILE/FILE statements with the file to extract has a parenthesis.

SASJedi — Mon, 01 Mar 2021 20:35:51 GMT

Because your file name includes special characters, you must enclose the member name in quotes. This should work:

data _null_ ;
   infile inzip("one/two/test(2) .xpt") lrecl = 256 recfm = F length = length eof = eof unbuf ;
   file unzip lrecl = 256 recfm = N ;
   input ;
   put _infile_ $varying256. length ;
   return ;
   eof: stop ;
run;

Re: ZIP Engine for the INFILE/FILE statements with the file to extract has a parenthesis.

Reeza — Mon, 01 Mar 2021 20:36:05 GMT

We can assume the INZIP reference is provided somewhere?
Can you post your full code and log with error please?

Re: ZIP Engine for the INFILE/FILE statements with the file to extract has a parenthesis.

Kevin_Viel — Mon, 01 Mar 2021 20:46:08 GMT

Doh!

The syntax is called aggregate syntax:

https://documentation.sas.com/?cdcId=vdmmlcdc&cdcVersion=8.1&docsetId=pgmcli&docsetTarget=n066409vu4xdwfn17tf89hhlb5xh.htm&locale=en

The solution appears to be use parentheses:

data _null_ ;
infile inzip("one/two/test (2).xpt") lrecl = 256 recfm = F length = length eof = eof unbuf ;
file unzip lrecl = 256 recfm = N ;
input ;
put _infile_ $varying256. length ;
return ;
eof: stop ;
run

Thank you,

Kevin