Hi,
I need to match cases from 2 datasets in a way that they match in region, ID, diagnose code and date.
region, ID and diagnose are exact matches but date can be a match from 3 different date variables in database 2.
Here's the syntax
PROC SQL;
CREATE TABLE d1d2
AS
SELECT*
FROM d1,d2
WHERE d1.region=d2.region2 and d1.ID=d2.ID2 and d1.diagnose=d2.diagnose and
d1.date=d2.date1 OR
d1.date=d2.date2 OR
d1.date=d2.date3 OR
;
QUIT;
Works fine until the OR so what how to get it to work?
S
... View more