2 weeks ago
a week ago
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
a week ago
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;