DATA Step, Macro, Functions and more

merge help

Reply
Occasional Contributor
Posts: 10

merge help

I have a dataset as follows:

 ABCDEFG 
DAY1123.... 
DAY2...4567 
 The result I want is as follows:        
 ABCDEFG 
 1234567 

It's a very last dataset with 1300 variables

i tried to make two subset data sets with DAY1 AND DAY2 and merged then back. But the result I get is as follows:

 

ABCDEFG
123....

Please help

Thanks!

Super User
Posts: 17,828

Re: merge help

This is typically resolved with an UPDATE statement with your by variables. But you haven't specified your key variables. 

 

You can look into the update statement or provide more information if you need more help. 

Super User
Posts: 9,681

Re: merge help


proc summary data=sashelp.class;
var _numeric_;
output out=want(drop=_:) sum=;
run;


Ask a Question
Discussion stats
  • 2 replies
  • 217 views
  • 2 likes
  • 3 in conversation