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!
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.
In proc sql, use the count(*) function and a suitable where condition.
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.
this worked thanks so much!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.