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.

abdu

Robert Abelson <rabelson@kai-research.com> on 03/06/2002 04:12:46 PM

To: Abdu Elnagheeb/USA/BAC@BankofAmerica, SAS-L@LISTSERV.UGA.EDU cc: Subject: RE: SQL- Numeric/Char transformtaion

Abdu,

How about this:

PROC SQL ; Create table temp as select input(X,4.) as y from whatever; quit;

HTH.

Bob Abelson KAI 6001 Montrose Rd. Suite 920 Rockville, MD 20852 T: 301-770-2730 F: 301-770-4183 rabelson@kai-research.com

> -----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 > > Hello, > 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 > select > (X + 0) as y > > will NOT work. > > Please, send answer to me as I have to access to list now. Thanks so > much. > > abdu