topic Changing a calculated column (measure )as category with % symbol in SAS Visual Analytics

Changing a calculated column (measure )as category with % symbol

Akhila1 — Fri, 31 May 2024 17:50:30 GMT

In creating a SAS viya dashboard I want the following calculated column as a category with % symbol

'Graduated in 2 Years'n / 'Enrolled (Distinct Count)'n

Re: Changing a calculated column (measure )as category with % symbol

Sam_SAS — Fri, 31 May 2024 18:00:14 GMT

Hello,

You can apply a Percent format to the numeric value, if you just want to display the % symbol. (Change the data item properties in the Data pane.)

If you really need the value to be a category value, you can use the Format() operator.

For example,

Format('Engine Size (L)'n / 'Horsepower'n, 'PERCENT6.0')

returns a category value.

Let us know if that helps,

Sam

Re: Changing a calculated column (measure )as category with % symbol

Akhila1 — Fri, 31 May 2024 18:08:39 GMT

I really need the value to be a category value. Format( 'Graduated in 2 Years'n / 'Enrolled (Distinct Count)'n,'PERCENT6.0')I get an error. Type mismatch. expected type at this location is Aggregated measure, type of this item being applied is character. Operand can only be aggregated, but this operator does not support aggregation. Thank you,

Re: Changing a calculated column (measure )as category with % symbol

Sam_SAS — Fri, 31 May 2024 18:16:51 GMT

Oh, I see. The problem is the nested operations when you have an aggregated measure (Distinct Count) in the expression. I think the best workaround is to pre-calculate the distinct count as part of your data preparation.

If you have the very latest version of VA (2024.05), you can work around this by calculating the distinct count as part of an expression-based parameter.