topic Reg Update in SAS Procedures

Reg Update

R_Win — Tue, 23 Aug 2011 06:32:31 GMT

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

Reg Update

LinusH — Tue, 23 Aug 2011 06:39:07 GMT

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

See examples and documentation on this very site.

/Linus

Reg Update

R_Win — Tue, 23 Aug 2011 10:22:36 GMT

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