All - I would like to turn the below data step into 4 files that are appended together. the 'j' files have the same format and 'k' file has a different format - less and a few different fields. The record count on my data step seems to be off. Not sure of the best way to accomplish this task using SAS general programming or SQL;
order the files should be appended
etl.inp_claimsj_lds2013
etl.inp_claimsj_lds2014
etl.inp_claimsj_lds2015
etl.inp_claimsk_lds2016
SAS Code
data etl.inp_claims_lds2013_2016;
set etl.inp_claimsj_lds2013 etl.inp_claimsj_lds2014 etl.inp_claimsj_lds2015 etl.inp_claimsk_lds2016;
run;
Your code looks line.
> The record count on my data step seems to be off.
Why do you say that? Post the log please.
Your code looks line.
> The record count on my data step seems to be off.
Why do you say that? Post the log please.
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.