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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.