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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.