| Date: | Thu, 14 Oct 1999 11:27:29 -0400 |
|---|
| Reply-To: | Chad Worthman <chadw@BIGFOOT.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Chad Worthman <chadw@BIGFOOT.COM> |
|---|
| Organization: | Sprint Canada Inc. |
|---|
| Subject: | Re: How to merge two fields ? |
|---|
> You could concatenate them. Something like:
>
> name = fistname || lastname;
>
> If you want it to be something a little more "normal" you could do the
> following:
>
> name = trim(lastname) || "," || " " || trim(fistname);
> Alan
Another function you could use here is compbl();
name = compbl(lastname||", "||firstname);
compbl() is compress blanks, it compresses multiple blanks to one blank.
I only mention it because it isn't in the SAS Language manual that I have
(Version 6, First Edition).
---
Chad Worthman
Dansys Consultants Inc.
www.dansys.com
| 
