Paul, I feel kind of stupid. I just checked the input file and it does contain "2.00107E+11"... The input file was created via excel(csv) downloaded to the mainframe. Creating an excel CSV file must convert large numbers to expontial - - I will have to check in the EXCEL side of the fence.

Thanks, Jim

"Choate, Paul/@DDS" <pchoate on 06/03/2004 11:17:04 AM

To: James J Byrnes/MN/Unitedmail@Unitedmail, SAS-L@LISTSERV.UGA.EDU cc: Subject: RE: Perserving character format on output output of a numeric val ue

Jim -

SAS read "2.00107E+11" not "200107201413" from your source. As Mark said the problem occurs where the input file was created or before, not when you read the file by SAS.

hth

Paul Choate DDS Data Extraction (916) 654-2160

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jim Byrnes Sent: Thursday, June 03, 2004 8:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Perserving character format on output output of a numeric value

I have read in an input file and one of the variables is ACCT_TXT which is defined has :$48. (character).

And it hums along unitl it comes to some numbers in the field and it sometimes outputs them in exponential notation(whenever number is greater than 9 digits long) and I want it left in regular number format (character)...

see below: ACCT_CODE ACCT_TXT METL7079 IMCS CICS APPL SECURITY METL7088 MET REVIEW STATS METL7105 UHC CUSTOMER RPTG METL7108 MICR REPRINT METL9340 UNITED FRONT END METL9885 LASER NET METP0001 2.00107E+11 METP0002 301230912

The 2.00107E+11 should read 200107201413... I can I preserve the actual numeric number versus the exponential it outputs???

Thanks, Jim

(See attached file: C.htm)

This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.