DATA Step, Macro, Functions and more

PROC REPORT Compute/Display

Reply
Frequent Contributor
Frequent Contributor
Posts: 119

PROC REPORT Compute/Display

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;

 

 

 

Regular Contributor
Posts: 202

Re: PROC REPORT Compute/Display

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.

Frequent Contributor
Frequent Contributor
Posts: 119

Re: PROC REPORT Compute/Display

Posted in reply to error_prone

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

;

Regular Contributor
Posts: 202

Re: PROC REPORT Compute/Display

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.

Ask a Question
Discussion stats
  • 3 replies
  • 109 views
  • 0 likes
  • 2 in conversation