topic Percentage Rates. in SAS Visual Analytics

Percentage Rates.

killiangavin — Tue, 18 Jun 2019 12:42:26 GMT

I have a dataset in SAS VA. One of the fields is "Application Sanctioned" with a Yes or No option. I want to find the sanction rate in one of my crosstabs on SAS VA i.e Total Rows with Application Sanction = YES divided by Total Rows.

What is the best way to do this in SAS VA?

Any help would be really appreciated.

Re: Percentage Rates.

FredrikE — Wed, 19 Jun 2019 08:43:56 GMT

Hi!

Could this work for you?

Create a calculated item (lets call it "ApSa":

IF 'Application Sanctioned'n = 'YES' then return 1

ELSE 0

Then create a new aggregated measure:

Sum [_ByGroup_] ('ApSa'n) / Sum [_ForAll_] ('Frequency'n)

Set format to percent and test it in your cross table.

//Fredrik

Re: Percentage Rates.

killiangavin — Wed, 19 Jun 2019 08:46:17 GMT

Hi That really looks like it will work,

Thank you some much !!