@sophia_SAS wrote:
You are correct in that I am trying to combine the data afterwards. I would like to use CSV but am struggling with reading in multiple tabs within 1 csv file. Here's my infile code for the first tab. I have 5 other 'tabs in this mydata csv file. (I know CSV doesn't do sheets.)
DATA want;
FORMAT ID $7. STATE $2. DOB MMDDYY10. CLASSOTH $25.;
INFILE "mydata.csv" missover dsd firstobs=2;
INPUT IT $ STATE $ DOB GEO2010FIPS CLASS1 CLASS2 CLASSOTH $;
run;
Obviously 5 source files will require file separate CSV files since they are just simple text files.
If they have the same structure you can either read them all in data step, or read them separately and then combine.
Do if you had this code to read one file.
data want ;
length ID $7 STATE $2 DOB GEO2010 FIPS CLASS1 CLASS2 8 CLASSOTH $25;
informat dob mmddyy. ;
format dob date9. ;
INFILE "mydata.csv" dsd firstobs=2 truncover;
INPUT ID -- CLASSOTH ;
run;
You call it five with different input files and dataset names to read in five files.
Or you could possible adopt it to read in all five files in one pass if you wanted.
One way would be to use wildcard in the INFILE name. But if each file has a header row then you need to add code to skip the extra headers. Perhaps by using the EOV variable that SAS will set to 1 when you start a new physical file. So if you had files named mydata1.csv, mydate2.csv .... then you might be able to use a step like this.
data want ;
length ID $7 STATE $2 DOB GEO2010 FIPS CLASS1 CLASS2 8 CLASSOTH $25;
informat dob mmddyy. ;
format dob date9. ;
INFILE "mydata*.csv" dsd firstobs=2 truncover eov=eov;
input @;
if _n_=1 or eov then input;
INPUT ID -- CLASSOTH ;
eov=0;
run;
