LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (March 2002, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 1 Mar 2002 09:02:13 -0600
Reply-To:     Larry Hoyle <lhoyle@KU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Larry Hoyle <lhoyle@KU.EDU>
Organization: University of Kansas Computing Services
Subject:      Re: Coalesce

Coalesce is also described in "SAS SQL Procedure User's Guide, Version 8" which, by the way, is a very nice manual - having (or is it "with") many examples. -- Larry Hoyle Policy Research Institute University of Kansas, Blake Hall 1541 Lilac Lane, Room 607 Lawrence, KS 66044-3177

_________________________________ | lat/long: 38.57.24 / 95.14.36 \ | --> * < | Voice: (785) 864-9110 | | FAX: (785) 864-3683 | | EMAIL: LarryHoyle@ku.edu | |___________________________________| http://www.ku.edu/pri

About that bumper sticker that demands "Question Authority": Who says so?

"Jack Hamilton" <JackHamilton@FIRSTHEALTH.COM> wrote in message news:sc7cdd15.015@firsthealth.com... > I think of it as "choose the first non-missing value". > > > > > -- > JackHamilton@FirstHealth.com > Manager, Technical Development > METRICS Department, First Health > West Sacramento, California USA > > > >>> "Michael L. Davis" <michael@BASSETTCONSULTING.COM> 02/27/2002 10:54 > AM >>> > Hello Myra, > > I'm sure is it documented somewhere but here is my understanding of > the > Coalesce function. Consider the following example: > > newstuff=coalesce(updt_var, hist_var) ; > > If updt_var is non-missing, newstuff is equal to updt_var. Otherwise, > newstuff is equal to hist_var. > > HTH. > > - Michael "Mad Doggy" Davis > > At 08:51 AM 2/27/2002 -0800, Myra Oltsik <myra@DATASQUARE.COM> wrote: > >I got a copy of an SQL query from someone to show me how he extracted > >data. It has the funciton COALESCE in it. Thought the SAS On-line > >documentation mentions it, the doc doesn't define it. From what I can > >tell, it concatinates two variables/columns into one. Am I correct? > > > >Thanks. > >Myra > > Michael L. Davis > Vice President > Bassett Consulting Services, Inc. > 10 Pleasant Drive > North Haven CT 06473-3712 > E-Mail: michael@bassettconsulting.com > Web: http://www.bassettconsulting.com > Telephone: 203-562-0640 > Facsimile: 203-498-1414 > Messages: 888-477-1412


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