Append SAS files with different file formats

[fpascal]

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;

[ChrisNZ · Accepted solution]

Your code looks line.

>  The record count on my data step seems to be off. 

Why do you say that? Post the log please.

[fpascal]

You are right ... i did some manual calculations
the numbers came up different in Tableau so i will check my code there