topic how to find a date if it falls between a range of date in SAS Programming

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

Snum — Tue, 21 Dec 2021 04:59:47 GMT

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

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

andreas_lds — Tue, 21 Dec 2021 05:47:34 GMT

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.

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

PaigeMiller — Tue, 21 Dec 2021 11:57:28 GMT

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?

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

Snum — Wed, 05 Jan 2022 14:27:51 GMT

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.