Exporting with Formats and Column Widths

BCNAV — Thu, 18 Jan 2018 20:39:14 GMT

I have a customer file that is all formatted the way we want (including some currency formats). I have written a macro that lets the user enter the customer numbers they want and the output is Excel, but only via proc export. I need to be able to ensure that ALL FORMATS (including currency) are passed through to the resulting Excel files. I also need to ensure that all column widths are 12. I am not experienced in ODS, so I'm hoping some quick code from the experts here can help me learn.

I had started with:

ods listing close;
ods html close;
goptions device=actximg;

ods excel file="\\NCRFP4\TAF\Traffic Forecasting\TFM 3.0\Refund_&custID.xlsx";
ods excel options(start_at="1,1" sheet_name="&CustID" sheet_interval="table" embedded_titles='yes');
proc print data=EGTASK.RUNWAY_&CustID noobs; run;
ods excel close;

but I don't think proc print is what is to be used as I got an out of memory error.

Also, is there a way to eliminate the report file that is made with ODS?

thx!

Re: Exporting with Formats and Column Widths

ChrisNZ — Sun, 21 Jan 2018 21:20:17 GMT

1- Out of memory error with proc print??

How large is the table? How long are the variables?

2- .... a way to eliminate the report file

Like this: ODS _all_ close; ?

3- Many resources about formatting excel columns, just search.

For example:

https://support.sas.com/rnd/base/ods/odsmarkup/TipSheet_ods_xl_xp.pdf

https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-change-the-column-width-with-ods-excel-sas-9-4/td-p/317142

topic Re: Exporting with Formats and Column Widths in SAS Programming

Exporting with Formats and Column Widths

Re: Exporting with Formats and Column Widths