I have 365 tab delimitered csv files, all have the same data structure (same variable names) and the file names are like
exp20180101.csv
.......
exp20181231.csv
The data files contains both numeric variables and character variables, the observations of character variables are of different length but all are less than 50 characters.
I want to import and merge them into a single file. I searched this community and find a similar question. I use the codes they provide,but the infiled character variables are not correct.
data import_all;
*make sure variables to store file name are long enough;
length filename txt_file_name $256;
*keep file name from record to record;
retain txt_file_name;
*Use wildcard in input;
infile "F:\source data\*.csv" eov=eov filename=filename truncover dlm='09'x;
*Input first record and hold line;
input@;
*Check if this is the first record or the first record in a new file;
*If it is, replace the filename with the new file name and move to next line;
if _n_ eq 1 or eov then do;
txt_file_name = scan(filename, -1, "\");
eov=0;
end;
*Otherwise go to the import step and read the files;
input x1-x5 (x6-x25) (:$50.) x26-x45;
run;
can anyone give me some hints about what's wrong with my codes?
Thank you very much!
Accepted Solutions
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.
Click image to register for webinar
Classroom Training Available!
Select SAS Training centers are offering in-person courses. View upcoming courses for:
-
895 views
-
3 likes
-
-
