topic Re: How to read all .txt.gz filenames from a folder in SAS Programming

How to read all .txt.gz filenames from a folder

KinjalPatel — Sun, 11 Aug 2019 15:00:55 GMT

Hello,

I have multiple text files in zipped format in a folder. I want to get all filenames in one SAS dataset.

For example:

H:\SAS\Project\ABC_20190811.txt.gz

H:\SAS\Project\PQR_20190811.txt.gz

H:\SAS\Project\XYZ_20190811.txt.gz

H:\SAS\Project\JKL_20190811.txt.gz

Output:

ABC_20190811

PQR_20190811

XYZ_20190811

JKL_20190811

Thanks,

Kinjal

Re: How to read all .txt.gz filenames from a folder

Shmuel — Sun, 11 Aug 2019 17:17:59 GMT

1) Do you know to import one zipped file ?

2) Read the article in this link: https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/155-31.pdf

3) Read each file and append it to a desired sas dataset name.

Post your code and log in case of issues using the {i} icon above.

Re: How to read all .txt.gz filenames from a folder

Tom — Mon, 12 Aug 2019 02:15:18 GMT

Read the names. Then parse the names to extract the part you want.

data filenames ;
  infile 'dir H:\SAS\Project\*.txt.gz /b' pipe truncover;
  input filename $256. ;
  membername = scan(scan(filename,-1,'\'),1,'.');
run;

Re: How to read all .txt.gz filenames from a folder

KinjalPatel — Mon, 12 Aug 2019 06:24:00 GMT

Thank you Tom! You are genius!