Folder name wild card

[vanness145]

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;

[vanness145 · Accepted solution]

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