Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Percentile

Reply
Frequent Contributor
Posts: 75

Percentile

Can anyone point me towards a guide on how to use the precentile function?

 

I would like to calculate percentiles for use in maps and tables

 

My data looks like

 

ID - group - value

1 - A - 1

2 - A - 0

3 - A - 1

4 - B - 1

5 - B - 1

6 - B - 1

 

Value is always 1 or 0.

 

I want VA to total the value column by group and then calculate the percentiles based on those totals. I have tried several combinations of the formula but always get a value of 1 which leads me to believe VA is calculating the percentile based on the underlying data and not aggregating to group level first.

 

 

Post a Question
Discussion Stats
  • 0 replies
  • 156 views
  • 0 likes
  • 1 in conversation