Reading Multiple CSVs

Rahul_SAS — Mon, 27 Jul 2020 18:31:30 GMT

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;

Re: Reading Multiple CSVs

Tom — Mon, 27 Jul 2020 18:57:57 GMT

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.

topic Reading Multiple CSVs in SAS Programming

Reading Multiple CSVs

Re: Reading Multiple CSVs