topic Re: Proc means to find the average based on a character column in Developers

Proc means to find the average based on a character column

DavidPhillips2 — Fri, 07 Aug 2015 20:06:10 GMT

Is there a way to use proc means to find the average based on a character column? Lets say I have a column that has two values male and female. I want to know the percent of men and the percent of women. Then do the same over a period of years.

Re: Proc means to find the average based on a character column

Reeza — Fri, 07 Aug 2015 20:08:02 GMT

Use Proc Freq instead.

Re: Proc means to find the average based on a character column

DavidPhillips2 — Fri, 07 Aug 2015 21:13:05 GMT

Thanks that is exactly what I want.

Re: Proc means to find the average based on a character column

DavidPhillips2 — Mon, 10 Aug 2015 13:38:20 GMT

Is there a way to use proc freq to compute percentages on two columns? I’m trying to calculate the percent of whole based on gender and the percent of whole based on year. Note the second percent of whole would not be a sub percent of the first category. I could run two separate freq statements and merge then together, but I’m worried about processing speed. My desired output would look like.

ACADEMIC_PERIOD_DESC	GENDER	COUNT	PERCENT	Whole	Percent of whole
Fall 2010	Female	2099	0.58746	2.93108	0.200424
Fall 2011	Female	2167	0.57541	2.93108	0.196313
Fall 2012	Female	2075	0.58254	2.93108	0.198746
Fall 2013	Female	2091	0.58984	2.93108	0.201236
Fall 2014	Female	2117	0.59583	2.93108	0.20328
Fall 2010	Male	1455	0.40722	2.06134	0.197551
Fall 2011	Male	1598	0.42432	2.06134	0.205847
Fall 2012	Male	1486	0.41718	2.06134	0.202383
Fall 2013	Male	1449	0.40874	2.06134	0.198288
Fall 2014	Male	1435	0.40388	2.06134	0.195931
Fall 2010	Not Reported	19	0.00532	0.00756	0.703704
Fall 2011	Not Reported	1	0.00027	0.00756	0.035714
Fall 2012	Not Reported	1	0.00028	0.00756	0.037037
Fall 2013	Not Reported	5	0.00141	0.00756	0.186508
Fall 2014	Not Reported	1	0.00028	0.00756	0.037037

Re: Proc means to find the average based on a character column

DavidPhillips2 — Mon, 10 Aug 2015 14:10:34 GMT

I was hoping this table in

Request	Equivalent to
tables A*(B C);	tables AB AC;
tables (A B)*(C D);	tables AC BC AD BD;
tables (A B C)*D;	tables AD BD C*D;
tables A – – C;	tables A B C;
tables (A – – C)*D;	tables AD BD C*D;

Base SAS(R) 9.2 Procedures Guide: Statistical Procedures, Third Edition

would help but I can't seem to figure out how to use the table statement to produce the desired result.