topic Re: Do loop for importing the files in SAS Programming

Do loop for importing the files

Pooja98 — Tue, 10 May 2022 12:38:10 GMT

I have 20 csv files, need to import and append the 20 CSV files in SAS using DO loop.

The file name as follow:

Part-00000-sample file- set 12589

Part-00001-sample file- set 12590

Part-00002-sample file- set 12591

Part-00003-sample file- set 12592

etc....

i need to import the 20csv files using do loop. As for importing need a double loop, need a help for this?

TIA

Re: Do loop for importing the files

ChrisHemedinger — Tue, 10 May 2022 12:43:50 GMT

Are the files in one directory and named similar enough for a wildcard? See this article for an example.

This example is for tab-delimited.

data accel; infile "/home/my-id/tsv/*.tsv" dlm='09'x; length counter 8 timestamp 8 x 8 y 8 z 8 filename $ 25; input counter timestamp x y z filename; run;

Re: Do loop for importing the files

AMSAS — Tue, 10 May 2022 12:44:25 GMT

See Reading Multiple External Files Using the FILEVAR= Option

Re: Do loop for importing the files

Reeza — Tue, 10 May 2022 15:25:08 GMT

One more option:

https://communities.sas.com/t5/SAS-Communities-Library/How-do-I-write-a-macro-to-import-multiple-text-files-that-have/ta-p/223627