topic Re: Assistance with proportion calculation with SAS in New SAS User

Assistance with proportion calculation with SAS

Ossy — Thu, 03 Oct 2024 16:02:10 GMT

I need assistance in calculating the proportion of females in this dataset

ID 1	SEX 1	height_feet 5	heaight_inch 4.5	Weight 138	Systolic 117	Diastolic 82	Glucose 98	Cholesterol 168
2	1	5	2.5	201.6	122	90	102	201
3	2	5	8.5	206.2	128	68	97	197
4	2	5	2.5	121	144	84	90	211
5	1	5	1	229.2	130	86	94	168
6	2	5	5.5	236.2	126	88	92	232

Female is 1, Male is 2.

What proportion of the sample is female?

3. What is mean, median, std minimum, maximum, and range for weight, systolic, diastolic, glucose and cholesterol, answers must be 1 decimal place.

Re: Assistance with proportion calculation with SAS

ballardw — Thu, 03 Oct 2024 16:34:26 GMT

Proc freq one-way frequency tables give count and percentage (and cumulative count and percentages)

Since you didn't provide an actual data set or data step to create such I'll use a data set SAS provides that has a Sex variable to demonstrate. The variable in the data set is character but the behavior would be the same.

proc freq data=sashelp.class;
   tables sex;
run;

with output like

Sex	Frequency	Percent	Cumulative Frequency	Cumulative Percent
F	9	47.37	9	47.37
M	10	52.63	19	100.00

or 47.37 percent of the observations are from Females.

If you actually have two questions the Proc Means with the MAXDEC= (maximum number of decimals ) option would likely be easiest:

proc means data=sashelp.class maxdec=1
   mean median stddev min max range;
run;

By default Proc Means will summarize all numeric variables. If you want specific variables then provide them on a VAR statement with the list of variable names of interest.

Re: Assistance with proportion calculation with SAS

Ossy — Thu, 03 Oct 2024 18:59:44 GMT

Thank you so much for your assistance.