I have a problem as follows :
I want to create a dataset C that copies all of data set A
as well as adds an additional variable (varx) as 0/1 based on whether an
observation id in dataset A occurs in dataset B (on the same date).
I have tried a PROC SQL as follows but with no success:
proc sql ;
create table c as
case when a.id=b.id and a.date=b.date
end as varx
from datasetA as a, datasetB as b;
I get a timeout (OUT OF RESOURCES error).
Any idea on what I am doing wrong here?