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 (November 2006, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 27 Nov 2006 19:35:31 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: is there another way doing it
Comments: To: proccontents@GMAIL.COM
In-Reply-To:  <c2192a610611270926y2acc958bj24b0662f0bfc6670@mail.gmail.com>
Content-Type: text/plain; format=flowed

if ( ( Parnam1c = 'BAS' ) And Upcase( Preunt1c ) = '%' And ( LABRSL1N > 6 ) ) Or ( ( Parnam1c = 'EOS' ) And Upcase( Preunt1c ) = '%' And ( LABRSL1N > 10 ) ) Or ( ( Parnam1c = 'HGB' ) And Upcase( Preunt1c ) ='G/L' And ( ( LABRSL1N < 100 ) Or ( LABRSL1N > 200 ) ) Or ( ( Parnam1c = 'HCT' ) And Upcase( Preunt1c ) = '1' And ( ( LABRSL1N < 0.3 ) Or ( LABRSL1N > 0.6 ) ) Or ( ( Parnam1c = 'LYM' ) And Upcase( Preunt1c ) = '%' And ( ( LABRSL1N < 10 ) Or ( LABRSL1N > 60 ) ) Or ( ( Parnam1c='MON' ) And Upcase( Preunt1c ) = '%' And ( LABRSL1N > 20 ) Then Output ;

If the conditions are not mutally exclusive then you can start bundleing things up using 'IN' operatoe which will clean the look of the code up as well as speeding up the code.

if ( ( Parnam1c In ( 'BAS' 'EOS' 'HGB' 'HCT' 'LYM' 'MON') And ( Upcase( Preunt1c ) In ( '%' 'G/L' '1' ) ) And ( ( LABRSL1N > 6 ) Or ( LABRSL1N > 10 ) Or ( LABRSL1N < 100 ) Or ( LABRSL1N > 200 ) Or ( LABRSL1N < 0.3 ) Or ( LABRSL1N > 0.6 ) Or ( LABRSL1N < 10 ) Or ( LABRSL1N > 60 ) Or LABRSL1N > 20 ) ) Then Output ;

Toby Dunn

Quickly, bring me a beaker of wine, so that I may wet my mind and say something clever. Aristophanes

Wise people, even though all laws were abolished, would still lead the same life. Aristophanes

You should not decide until you have heard what both have to say. Aristophanes

From: SAS_learner <proccontents@GMAIL.COM> Reply-To: SAS_learner <proccontents@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: is there another way doing it Date: Mon, 27 Nov 2006 11:26:02 -0600

Hello guys for a listing I need to do something like this for couple of different values of Parnam1c, What I am looking is there a better way to dot it or is this only way to do it

if parnam1c='BAS' and upcase(preunt1c)='%' and ( LABRSL1N> 6) then output; if parnam1c='EOS' and upcase(preunt1c)='%' and ( LABRSL1N> 10) then output; if parnam1c='HGB' and upcase(preunt1c)='G/L' and (LABRSL1N<100 or LABRSL1N>200) then output; if parnam1c='HCT' and upcase(preunt1c)='1' and (LABRSL1N<0.3 or LABRSL1N>0.6) then output; if parnam1c='LYM' and upcase(preunt1c)='%' and (LABRSL1N<10 or LABRSL1N> 60) then output; if parnam1c='MON' and upcase(preunt1c)='%' and ( LABRSL1N> 20) then output;

thanks

_________________________________________________________________ Share your latest news with your friends with the Windows Live Spaces friends module. http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mk


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