Help using Base SAS procedures

Reg Update

Reply
Regular Contributor
Posts: 229

Reg Update

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

Super User
Posts: 5,431

Reg Update

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

See examples and documentation on this very site.

/Linus

Data never sleeps
Regular Contributor
Posts: 229

Reg Update

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 

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