topic How to replace a row from another table in SAS Data Management

How to replace a row from another table

jjjunyi — Fri, 23 Jan 2015 17:47:19 GMT

Hi every one.

Now I have dataset A:

Now I have dataset B:

Date	AZ	WM	TG
1/1/2015	10	0	12

I want dataset A look like:

Any suggestions?

DBailey — Fri, 23 Jan 2015 18:02:12 GMT

proc sql;

update dataset_a t1

set

az=(select az from dataset_b where date=t1.date),

wm=(select wm from dataset_b where date=t1.date),

tg = (select tg from dataset_b where date=t1.date)

where exists (select * from dataset_b where date=t1.date);

quit;

jjjunyi — Fri, 23 Jan 2015 18:22:41 GMT

thanks but looks some error

jjjunyi — Fri, 23 Jan 2015 18:26:45 GMT

Never mind, I forgot to delete comma.

Tom — Fri, 23 Jan 2015 21:19:49 GMT

Not sure why people insist on putting commas at the end of the line instead of the beginning. They are much harder to see out there.

Ksharp — Sat, 24 Jan 2015 08:19:53 GMT

Since you already have a index variable DATE, why not use MERGE statement.

data want;
 merge A B;
 by date;
run;