Date:         Sat, 12 Jan 2008 11:17:02 -0800
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Changing an ID from scientific notation in proc print output
Comments: To: egrogan <erinlgrogan@GMAIL.COM>
In-Reply-To:  <b5a7d17b-eeed-4f19-8be4-23497fc10af0@i3g2000hsf.googlegroups.com>
Content-Type: text/plain; charset="ISO-8859-1"

The most likely problem is that the ID numbers are too wide to fit into
the default column width.  When that happens, SAS chooses a format that
will make them fit - a sort of Procrustean Bed for numbers.

Try adding a format to the PROC PRINT; for example:

   proc print data=admin;
      format idnum 15.0;
   run;

"15" should be replaced by the number of places you want to show.  If
you want leading zeros to appear, use z15. instead.

If that solves the problem, you should add the appropriate format to the
original data set.  Then you won't have to specify it in every PROC
PRINT.  You might want to read more about formats in
<http://support.sas.com/onlinedoc/913/getDoc/en/lrcon.hlp/a002612372.htm>.



On Sat, 12 Jan 2008 10:59:40 -0800, "egrogan" <erinlgrogan@GMAIL.COM>
said:
> Hi all,
> I am a *very* new SAS user, and am trying to get around a problem
> where ID numbers are printing in scientific notation in a proc print
> output. This is making it very frustrating to track individuals over
> time. I'm working with a very large state administrative dataset-
> about 4 million records- and need to be able to see the full ID
> numbers in the same output that includes 5 or 6 other variables. Any
> help would be appreciated.


--
Jack Hamilton
Sacramento, California
jfh@alumni.stanford.org