To all SAS Code Guru's out there! 🙂 This should be pretty easy (I can do this in other languages easily) but I can't do it in SAS.
Never tried it. Before I spend time looking it up I'll ask here (deadline to meet). So this is what I have:
Table A has more than one row per key (key_var). This is the table I need to update with the information in Table B that only
has one row per key. Both tables are indexed and sorted.
Have Corrections Want
Table_A Table_B Table_A
Key_var Var_1 Var_2 Key_var Fix_Var_1 Fix_Var_2 Key_var Var_1 Var_2
1 X A 1 XX AA 1 XX AA
2 Y B 2 YY BB 2 YY BB
2 Y B 3 ZZ CC 2 YY BB
3 Z C 3 ZZ CC
My code (which unfortunately only updates the first occurance):
data TABLE_A;
set TABLE_B;
modify TABLE_A key=key_var;
if _iorc_=0 then do;
Var_1 = Fix_var_1;
Var_2 = Fix_var_2;
replace;
end;
else _error_=0;
run;
With the above I only update the first row in Table-A that has the equivalent key in Table-B. Not the rest. Is there a simple way to alter this in the above or do I need to solve this completely different. I will keep trying to figure out HOW but like to see what you guys come up with. For a "Guru" this should be a walk in the park. Right?
This is what I get now: (not good enough as you see).
Have Corrections Want
Table_A Table_B Table_A
Key_var Var_1 Var_2 Key_var Fix_Var_1 Fix_Var_2 Key_var Var_1 Var_2
1 X A 1 XX AA 1 XX AA
2 Y B 2 YY BB 2 YY BB
2 Y B 3 ZZ CC 2 Y B <---- 😒
3 Z C 3 ZZ CC
Any suggestion? Either a fix in the above or an entire other method Thanx already now !!! 🤓
