Try this instead as your second query :
create table want as
select temp.*,c.date as c_date,
case
when c.date is missing then 'no'
else 'yes'
end as flag
from temp left join c on
temp.Machine=c.Machine and c.date between temp.date and temp.b_date;
(untested)
I'm guessing either or both of:
Difficult to diagnose without seeing the data. Can you either:
Also, if your issue is specifically a CASE/BETWEEN issue, can I suggest you leave out the other statements (joins, create table, etc)
Try this instead as your second query :
create table want as
select temp.*,c.date as c_date,
case
when c.date is missing then 'no'
else 'yes'
end as flag
from temp left join c on
temp.Machine=c.Machine and c.date between temp.date and temp.b_date;
(untested)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.