|Date: ||Wed, 6 Mar 2002 16:59:31 -0500|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Abdu Elnagheeb <abdu.elnagheeb@BANKOFAMERICA.COM>|
|Subject: ||Re: SQL- Numeric/Char transformtaion|
|Content-type: ||text/plain; charset=us-ascii|
Thanks to ALL those who responded to my question. All the answers point to
the same thing as indicated below and it work for me.
Thanks a lot and have a nice one.
Robert Abelson <email@example.com> on 03/06/2002 04:12:46 PM
To: Abdu Elnagheeb/USA/BAC@BankofAmerica, SAS-L@LISTSERV.UGA.EDU
Subject: RE: SQL- Numeric/Char transformtaion
How about this:
PROC SQL ;
Create table temp as
input(X,4.) as y
6001 Montrose Rd.
Rockville, MD 20852
> -----Original Message-----
> From: Abdu Elnagheeb [SMTP:abdu.elnagheeb@BANKOFAMERICA.COM]
> Sent: Wednesday, March 06, 2002 3:41 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: SQL- Numeric/Char transformtaion
> Hope someone can help on this.
> Inside data step you can covert a char into numeric by using (for e.g.):
> y = X + 0 ;
> where X is Char (i.e. '1' '5' '11' ,...etc).
> How can you achieve that within PROC SQL?
> PROC SQL ;
> Create table as temp
> (X + 0) as y
> will NOT work.
> Please, send answer to me as I have to access to list now. Thanks so