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)
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 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.