DATA Step, Macro, Functions and more

Combining 2 datasets

Reply
Occasional Contributor
Posts: 7

Combining 2 datasets

Hi there, looking for some help. Here is what I am trying to do and the datasetep I am using. It works but takes a really long time to run given the number of obs in my data. Anyone know of an alternative program to get what I want?

 

Dataset 1                                                          Dataset2

ID           Legal     Charge                                Charge                 Status

1             1             A                                           A                            Rem

1             1             B                                           A                            Sent

1             2             A                                           A                            Time     

2             1             C                                           B                            Sent

2             2             C                                           B                            TIC

                                                                           C                            Rem

                                                                           C                            Fed

  

Resulting Dataset

 

 ID          Legal     Charge                 Status

1             1             A                            Rem

1             1             A                            Sent

1             1             A                            Time

1             1             B                            Sent

1             1             B                            TIC

1             2             A                            Rem

1             2             A                            Sent

1             2             A                            Time

2             1             C                            Rem

2             1             C                            Fed

2             2             C                            Rem

2             2             C                            Fed

 

data Result;
set Dataset1;
drop _:; 
match = 0; 
do i=1 to xnobs;
set Dataset2 (rename = (charge=_charge)) nobs=xnobs point=i;
if charge = _charge then do;
match = 1; 
output;
end;
end;
run;

Super User
Posts: 11,343

Re: Combining 2 datasets

Something like this perhaps:

proc sql;
   create table want as
   select dataset1.*, dataset2.status
   from dataset1 left join dataset2 
        on dataset1.charge = dataset2.charge;
quit;
Occasional Contributor
Posts: 7

Re: Combining 2 datasets

Thanks I'll try it!

Ask a Question
Discussion stats
  • 2 replies
  • 211 views
  • 0 likes
  • 2 in conversation