Reg Update

[R_Win]

Hi i am having 2 tables Temp1 and Temp2;

data temp1;

input pan sasid clusterid;

cards;

.  1 1

.  2 3

.  3 4

4 5 6

5 6 7

6 7 8

run;

data temp2

input pan sasid clusterid;

cards;

4 5 7

5 6 8

6 7 10

run;

i wnat to update temp1 based on temp2 pan but in temp1 pan i am having . that should remain same and the rest should update. i am having 5 crores of data here.

output;

Temp1:

.  1 1

.  2 3

.  3 4

4 5 7

5 6 8

6 7 10

[LinusH]

This can be done easily with a data step, using MERGE, UPDATE or MODIFY methods.

See examples and documentation on this very site.

/Linus

[R_Win]

proc sql; 

update temp1 a

set clusterid=

(select min(b.clusterid) from temp2 b

where a.pan=b.pan)

where a.pan ne " "

;

quit;

Got it