Percentage Rates.

[killiangavin]

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.  

[FredrikE]

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

[killiangavin]

Hi That really looks like it will work,





Thank you some much !!