Date: Tue, 16 Nov 1999 15:20:53 -0800
Reply-To: "Berryhill, Tim" <TWB2@PGE.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Berryhill, Tim" <TWB2@PGE.COM>
Subject: Re: adding alpha and numeric
Ruben, Are you always willing to drop the last two characters of HGS_CODE?
If so, you could use the SUBSTR function:
* Now use the SUBSTR func and concatenation operator ;
> From: Ruben J. Kovalcik[SMTP:rjk2@CORUSCANT.CET.NAU.EDU]
> Reply To: Ruben J. Kovalcik
> Sent: Tuesday, November 16, 1999 2:59 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: adding alpha and numeric
> Mr. Abelsor,
> thanks for the reply. here is a specific example: one variable hgs_code
> $3. describes a room type. another describes a more specific use of a
> room, hgs_cat $2.
> i want to combine the two variables to make one hgs_room $3.
> so a room with hgs_code of 100 and hgs_cat 15 would have a hgs_room 115,
> or a room with hgs_code XXX and hgs_cat XX would have hgs_room XXX.
> thanks for your help>Ruben