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 April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.