Append SAS files with different file formats

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

Append SAS files with different file formats

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;


Accepted Solutions
Solution
‎03-13-2018 01:10 AM
PROC Star
Posts: 2,362

Re: Append SAS files with different file formats

Your code looks line.

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

Why do you say that? Post the log please.

View solution in original post


All Replies
Solution
‎03-13-2018 01:10 AM
PROC Star
Posts: 2,362

Re: Append SAS files with different file formats

Your code looks line.

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

Why do you say that? Post the log please.

Contributor
Posts: 44

Re: Append SAS files with different file formats

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

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 109 views
  • 0 likes
  • 2 in conversation