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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.