LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page