Date:         Thu, 3 Jun 2004 11:31:38 -0500
Reply-To:     James J Byrnes <james_j_byrnes@UHC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         James J Byrnes <james_j_byrnes@UHC.COM>
Subject:      Re: Perserving character format on output output of a numeric val
              ue
Comments: To: "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Content-Type: text/plain; charset="us-ascii"

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.