Date:         Fri, 20 Apr 2007 04:31:51 -0700
Reply-To:     "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Organization: http://groups.google.com
Subject:      Re: floating point and scientific notation - please help!
Comments: To: sas-l@uga.edu
In-Reply-To:  <1177067269.235237.196250@y80g2000hsf.googlegroups.com>
Content-Type: text/plain; charset="iso-8859-1"

Take an output data set from PROC FREQ and then use that for the
subsequent processing.

http://support.sas.com/onlinedoc/913/getDoc/en/procstat.hlp/freq_sect9.htm#basestat_freq_freqoutput
http://support.sas.com/onlinedoc/913/getDoc/en/procstat.hlp/freq_sect30.htm


On Apr 20, 12:07 pm, "nicola.daw...@googlemail.com"
<nicola.daw...@googlemail.com> wrote:
> 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
>
> Nic.