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 (May 2002, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 2 May 2002 15:41:00 -0700
Reply-To:   Glenn Heagerty <gheagerty@ADELPHIA.NET>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Glenn Heagerty <gheagerty@ADELPHIA.NET>
Organization:   Consumer Solutions
Subject:   Re: Last non-Blank value
Comments:   To: Sheila Whitelaw <sw75@BOXFROG.COM>
Content-Type:   multipart/alternative;

Hi Sheila,

I have gotten quicker results (coding and processing) replacing lots of if-then-else statements with the SELECT statement, and for me it is easier to read and type. Here's how it would look:

data oset; set iset; select; when (dec02^='') prv=dec02; when (nov02^='') prv=nov02; when (oct02^='') prv=oct02; when (sep02^='') prv=sep02; when (aug02^='') prv=aug02; when (jul02^='') prv=jul02; when (jun02^='') prv=jun02; when (may02^='') prv=may02; when (apr02^='') prv=apr02; when (mar02^='') prv=mar02; when (feb02^='') prv=feb02; when (jan02^='') prv=jan02; otherwise; end; run;

Thanks,

Glenn


[text/html]


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