SAS: Reading all files containing a specific string -
i read set of files contain specific string (xxx*.csv). if folder has files below, code should read in file #1 , #2. 1. xxx_123.csv 2. xxx_456.csv 3. xyz_111.csv
the first part of filename known, sec part unknown. know how can accomplish in sas enterprise guide?
you can create wildcard fileref, not sure how interactively in eg, in base of operations sas code similar below.
filename wildxxx "/path/xxx*.csv" ; info readin ; infile wildxxx /* + infile options */; /* input statement */ run ; sas
No comments:
Post a Comment