PROC REPORT Compute/Display

[JHE]

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;

[error_prone]

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.

[JHE]

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]}

;

[error_prone]

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.