Hi,
I need to read many text files from a directory into a one SAS data set.
All the text files have the same varibles but different number of observation.
I've tried to use a wildcard into the INFILE and the program works ok:
data pippo;
INFILE "C:\tmp\*.txt"
DLM=';' DSD missover FIRSTOBS=2;
input A
B
C
😧 $4.
E: $9.;
run;
The problem is that i have to read just since the second observation of every text file (becouse the first one are the titles), and if i use the FIRSTOBS option in the INFILE, it applies just for the first text file, but in the other one it reads all the obs.
Do you know how i could apply the FIRSTOBS =2 in every text file?
Thanks,
Elena