Folder name wild card

vanness145 — Tue, 28 Dec 2021 04:21:26 GMT

Hi guys,

I have a zip file with nested folders inside the zip file.

This is what I have managed to get so far. But for every zip file, the folder name highlighted in green is changing (do not have a fixed name).

FILENAME ziplib zip "&path.\&yyyymm.\Download_20210913164726.zip";
FILENAME readfile "%sysfunc(getoption(work))\TEST123.TXT";
data _null_;
infile ziplib("PRDMobius\BPS007R\20210903053521\TEST123.TXT");
file readfile ;
input;
put _infile_;
run;

What I would want is wildcard on the folder name as per below but clearly this isn't working. Anyone can help me with this? I have zero idea....

FILENAME ziplib zip "&path.\&yyyymm.\Download_20210913164726.zip";
FILENAME readfile "%sysfunc(getoption(work))\TEST123.TXT";
data _null_;
infile ziplib("PRDMobius\BPS007R\*\TEST123.TXT");
file readfile ;
input;
put _infile_;
run;

Re: Folder name wild card

vanness145 — Tue, 28 Dec 2021 05:10:43 GMT

Found this article which is pretty helpful for my query....
https://blogs.sas.com/content/sasdummy/2016/10/16/filename-zip-list-file-contents/

topic Re: Folder name wild card in SAS Programming

Folder name wild card

Re: Folder name wild card