| Date: | Wed, 27 Feb 2002 13:54:24 -0500 |
|---|
| Reply-To: | "Michael L. Davis" <michael@BASSETTCONSULTING.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Michael L. Davis" <michael@BASSETTCONSULTING.COM> |
|---|
| Subject: | Re: Coalesce |
|---|
| In-Reply-To: | <5339ce5f.0202270851.5064365b@posting.google.com> |
|---|
| Content-Type: | text/plain; charset="us-ascii"; format=flowed |
|---|
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
| 
