Export to Excel - how to keep defalut excel column width

[Ivan555]

Hello!

I am doing export sas data to excel through proc export.

My code looks like:

proc export data=table1
outfile=&path.
label dbms xlsx replace;
putnames=yes;
sheet='Sheet1'
%run

But when I am getting data to excel all columns are randomly autofitted.

Does anybody know, can I add something in the code to get excel column width being having default value(64)?

THX!

[Reeza · Accepted solution]

I don't believe there's a control for that in PROC EXPORT, but you could switch to ODS EXCEL and set the column width there manually. But it's slower and will apply formats.

[Ivan555]

Understood. Perhaps Ods Excel is the only solution. Thank you 🙂