how to find a date if it falls between a range of date

[Snum]

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

[andreas_lds]

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.

[PaigeMiller]

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?

[Snum]

Hi Paige Miller;
Yes you are correct :). I have had asked my colleague to explain and help me understand the situation. It was my misunderstanding.