Date: Fri, 20 Apr 2007 04:31:51 -0700
Reply-To: "email@example.com" <ajs2004@BIGFOOT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "firstname.lastname@example.org" <ajs2004@BIGFOOT.COM>
Subject: Re: floating point and scientific notation - please help!
Content-Type: text/plain; charset="iso-8859-1"
Take an output data set from PROC FREQ and then use that for the
On Apr 20, 12:07 pm, "nicola.daw...@googlemail.com"
> I am new to SAS but have been on a fundamentals training course. I'm
> running Proc Freq on my data and it produces some outputs with large
> numbers (upto 8 characters), on the output screen SAS truncates these
> values using scientific notation for instance 34523349 becomes 3.45E7.
> If I copy the output and paste it into excel it only pastes the
> truncated value, which I expected, but if I use the Proc Print To
> statement and print to a CSV file the same problem still occurs. This
> is a major problem for me as the number then becomes 34500000 and I
> will be summing a series of these numbers and using them to generate
> prevalence data so I need more precision.
> Does anyone know how to stop SAS from doing this? I have noticed that
> when I generate just 1 column of data it displays the full number, but
> when there are 3 columns it truncates the numbers. I have set the
> linesize to maximum and this seems to make no difference. Is there
> anyway of specifying the width of individual columns in a Proc Freq
> output? Or of forcing SAS to display full numbers?
> Any help will be gratefully received