Combining 2 datasets

[ChristyN]

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;

[ballardw]

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;

[ChristyN]

Thanks I'll try it!