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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.