topic Re: PROC REPORT Compute/Display in SAS Programming

PROC REPORT Compute/Display

JHE — Thu, 19 Oct 2017 16:28:44 GMT

I have tow questions about PROC REPORT:

1. My SAS code :

I need computed column with Cellwidth wide enough to hold % with certain length, otherwise will miss value or empty, the following code no errors but would not working either.

My Code as following:

define ConfigRework_Percent/COMPUTED 'ConfigRework_Percent' FORMAT=percent10.2 style=[tagattr="format:#,###.00%"] style(column)=[cellwidth=1.4in];

compute ConfigRework_Percent;

ConfigRework_Percent=_c19_/_c12_;

endcomp;

Re: PROC REPORT Compute/Display

error_prone — Thu, 19 Oct 2017 16:33:28 GMT

You are creating an excel-file? Are you using tagset.excelxp or excel?

Please post code using {i} or running-man-icon to preserve formatting.

Re: PROC REPORT Compute/Display

JHE — Thu, 19 Oct 2017 16:40:50 GMT

Yes , ods excel.xlsx file.

Original: FORMAT=percent10.2 style=[tagattr="format:#,###.00%"];

Change to ?: FORMAT=percent10.2 style={[tagattr="format:#,###.00%"](column)=[cellwidth=1.2in]}

;

Re: PROC REPORT Compute/Display

error_prone — Thu, 19 Oct 2017 16:51:36 GMT

Back in the old days column-width could be specified in the ods-statement, not sure if ods excel still has that option. I can't test your code, because you have not provided test-data and the complete proc report code.