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
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;
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.