topic Re: How to output population standard deviation on SAS in SAS Programming

How to output population standard deviation on SAS

lydiawawa — Wed, 04 Aug 2021 13:20:33 GMT

Hi,

I'm trying to output population standard deviation , not just standard deviation. On SQL, it is simple as using the std_pop. Is there anyway on SAS that I can turn the keys on proc univariate and proc means?

Re: How to output population standard deviation on SAS

PaigeMiller — Wed, 04 Aug 2021 13:23:19 GMT

I think you you have to run PROC MEANS and create an output data set, then in a DATA step you take the outputs from PROC MEANS and then multiply by the proper factor to convert it to the population standard deviation.

Re: How to output population standard deviation on SAS

lydiawawa — Wed, 04 Aug 2021 13:57:44 GMT

How do you convert the sum function with multiple layers of groups?

Re: How to output population standard deviation on SAS

PaigeMiller — Wed, 04 Aug 2021 14:01:24 GMT

@lydiawawa wrote:
How do you convert the sum function with multiple layers of groups?

Is this related to your first question? Can you provide more explanation of what you are asking?

Re: How to output population standard deviation on SAS

lydiawawa — Wed, 04 Aug 2021 14:13:03 GMT

If I want to compute pop standard deviation of supposedly college admission rate among counties by state. How should I convert mean to population standard deviation ?

State County College Admission Rate

MA 01 0.7

MA 03 0.5

VA 02 0.3

VA 05 0.4

VA 07 0.6

Mean:

State College Admission Rate

MA 0.6

VA 0.43

How do I convert the sum function and derive the pop std manually?

Re: How to output population standard deviation on SAS

PaigeMiller — Wed, 04 Aug 2021 14:18:00 GMT

I'm afraid I don't understand. You keep jumping from standard deviation to mean and back. Please explain in more detail.

Re: How to output population standard deviation on SAS

lydiawawa — Wed, 04 Aug 2021 14:22:14 GMT

You told me that to get to pop standard deviation is by calculating the mean first, then manually compute the pop std? If you check the formula for pop standard deviation there is a sum function you need to use after you get the mean. How do I get to pop standard deviation after I get the mean? I do not know how to convert the sum function into SAS program, and I have provided the data structure in my previous response.

Re: How to output population standard deviation on SAS

PaigeMiller — Wed, 04 Aug 2021 14:28:26 GMT

When I spoke about using PROC MEANS, it was to get a sample standard deviation. Then you can multiply the sample standard deviation by the proper factor to get the population standard deviation. You don't need to do anything manually here (other than write the proper code) and you don't specifically need to compute the mean and then use it, because PROC MEANS does that internally.

Re: How to output population standard deviation on SAS

FreelanceReinh — Wed, 04 Aug 2021 14:37:01 GMT

Hi @lydiawawa,

You can also use the VARDEF=N option of PROC MEANS (same in PROC UNIVARIATE) to switch from sample to population standard deviation.

Re: How to output population standard deviation on SAS

PaigeMiller — Wed, 04 Aug 2021 14:53:21 GMT

@FreelanceReinh wrote:

You can also use the VARDEF=N option of PROC MEANS (same in PROC UNIVARIATE) to switch from sample to population standard deviation.

I forgot about that. Definitely a better solution than what I was suggesting.