Hi;

I had occasion to look in to this recently. It seems that the largest integer that SAS recognizes on most platforms retains only 15 significant digits. the length (in bytes) is 8 which makes the very largest integer 9,007,199,254,740,992. The only way I see to get around it is to read it as text, as you surmised.

Thanx, Roger S. Clark Address Coverage Assurance Programs Branch

> -----Original Message----- > From: SUBSCRIBE SAS-L Chandra Gadde [mailto:ddraj2015@GMAIL.COM] > Sent: 14 June 2007 16:05 > To: SAS-L@LISTSERV.UGA.EDU; Ben Powell > Cc: SUBSCRIBE SAS-L Chandra Gadde > Subject: Re: ODS HTML -- Generating XLS file > > Thank you Ben. > > If I had to get the output, I have to read this variable as CHARACTER. > Is that true? Because when I tried this code by defining the same > variable as numeric, it didn't work. I think SAS itself reads a numeric > variable in SCIENTIFIC format. > > This is the code that works. > > data abc; > input x $24.; > cards; > 1234569877565253 > 1234569877565255 > 87434569877565258 > 1634569877565259 > 1234569877565252 > 26534569877565253 > ; > run; > > ods results off; > ods html style = SASdocVerySmall; > ods html file="c:\great3.xls" (no_top_matter); ods html style = > SASdocVerySmall; title "title"; proc print data=abc; var x / > style(data)={htmlstyle= "mso-number-format:\@"}; var x; run; title; ods > html close;