https://communities.sas.com/t5/SAS-Programming/Hoe-can-I-flag-the-last-record-who-has-AVALC-Y-record-prior-to/m-p/921152#M362755 <P>Hi, I need to flag the last AVALC = 'Y' record prior to this AVALC='N' record. For example,</P><P>for the following dataset, I need to flag the third A record and second B subjid . Thank you so much</P><P>&nbsp;</P><P>data have;<BR />input usubjid $ ADY AVALC $;<BR />datalines;<BR />A 15 N<BR />A 36 N<BR />A 57 Y<BR />A 60 N<BR />A 61&nbsp; Y<BR />A 62 N<BR />A 63 Y<BR />A 64 Y<BR />A 65 Y<BR />B 15 Y<BR />B 36 Y<BR />B 57 N<BR />B 58 N<BR />B 60 Y<BR />;<BR />run;</P> Wed, 20 Mar 2024 18:02:01 GMT SerenaJJ 2024-03-20T18:02:01Z https://communities.sas.com/t5/SAS-Programming/Hoe-can-I-flag-the-last-record-who-has-AVALC-Y-record-prior-to/m-p/921152#M362755 <P>Hi, I need to flag the last AVALC = 'Y' record prior to this AVALC='N' record. For example,</P><P>for the following dataset, I need to flag the third A record and second B subjid . Thank you so much</P><P>&nbsp;</P><P>data have;<BR />input usubjid $ ADY AVALC $;<BR />datalines;<BR />A 15 N<BR />A 36 N<BR />A 57 Y<BR />A 60 N<BR />A 61&nbsp; Y<BR />A 62 N<BR />A 63 Y<BR />A 64 Y<BR />A 65 Y<BR />B 15 Y<BR />B 36 Y<BR />B 57 N<BR />B 58 N<BR />B 60 Y<BR />;<BR />run;</P> Wed, 20 Mar 2024 18:02:01 GMT https://communities.sas.com/t5/SAS-Programming/Hoe-can-I-flag-the-last-record-who-has-AVALC-Y-record-prior-to/m-p/921152#M362755 SerenaJJ 2024-03-20T18:02:01Z https://communities.sas.com/t5/SAS-Programming/Hoe-can-I-flag-the-last-record-who-has-AVALC-Y-record-prior-to/m-p/921153#M362756 How* Wed, 20 Mar 2024 18:04:53 GMT https://communities.sas.com/t5/SAS-Programming/Hoe-can-I-flag-the-last-record-who-has-AVALC-Y-record-prior-to/m-p/921153#M362756 SerenaJJ 2024-03-20T18:04:53Z