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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.