Date: Wed, 3 Oct 2007 17:45:10 -0400
Reply-To: souga soga <souga1234@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: souga soga <souga1234@GMAIL.COM>
Subject: Flagging observations
Content-Type: text/plain; charset=ISO-8859-1
Hi ,
I have a data set:
DATA test;
x=.;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=10;OUTPUT;
x=10;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=20;OUTPUT;
x=20;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=30;OUTPUT;
x=40;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=.;OUTPUT;
x=50;OUTPUT;
x=60;OUTPUT;
RUN;
*
I would like to flag observations sequentially that start with the
first missing value and end with the last non-missing value.
Here is the expected output.
x=.;Flag=1;
x=.;Flag=1;
x=.;Flag=1;
x=10;Flag=1;
x=10;Flag=1;
x=.;Flag=2;
x=.;Flag=2;
x=.;Flag=2;
x=20;Flag=2;
x=20;Flag=2;
x=.;Flag=3;
x=.;Flag=3;
x=.;Flag=3;
x=30;Flag=3;
x=40;Flag=3;
x=.;Flag=4;
x=.;Flag=4;
x=.;Flag=4;
x=50;Flag=4;
x=60;Flag=4;
Thanks,
Sa
*