LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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

*


Back to: Top of message | Previous page | Main SAS-L page