All,
This is the data set I have
Id res
111 YYY
111 XXX
111 NNN
222 YYY
222 YYY
222 NNN
222 XXX
222 PPP
222 XYZ
222 HAB
222 XCV
This is the dataset I am looking for (i.e the res should be missing for the records that are after first XXX)
Id res
111 YYY
111 XXX
111
222 YYY
222 YYY
222 NNN
222 XXX
222
222
222
222
Thanks
-Bhargav
Create a flag and use RETAIN to hold it across rows.
Data want;
srt have;
by id;
retain flag;
if first.id then flag=0;
if flag=1 then call missing(res);
if res='XXX' then flag=1;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.