Anybody know how to export a 13 digit number to excel without it coming out in scientific notation?
How are you currently "exporting" the values.
And have you tried making the column wider in Excel?
@tomrvincent wrote:
I'm trying not to do anything in excel manually (that would be too easy...plus I'm dealing with several dozen monthly files).
I wanted to simply send it as a CSV or text, but the customer is a moron who doesn't know how Excel works.
I just wondered if anyone had a quick fix for this nonsense.
That is part of why I asked HOW you are exporting the data. The ODS EXCEL supports an option Absolute_column_width. The following example sets all of the columns to a width of 16
ods excel file='footer.xlsx' options(absolute_column_width='16'); proc print data=sashelp.class(obs=5); run; ods excel close;
Or to set width per column:
ods excel file='x:\footer.xlsx' options(absolute_column_width='16,5,8,10,10' ); proc print data=sashelp.class(obs=5); run; ods excel close;
ods tagsets.excelxp creates excel readable XML with the same options if you don't have SAS/Access Interface to PC Files
@tomrvincent wrote:
tried it with 5 records and still get scinote in the resulting file. Width had no effect.
What is the actual format associated with the variable?
If you use Proc Print as a basic ODS generator then the format applies. If you have a format of best8., or just about anything with a less than 13, or possibly 14, width you'll get some form of truncation or rounding.
data _null_; x= 123456781234; put x best8.; put x best11.; put x best13.; run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.