Hello,
I've patients healthcare annual cost and I would like to calculate the mean, but, the data is highly skewed to the right making the mean ~22 times the median. Below is the summary statistic for the data.
Mean = $10,312, Median = $1497, SD = 23,970, Max = $242,502, Min = $0
I would really appreciate if someone can guide me to resource, preferably SAS code example.
Thanks in advance!
What properties do you want your measure of cost to have?
Other measures have other properties. It all depends on what you need.
@Sujithpeta wrote:
Hello,
I've patients healthcare annual cost and I would like to calculate the mean, but, the data is highly skewed to the right making the mean ~22 times the median. Below is the summary statistic for the data.
Mean = $10,312, Median = $1497, SD = 23,970, Max = $242,502, Min = $0
I would really appreciate if someone can guide me to resource, preferably SAS code example.
Thanks in advance!
Code for what?
In my experience when the data is that variable, we usually report three statistics, the Median, 50% above/below which is easy to explain and then the 90% and 99th percentiles. These tell you how much 90% of people are paying and 99% to understand the distribution some more. If you're in Canada check CIHI cost reports, not sure what US has. You can probably look at the CIHI reports to know what to measure.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.