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
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 |
About that bumper sticker that demands "Question Authority": Who says so?
"Jack Hamilton" <JackHamilton@FIRSTHEALTH.COM> wrote in message
> I think of it as "choose the first non-missing value".
> 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
> 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.
> - 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?
> Michael L. Davis
> Vice President
> Bassett Consulting Services, Inc.
> 10 Pleasant Drive
> North Haven CT 06473-3712
> E-Mail: email@example.com
> Web: http://www.bassettconsulting.com
> Telephone: 203-562-0640
> Facsimile: 203-498-1414
> Messages: 888-477-1412