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;
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.
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.