topic Re: How to obtain mean values for the observations in a dataset in New SAS User

How to obtain mean values for the observations in a dataset

Banke — Mon, 04 Oct 2021 21:09:03 GMT

Hello everyone,

please i have to following dataset. The THCIC_ID variable is the unique ID of each hospital in PROVIDER_NAME variable column. Each observation per hospital is the inidividual patient that was admitted in that hospital. e.g austin state hospital, the first hospital, have 8 admissions. I am asked to provide the mean number of admissions across all hospitals. do i have to create a count ? i dont know how to go about it. There are 361 hospitals and over 9000 observations in the dataset.

Thank you

data set

Re: How to obtain mean values for the observations in a dataset

PaigeMiller — Mon, 04 Oct 2021 21:13:15 GMT

PROC FREQ will determine the actual number of admissions per hospital.

To get the mean number of admissions, you would run PROC MEANS on the output of PROC FREQ.

Re: How to obtain mean values for the observations in a dataset

Kurt_Bremser — Mon, 04 Oct 2021 21:20:18 GMT

You ca run two nested SQL SELECTs.

proc sql;
select mean (count)
from (select hosp_id, count(*) as count from have group by hosp_id);
quit,;

In the future, please supply data in usable form, in a data step with datalines, not as pictures, so we have something to test against.

Re: How to obtain mean values for the observations in a dataset

Banke — Mon, 04 Oct 2021 21:31:35 GMT

Thank you. Can you please show me the syntax?

is it something like

PROC FREQ DATA = WEEK6.THCICS;

TABLES PROVIDER_NAME;

OUTPUT OUT = MEANS MIN MAX;

RUN;

Re: How to obtain mean values for the observations in a dataset

Banke — Mon, 04 Oct 2021 21:33:06 GMT

Thanks, i do not know how to go about it. t hats why i dont have a data step, i dont know about proc sql yet, can you please explain to me:?

Re: How to obtain mean values for the observations in a dataset

PaigeMiller — Mon, 04 Oct 2021 21:33:08 GMT

proc freq data=week6.thcics;
    tables provider_name/out=counts noprint;
run;
proc means data=counts;
    var count;
run;

Re: How to obtain mean values for the observations in a dataset

Banke — Mon, 04 Oct 2021 22:04:08 GMT

It worked, thank you