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)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.