topic Re: Three consecutive records. in SAS Programming

Three consecutive records.

u52766097 — Tue, 19 Apr 2022 04:34:00 GMT

how do we get three consecutive records with flag = 'Y after sorting dataset by USUBJID and Date?

data counter;
input usubjid $ flag $ date mmddyy10.;
format date mmddyy10.;
datalines;
A Y 1/01/2013
A Y 1/01/2013
A N 1/03/2013
A Y 1/04/2013
A Y 1/05/2013
A . 1/06/2013
A Y 1/07/2013
;
run;

Re: Three consecutive records.

Kurt_Bremser — Tue, 19 Apr 2022 04:50:37 GMT

The dataset is already sorted by usubjid and date, and there is no such sequence. Please explain (by posting an intended result) what you really want.

Re: Three consecutive records.

u52766097 — Tue, 19 Apr 2022 19:54:04 GMT

if suppose ,I have another data then how will I get the three consecutive 'Y'? how many ways we can find the three consecutive 'Y'?

Re: Three consecutive records.

ballardw — Tue, 19 Apr 2022 20:33:46 GMT

@u52766097 wrote:

if suppose ,I have another data then how will I get the three consecutive 'Y'? how many ways we can find the three consecutive 'Y'?

Since your current example data contains no three consecutive 'Y', there is no way.

Provide example data that actually has three consecutive 'Y' and what the result should be.

And if there is another data (set?) you need to provide an example of that as well.