In that case, we should consider each id, roll, num combination a single group. ... View more

I forgot to add something previously. Sometimes the num and roll values will change and the rest ( id) remains same. For example : 1411 69 115 1411 70 116 1411 71 117 . . . Likewise so on. ... View more

data WORK.have; input DATE1 :DATE9. DATE2 :DATE9. ID:4. ROLL:2. NUM:3. AMOUNT:2.; datalines; 01JAN2022 20APR2022 1411 69 115 1 01FEB2022 30JAN2022 1411 69 115 2 01FEB2022 30JAN2022 1411 69 115 3 03MAR2022 21FEB2022 1412 70 116 1 04MAR2022 29JAN2022 1412 70 116 2 ;;;; Here's the data step code of the dataset. The records were sorted based on date1, DATE2, id, roll, num and the primary keys for this dataset is id, roll, num. Based on these 3 variables the data is inter linked with eachother. When comes to what I require is I require the rows of 1st appearance of Id, roll, num only when the DATE1 is >= DATE2. This DATE1 >= DATE2 should apply only when the 1st appearance of Id, roll, num. If this fails, please keep an OR condition by saying the amount values should be compared to prior and next value of eachother and when there's an increase in the amount variable values then the row which has max amount value should be picked and it must meet the base condition which is DATE1 >= DATE2. Example : 01JAN2022 20APR2022 1411 69 115 1 01FEB2022 30JAN2022 1411 69 115 2 01FEB2022 30JAN2022 1411 69 115 3 03MAR2022 21FEB2022 1412 70 116 1 04MAR2022 29JAN2022 1412 70 116 2 In the given example above, the DATE1 value is not >= DATE2 for the 1st appearance of Id, roll, num so, it fails then for the next two values the amount is increased i.e 1,2,3 so, for this case the max amount value which is 3 that row should be picked and also the base condition is met 01FEB2022 >= 30JAN2022. This is one iteration. For the 2nd iteration i.e as the id, roll, num is changed that's why I said it as 2nd iteration. So, in the 2nd iteration the 1st appearance of Id, roll, num(i.e 1412 70 116) met the basic condition i.e 03MAR2022 >= 21FEB2022 this row should be picked. once this condition is pass, it shouldn't go to OR condition. I hope this makes sense to y'all. Thankyou. ... View more

In this the if condition should apply first then after where condition should apply but it applied oppositely that's what I don't require. Please do make changes accordingly. Thankyou ... View more

Thank you veryyy muchh, it worked nicely. I would like to add some more info to where condition in your code. My data table has 6 variables named sas_date,old_date,id,roll,num, amount. I'm unable to add the dataset here, I strongly apologize for that. After using your code, I closely monitored the output dataset, it met the where condition but it didn't take first.num value so for those cases Please do keep an or condition where if sas_date ge old_date fails and it unable to take the first.num then when there's a increase in amount field that row should be picked and the sas_date>=old_date should also match. Thankyou. ... View more

Thankyou for your assistance, this is the way I want to do. I used your code but it got an error like by variables are not properly sorted Even though they are sorted. Please advise me ... View more

Data want; Set have; by id roll num; If (first.id and first.roll and first.num)=1 and sas_date >=old_date Then output; run; I sorted the dataset by using those 3 variables and using first keyword to get the 1st variable which should meet the condition sas_date>=old_date but it isn't working instead it is giving me a blank data ... View more

Could you please provide me an example. When I try it on my side it gave me the blank data. ... View more

I apologise, I tried my best to walk you through this. Even if you still don't understand, can you atleast help me on comparing two sas date variables which are in date9 format. Thankyou. The comparison should be like sas_date >= date1 ... View more

I've two date variables 1. Sasdate 2.date1 And both these two are valid for whole Id,term, project variables. ... View more

I've a date variable which is in date9 format. ... View more

Can we find the earliest date by using min function with a date9 format . Please provide an example for it. Thankyou. ... View more

Atleast, please do let me know how to find the earliest date in a bunch of date values. Thankyou. ... View more

Please ignore the errors which I wrote in data step, but please do understand the requirements. Thankyou. ... View more