|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
|Content-Type: ||text/plain; charset="us-ascii"|
I feel kind of stupid. I just checked the input file and it does contain
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.
"Choate, Paul/@DDS" <pchoate on 06/03/2004 11:17:04 AM
To: James J Byrnes/MN/Unitedmail@Unitedmail, SAS-L@LISTSERV.UGA.EDU
Subject: RE: Perserving character format on output output of a numeric val ue
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.
DDS Data Extraction
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Jim
Sent: Thursday, June 03, 2004 8:10 AM
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
METL7079 IMCS CICS APPL SECURITY
METL7088 MET REVIEW STATS
METL7105 UHC CUSTOMER RPTG
METL7108 MICR REPRINT
METL9340 UNITED FRONT END
METL9885 LASER NET
The 2.00107E+11 should read 200107201413...
I can I preserve the actual numeric number versus the exponential it
(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.