topic Export to Excel - how to keep defalut excel column width in SAS Programming

Export to Excel - how to keep defalut excel column width

Ivan555 — Tue, 18 Jun 2019 16:00:32 GMT

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!

Re: Export to Excel - how to keep defalut excel column width

Reeza — Tue, 18 Jun 2019 16:21:05 GMT

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.

Re: Export to Excel - how to keep defalut excel column width

Ivan555 — Tue, 18 Jun 2019 16:48:11 GMT

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