topic unzip files from SAS in a loop in SAS Programming

unzip files from SAS in a loop

ANLYNG — Sat, 16 Jan 2021 09:40:33 GMT

Hi,

I am trying to unzip a bundle of zip files in SAS DI/SAS 9.4. I use the name of files as input to the loop and below is my code for the job which should run in the loop. However it does not work. It Unzip the first file and the process do not stop and do not unzip the other files. So somehow the loop is not pushing forward from the first value of name.

Can you help?

Here is my code:

options noxsync noxwait;
data _null_;
%put &name.;
X """C:\Program Files\7-Zip\7z.exe"" e ""E:\SAS\Mydata\&name."" -oE:\SAS\MyData\Data\";
run;

Re: unzip files from SAS in a loop

Kurt_Bremser — Sat, 16 Jan 2021 12:47:31 GMT

Your code does not contain anything that would make it loop (DO, %DO, or reading a dataset/file).

Re: unzip files from SAS in a loop

ANLYNG — Sat, 16 Jan 2021 19:58:07 GMT

The loop is in the outer job in sas di. The code above is from the inder job and has name parameters which should run it in a loop.

Re: unzip files from SAS in a loop

Kurt_Bremser — Sat, 16 Jan 2021 20:41:23 GMT

Then I guess that the macro variable &name never changes, and the same file is unzipped again and again.

Re: unzip files from SAS in a loop

ANLYNG — Sun, 17 Jan 2021 19:12:19 GMT

H

Re: unzip files from SAS in a loop

Kurt_Bremser — Sun, 17 Jan 2021 09:39:44 GMT

You said you have an "outer loop" in DI. How does that work, and where does it set the macro variable?

Re: unzip files from SAS in a loop

ANLYNG — Sun, 17 Jan 2021 19:16:13 GMT

I managed to get things working by including everything in one job. Thank you for your contribution.