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 2009, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 14 Oct 2009 08:50:06 -0700
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Re: If then else logic Not working
Comments: To: such <such.jain@gmail.com>
In-Reply-To:  <48ec11ce-eff4-4bc4-914d-c7178521e242@k13g2000prh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Thank you all for explanation, I understand what mistake I was doing , Thank you all for your time and help

SL

On Tue, Oct 13, 2009 at 2:47 AM, such <such.jain@gmail.com> wrote:

> Hello, > > Patrick is correct that you have to reprogram your if else condition > because third condition will never be selected. Following code might > help. > > Data test ; > set test ; > if Case2= 3 Then do; > if case = 1 then do; > if Case1 = 2 then Misswk33 = 'N'; > else Misswk33 = 'Y'; > end; > else Misswk33 = 'N'; > end; > Run; > > The above code will help you to get desirable results. > > Regards, > > Such > > On Oct 13, 11:21 am, procconte...@GMAIL.COM (SAS_learner) wrote: > > hello guys , > > > > my conditions are > > > > If Case =1 and case1 = 2 and case3 = 3 then Misswk33 = N > > > > Else If Case =1 and case3 = 3 then Misswk33 =Y > > > > Else If Case2 = 3 Then Misswk33 = N ; > > > > But some Misswk33 is not properly populated > > > > Data test ; > > Input Usubjid $4. case case1 case2 ; > > datalines ; > > 1001 . . 3 > > 1001 . . 3 > > 1002 1 2 3 > > 1002 1 2 3 > > 1003 1 . . > > 1004 1 . 3 > > 1004 1 . 3 > > ; > > Run; > > > > Data test ; > > set test ; > > if (Case =1 ) and (Case1 = 2 ) and (Case2= 3) Then Misswk33 = 'N'; > > Else If (Case2= 3) Then Misswk33 = 'N'; > > Else if (Case =1 ) and (Case2= 3) Then Misswk33 = 'Y'; > > Run; > > > > /*Some how Misswk33 is getting value N only */; >


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