topic Re: Need assistance in New SAS User

Need assistance

lisa2002 — Tue, 14 May 2019 19:57:21 GMT

Hello everyone,

I have a large dataset that I'm working on and I'm trying to figure out how to exclude all ages and only count the ages of men that are 75 years old. Still learning, if someone could assist that would be great.

/*how many men are 75 years old*/

Age BMI

74 30.6

74 25.9

74 31.2

75 28.1

75 32.9

75 32

75 23.7

75 25

80 22.4

80 28.4

80 27.2

This is my code...clearly I don't want to sum up the ages so this is not working. I need a count of all the men that are 75yrs. and not sure how to receive only those numbers.

proc sql;
create table Men75yrs as
select *, sum(Age) as yrs75total
from sashelp.bmimen
Quit;

Re: Need assistance

novinosrin — Tue, 14 May 2019 20:01:47 GMT

data have;
input Age BMI;
cards;
74     30.6
74     25.9
74     31.2
75     28.1
75     32.9
75     32
75     23.7
75     25
80     22.4
80    28.4
80     27.2
;

proc sql;
create table want as
select age, count(age) as count
from have
where age=75
group by age;
quit;

Re: Need assistance

PaigeMiller — Tue, 14 May 2019 20:04:30 GMT

proc freq data=have;
    table age;
run;

proc freq data=have(where=(age=75));
    table age;
run;

PROC FREQ is a fundamental tool that all SAS users should be familiar with.

Re: Need assistance

lisa2002 — Tue, 14 May 2019 20:53:38 GMT

Thank you so much!