topic Re: Counting number of observations with certain value in SAS Programming

Counting number of observations with certain value

iressa13 — Mon, 30 Oct 2017 18:09:52 GMT

Hello I am looking to be able to count the number of observations with values < 25 and also those > 25 but < 30. I have read some other solved questions but haven't been able to produce a successful code. Thanks for any help!

Re: Counting number of observations with certain value

Kurt_Bremser — Mon, 30 Oct 2017 18:32:15 GMT

In proc sql, use the count(*) function and a suitable where condition.

Re: Counting number of observations with certain value

Astounding — Mon, 30 Oct 2017 18:42:52 GMT

I would use a format, to account for all categories:

proc format;

value bmi_cat

low - < 25 = 'Under 25'

25 - < 30 = '25 to under 30'

30 - high = '30+';

run;

proc freq data=have;

tables bmi / missing;

format bmi bmi_cat.;

run;

Regardless of the method that you choose, note that missing values are less than 25. Make sure you account for them in a way that makes sense to you.

Re: Counting number of observations with certain value

iressa13 — Mon, 30 Oct 2017 18:48:24 GMT

this worked thanks so much!