topic Re: Import Zip file from location with wildcard in New SAS User

Import Zip file from location with wildcard

Nahidul — Fri, 07 Feb 2020 16:47:09 GMT

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

Re: Import Zip file from location with wildcard

Tom — Fri, 07 Feb 2020 17:32:10 GMT

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";

Re: Import Zip file from location with wildcard

Nahidul — Mon, 10 Feb 2020 10:38:03 GMT

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