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 (April 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 21 Apr 2004 15:15:45 -0700
Reply-To:     "Terjeson, Mark" <TERJEM@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <TERJEM@DSHS.WA.GOV>
Subject:      Re: Else if Help
Comments: To: "Pleasant, David (GE Consumer Finance)" <David.Pleasant@GE.COM>
Content-Type: text/plain; charset=us-ascii

Hi David,

With proper punctuation in the assignment statements and around the comments, this seems to get TEST=1 for both. ????

data _null_;

Beg_Year_Mon = '200308'; bdue_stage = 4; bnarex = 483; Org_DOD = 9; bcurr_bal = 683.66; Org_Class = '4';

*This Works and sets Test =1.:; If Beg_Year_Mon LE '200307' or (Beg_Year_Mon GE '200308' and bdue_stage = 4 and (303 le bnarex le 483) and Org_DOD lt 36 and bcurr_bal ge 500 and Org_Class ne '8')or ( Beg_Year_Mon GE '200308' and bdue_stage = 4 and (484 le bnarex le 626) and bcurr_bal ge 1189 and Org_Class ne '8') then Test = 1; Else Test = 0;

put 'AAA' Test=;

*This set the value of TEST to 0 for the record described above.; If Beg_Year_Mon LE '200307' then Test = 1; else If Beg_Year_Mon GE '200308' and bdue_stage = 4 and (303 le bnarex le 483) and Org_DOD lt 36 and bcurr_bal ge 500 and Org_Class ne '8' then Test = 1; Else if Beg_Year_Mon GE '200308' and bdue_stage = 4 and (484 le bnarex le 626) and bcurr_bal ge 1189 and Org_Class ne '8' then Test = 1; Else Test = 0;

put 'BBB' Test=;

run;

/* log excerpt is

AAATest=1 BBBTest=1 NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds */

Hope this is helpful, Mark Terjeson Reporting, Analysis, and Procurement Section Information Services Division Department of Social and Health Services State of Washington mailto:terjem@dshs.wa.gov

-----Original Message----- From: Pleasant, David (GE Consumer Finance) [mailto:David.Pleasant@GE.COM] Sent: Wednesday, April 21, 2004 2:29 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Else if Help

This one has been driving me crazy. I have two if Then Statement that should both work, how ever only one does not. I have two records that are having the TEST value set to 0 when it should be set to 1. Why is this happening.

I have a record that has the following variables:

Beg_Year_Mon = '200308' bdue_stage = 4 bnarex l= 483 Org_DOD = 9 bcurr_bal = 683.66 Org_Class ne '4'

This Works and sets Test =1.: If Beg_Year_Mon LE '200307' or (Beg_Year_Mon GE '200308' and bdue_stage = 4 and (303 le bnarex le 483) and Org_DOD lt 36 and bcurr_bal ge 500 and Org_Class ne '8')or ( Beg_Year_Mon GE '200308' and bdue_stage = 4 and (484 le bnarex le 626) and bcurr_bal ge 1189 and Org_Class ne '8') then Test = 1; Else Test = 0;

This set the value of TEST to 0 for the record described above. If Beg_Year_Mon LE '200307' then Test = 1; else If Beg_Year_Mon GE '200308' and bdue_stage = 4 and (303 le bnarex le 483) and Org_DOD lt 36 and bcurr_bal ge 500 and Org_Class ne '8' then Test = 1; Else if Beg_Year_Mon GE '200308' and bdue_stage = 4 and (484 le bnarex le 626) and bcurr_bal ge 1189 and Org_Class ne '8' then Test = 1; Else Test = 0;

g GE Consumer Finance ____________________________________________________________________________ ___________________________________________ David Pleasant Programmer Analyst > GE Consumer Finance - North America 4500 Munson Street N.W. Canton, OH 44718 Phone: (330) 433-5816 Dial Comm 360-5816 Fax: (330) 433-5604 Dial Comm 360-5604 Pager (877) 680-8854 E-Mail: David.Pleasant@ge.com

"This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message."


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