unzip files from SAS in a loop

[ANLYNG]

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;

[Kurt_Bremser · Accepted solution]

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

[ANLYNG]

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. 

[Kurt_Bremser]

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

[ANLYNG]

H

[Kurt_Bremser]

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

[ANLYNG]

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