Hi All, Thank you for the Suggestions and Corrections. I was able to correct it. ... View more

Hi sorry for the late reply, but i did mentioned in previous messages that dat e is charecter, I will try this ... View more

data test; input ID$ phase $ date $; datalines; 001 Active 08/31/2023 001 Closed 09/29/2023 001 Active 10/23/2023 001 Active 11/25/2023 002 Active 07/22/2023 002 Active 08/13/2023 003 Active 02/12/2022 003 Active 03/14/2022 003 Active 04/15/2022 003 Active 01/10/2022 004 Active 03/15/2022 004 Active 01/16/2022 004 Closed 04/23/2022 004 Active 06/26/2022 004 Active 07/23/2022 005 Active 12/01/2022 005 Active 01/10/2023 005 Active 04/23/2023 005 Closed 02/12/2023 005 Active 03/12/2023 ; run This is my dataset and need to create a validation rule to throw all improper records after the account is closed for each account ... View more

I cant create a datastep , i was asked to create a validation rule need that if statement which compares for any account if the phase is closed and have records after that ... View more

I have tried like this    If phase = "Closed" and input (date,mmddyy10.) < max(input (date,mmddyy10.) then do; error = "Account_closed"; output; end;   but it dint thrown me any results .. ... View more

Hi Thank you so much for the quick reply. Date is a character and Id is the identification number data test; input ID$ phase $ date $; datalines; 001 Active 08/31/2023 001 Closed 09/29/2023 001 Active 10/23/2023 001 Active 11/25/2023 ; run; I need the output with the last two rows as they have been recorded after the phase is closed Here I have given the dates in order, but in raw dataset its not sorted ... View more

Thank you so much it worked for me ... View more

Hi Great thanks once again, in my old data set i have id gender, addm phone and many variables including this DOB. So in my trans dataset according to you can there be onlt two variables (ID, Dob) and can do update still ... View more

Hi , Great thanks for the quick response. Actually i am updating a dataset for which few ids have DOB and for few of them missing. Thats the reason I am updationg DOBs for missing ids. ... View more

I want the output like this . But then if you observe the employee is with d004 department till 26th june 2000. I am really not having any clue how to do this emp_no salary from_date to_date Department 10010 72488 24/11/1996 24/11/1997 d1004 10010 74347 24/11/1997 24/11/1998 d1004 10010 75405 24/11/1998 24/11/1999 d1004 10010 78194 24/11/1999 23/11/2000 d1004 10010 79580 23/11/2000 23/11/2001 d006 10010 80324 23/11/2001 01/01/9999 d006 ... View more