Reading Multiple CSVs

[Rahul_SAS]

Hi Ballard,  

I am using the below code and getting a blank line for each append. Could you please guide me to fix that.

data learn.groups;
Infile "D:\SAS\Jan*.csv" dlm=',' EOV=skip firstobs=2 truncover;
input @;
if skip then skip=0;
Else do;
input Customer $ Symbol $ Date date9. Price Months $;
format date date9.;
end;
run;

[Tom · Accepted solution]

Why are you keeping the observations with the header rows?  Either add a DELETE or an OUTPUT statement.

data learn.groups;
  infile "D:\SAS\Jan*.csv" dlm=',' EOV=skip firstobs=2 truncover;
  input @;
  if skip then do; skip=0; delete; end;
  input Customer $ Symbol $ Date date9. Price Months $;
  format date date9.;
run;

PS You would normally want to add the DSD option to your INFILE statement so that it properly handles empty values and values that contain the delimiter.