Hello Experts,
I am a new by to SAS and learning from youtube. I am stuck with one of the problem statement and seek your support.
I am trying to find out the below in 2 datasets;
If V3 date falls between V3 and V5 of the sheet1 then NAR. If it falls on or after V5 of sheet1 then issue.
If V5 date falls between V5 and V7 of the sheet1 then NAR. If it falls on or after V7 of sheet1 then issue.
If any V is blank then should show a msg that this V is missing. (Like 1001 V7 missing so when we check V7 date, then msg should come V7 missing in sheet2).
I have attached the sample data
Many of us, including myself, won't open an binary files, especially not office-files, so please post data in usable form: a data step using datalines or proc sql with create table and insert.
Please provide the data as SAS data step code (instructions), we can't write code unless we have the data in a SAS data set.
Question — you said
If V3 date falls between V3 and V5 of the sheet1 then NAR. If it falls on or after V5 of sheet1 then issue.
Wouldn't V3 by definition be between V3 and V5? How can V3 be not between V3 and V5?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.