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;     ... View more

  data JE.KeywordMatchTemp1; if _n_ = 1 then do; do i = 1 by 1 until (eof); set JE.KeyWords end=eof; array keywords[100] $30 _temporary_; keywords[i] = Key_Words; end; last_i = i ; retain last_i ; end; set JE.JEMasterTemp; match = 0; do i = 1 to last_i while (match=0) ; if index(descr, trim(keywords[i]) ) then match = 1; end; drop i last_i; run; Hi all, I am having difficulty to understand what does this line does..  if _n_ = 1 then do; I understand that it creates a field of auto increment by 1 for each records in the dataset. I have tried to remove this statement and logically speaking the code should run fine too right without this statement?   Instead I am getting obs capping of 1 at this set statement. set JE.JEMasterTemp;   I need help...         ... View more