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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.