Hi everybody, I want to do a special merge. I have two tables A and B: data A; input ID $ 1 Num 12.; datalines; a 24 a 65 a 43 ; run;

data B; input ID $ 1 color $5.; datalines; a Red b Green c White ; run;

the usual merge BY ID fot these tables is : code: proc sort data=a; by ID;run; proc sort data=b; by ID;run;

data C; merge a(in=f1) b(in=f2); by ID; if f1; run;

result (Table C):

Obs ID Num color 1 a 24 Red 2 a 65 Red 3 a 43 Red

What I want is to merge only the first (or last) line By ID with the corresponding line in table B, like it's illustrated here: Obs ID Num color 1 a 24 Red 2 a 65 3 a 43

I can use : if not First.ID then Color=''; but you understand that it'a only a sample here, and in reality I have about 90 columns...

thanks for your help.