Import Zip file from location with wildcard

[Nahidul]

Hello all

I've tried to create an import statement that reads in a zip file with a wildcard in the zipfile name, much like text and csv files

filename x zip ".....\%%%%%%%%-RestOfFileZipName.zip" member = "CSVToImport*.csv";



data fileout;
   infile x
   firstobs = 1 
   dsd dlm = ',' 
   truncover
   ;
      var1   :8.
      var2   :8.
      ;
run;

where I've put the "%" is where I expect to have the wildcard to import the zip, like I said I'd like it to work the same way the " * " wildcard works with the member. Has anyone done this before, can you advise if this is even possible.

Thanks in advance.

PS, using SAS 9.4

[Tom · Accepted solution]

You need to find the name in some other way.

Here is one way to find the first filename that matches your pattern and put it into a macro variable:

data _null_;
  length fname $256 ;
  infile "....\*-RestOfFileZipName.zip" filename=fname obs=1 ;
  input;
  call symputx('zipfile',fname);
run;  

then use the macro variable in your existing FILENAME statement.

filename x zip "&zipfile" member = "CSVToImport*.csv";

[Nahidul]

Thanks Tom, that's exactly what I was looking for!