Hello,
I have two tables:
Table1
Date Classifier Count
2017 A
2016 A
2017 B
2016 B
(Note, that the Count column is empty in Table1.)
Table2
Date Classifier Count
2017 A 100
I wanted to copy the Count value from Table2 into Table1, where Date and Classifier are matching, so that I get as an updated table:
Updated Table1
Date Classifier Count
2017 A 100
2016 A
2017 B
2016 B
Therefore, I tried the following query:
PROC SQL;
Update Table1
Set t1.Count = t2.Count
FROM Table1 t1, Table2 t2
WHERE t1.Date = t2.Date
ANDt1.Classifier = t2.Classifier:
QUIT;
However, i only got a syntax error. How can I solve this? Thanks a lot!
proc sql; update TABLE1 A set COUNT=(select COUNT from TABLE2 where DATE=A.DATE and CLASSIFIER=A.CLASSIFIER); quit;
Try that. If you want tested code then post test data in the form of a datastep.
proc sql; update TABLE1 A set COUNT=(select COUNT from TABLE2 where DATE=A.DATE and CLASSIFIER=A.CLASSIFIER); quit;
Try that. If you want tested code then post test data in the form of a datastep.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.