topic ODS Excel through Proc Print and truncating numeric field in SAS Programming

ODS Excel through Proc Print and truncating numeric field

channa43 — Fri, 13 Sep 2019 03:40:27 GMT

ods tagsets.excelxp
options(sheet_name="Business Interruption"
autofit_height='yes' frozen_headers='yes' autofilter='yes' embedded_titles='yes' );

title "2,2820 records (2010), 2,2828 records (Now)";
proc print data=buss_int label noobs;

run;

ods tagsets.ExcelXP close;
ods results;

when the excel output is created it truncates the Geo code field, I am trying to stop truncating this specific field

Appreciate yoyr help

Cheers

Re: ODS Excel through Proc Print and truncating numeric field

ChrisNZ — Fri, 13 Sep 2019 03:58:24 GMT

It looks like the default format is too short for you (Goodness knows why SAS Institute chose best12. as default! )

This works fine if you add a format statement:

ods tagsets.excelxp file="%sysfunc(pathname(WORK))\t.xls";
ods tagsets.excelxp
options(sheet_name="Business Interruption"
autofit_height='yes' frozen_headers='yes' autofilter='yes' embedded_titles='yes' );

data BUSS_INT; 
 X=1234567890123; output;
 X=123.4567890123; output;
 format X best32.16;
run;
proc print data=BUSS_INT label noobs;
run;

ods tagsets.ExcelXP close;

Re: ODS Excel through Proc Print and truncating numeric field

channa43 — Fri, 13 Sep 2019 04:09:34 GMT

Thanks Chris, yes it works
Appreciate it, cheers