topic Append SAS files with different file formats in SAS Programming

Append SAS files with different file formats

fpascal — Tue, 13 Mar 2018 00:59:00 GMT

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;

Re: Append SAS files with different file formats

ChrisNZ — Tue, 13 Mar 2018 02:05:32 GMT

Your code looks line.

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

Why do you say that? Post the log please.

Re: Append SAS files with different file formats

fpascal — Tue, 13 Mar 2018 05:10:35 GMT

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