|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
> name = trim(lastname) || "," || " " || trim(fistname);
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).
Dansys Consultants Inc.