Date:         Thu, 17 Oct 2002 15:39:51 -0400
Reply-To:     Ed Heaton <EdHeaton@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ed Heaton <EdHeaton@WESTAT.COM>
Subject:      Re: Flag
Comments: To: Asheber Sewalem <sewalem@CDN.CA>
Content-Type: text/plain; charset="iso-8859-1"

Asheber;

Given the data set created below.
Data test ;
   Infile cards ;
   Input id  x1 ;
Cards4 ;
12  2
12  3
12 -1
13  5
13  6
13  6
14  4
14 -3
14  3
;;;;

You can use this two-step process.
Proc sql ;
   Create table flags as
      select id , min(x1) as min
      from test
      group by id
   ;
Quit ;
Data FlaggedTest(drop=min) ;
   Merge test flags ;
      By id ;
   If ( min < 0 )
      then flag = -2 ;
      Else flag =  2 ;
Run ;

Ed

Edward Heaton, Senior Systems Analyst,
Westat (An Employee-Owned Research Corporation),
1550 Research Boulevard, Room 2018, Rockville, MD 20850-3195
Voice:  (301) 610-4818                 Fax:  (301) 294-3992
mailto:EdHeaton@westat.com             http://www.westat.com

-----Original Message-----
From: Asheber Sewalem [mailto:sewalem@CDN.CA]
Sent: Thursday, October 17, 2002 2:46 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Flag


Hi all,

A simple question!
I have  two variables id and x1. I just want to flag all "Id" records -2
if any of the records x1 within id is less than 0 otherwise flag=2.

A sample data,

id  x1
12  2
12  3
12 -1
13  5
13  6
13  6
14  4
14 -3
14  3


The desired output should be the following,

id  x1 flag
12  2   -2
12  3   -2
12 -1   -2
13  5    2
13  6    2
13  6    2
14  4   -2
14 -3   -2
14  3   -2

Asheber