```Date: Thu, 8 Feb 2007 17:11:42 +0000 Reply-To: toby dunn Sender: "SAS(r) Discussion" From: toby dunn Subject: Re: In : Question Comments: To: iw1junk@COMCAST.NET In-Reply-To: <020820071656.806.45CB5631000D237600000326220730079305029A06CE9907@comcast.net> Content-Type: text/plain; format=flowed Ian , Thanks I had thought about case, truncation issues and leading blanks but not trailing blanks. Data _Null_ ; x = "red" ; If X In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; put y= ; x = "G" ; If Strip( X ) In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; put y= ; run ; Y= Y=Match Toby Dunn To sensible men, every day is a day of reckoning. ~John W. Gardner The important thing is this: To be able at any moment to sacrifice that which we are for what we could become. ~Charles DuBois Don't get your knickers in a knot. Nothing is solved and it just makes you walk funny. ~Kathryn Carpenter From: Ian Whitlock Reply-To: iw1junk@COMCAST.NET To: SAS-L@LISTSERV.UGA.EDU Subject: In : Question Date: Thu, 8 Feb 2007 16:56:17 +0000 Summary: Yes. #iw-value=1 Toby, There are many things you should be aware of, but I have no idea whether you are or are not. Some might be surprised at these tests, and some might not. 1 data _null_ ; 2 x = "G" ; 3 If X In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; 4 put y= ; 5 run ; Y=Match NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds 6 data _null_ ; 7 x = "red" ; 8 If X In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; 9 put y= ; 10 x = "G" ; 11 If X In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; 12 put y= ; 13 run ; Y= Y= Ian Whitlock ============== Date: Thu, 8 Feb 2007 16:19:51 +0000 Reply-To: toby dunn Sender: "SAS(r) Discussion" From: toby dunn Subject: In : Question Content-Type: text/plain; format=flowed Anyone know of something that I should be aware of when using the In operator and colon modifier together like: If X In : ( 'Red' 'Blue' 'Green' ) Then Y = 'Match' ; Toby Dunn To sensible men, every day is a day of reckoning. ~John W. Gardner The important thing is this: To be able at any moment to sacrifice that which we are for what we could become. ~Charles DuBois Don't get your knickers in a knot. Nothing is solved and it just makes you walk funny. ~Kathryn Carpenter _________________________________________________________________ Invite your Hotmail contacts to join your friends list with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us ```

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