BookmarkSubscribeRSS Feed
Snum
Calcite | Level 5

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

3 REPLIES 3
andreas_lds
Jade | Level 19

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
Diamond | Level 26

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?

--
Paige Miller
Snum
Calcite | Level 5
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1011 views
  • 0 likes
  • 3 in conversation