cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
maragdalis
‎11-27-2023
  • 2 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

prevalence rate and 95%CI for BMI across age groups and gender

by Calcite | Level 5 in SAS Programming
‎11-13-2023 09:43 PM
‎11-13-2023 09:43 PM
Hi Apologies this is my first post to this group.   I wish to calculate the prevalence rate and 95% confidence intervals for people by BMI category and age group by sex to produce the table below. Could you advise? Thanks for your help! ********************************************************************************************************************************************* | Sex |   age group                       |  underweight | healthy            | overweight      | obese               |  Total  ********************************************************************************************************************************************* | M    | 20-<30years                   | Prev (95%CI) | Prev (95%CI)  |Prev (95%CI)  |Prev (95%CI)  |Prev (95%CI)  |   etc ********************************************************************************************************************************************* PROC FORMAT; VALUE agefmt 20-<30 = '20-<30 years' 30-<40 = '30-<40 years' 40-<50 = '40-<50 years' ; value bmifmt 9-<18.5 = 'Underweight (9-<18.5)' 18.5-<25 = 'Healthy (18.5-<25)' 25-<30 = 'Overweight (25-<30)' 30-51 = 'Obese (30+)'; VALUE sexfmt 0 = 'Female' 1 = 'Male' ; RUN; DATA have; INPUT age bmi sex @@; DATALINES; 20 18.5 1 25 23.5 1 26 24.5 1 20 15.5 1 20 16.2 1 21 18.0 1 20 30.2 1 21 26.5 1 22 29.0 1 22 29.5 1 20 22.5 0 21 23.5 0 20 24.5 0 23 25.5 0 23 25.2 0 25 19.0 0 26 38.2 0 23 36.5 0 24 29.0 0 25 16.5 0 30 22.5 0 31 23.5 0 30 24.5 0 33 25.5 0 33 25.2 0 35 19.0 0 36 38.2 0 33 36.5 0 34 29.0 0 35 16.5 0 30 18.5 1 35 20.5 1 36 24.5 1 30 15.5 1 30 16.2 1 31 18.0 1 30 30.2 1 31 26.1 1 32 29.1 1 32 29.5 1 40 22.5 0 40 23.5 0 40 24.5 0 42 25.5 0 42 20.2 0 45 39.0 0 46 38.2 0 43 36.5 0 44 29.0 0 45 30.5 0 40 12.5 1 41 28.5 1 40 24.5 1 43 25.5 1 43 25.2 1 45 19.0 1 46 38.2 1 43 36.5 1 44 29.0 1 45 16.5 1 ; DATA want; SET have; FORMAT age agefmt.; FORMAT bmi bmifmt. ; FORMAT sex sexfmt.; RUN; ... View more

calculate 95%confidence intervals for bmi by sex, age group and bmi gr...

by Calcite | Level 5 in New SAS User
‎11-13-2023 12:07 AM
‎11-13-2023 12:07 AM
Hi I want to produce a table that has the frequency of males and females by age group and bmi group and the 95%conf interval for bmi within each group.   ie  -------------------------------------------------------------- Sex         | underweight | normal | overweight | obese     | -------------------------------------------------------------- |M Freq |    5                  |   10          |      8              |    5            | -------------------------------------------------------------- | 95%CI|   15.1-18.0       | 19.1-20.5|   26.2-29.1   | 36.9-41.1 | etc   many thanks in advanced   PROC FORMAT; VALUE agefmt 20-<30 = '20-<30 years' 30-<40 = '30-<40 years' 40-<50 = '40-<50 years' ; value bmifmt 9-<18.5 = 'Underweight (9-<18.5)' 18.5-<25 = 'Healthy (18.5-<25)' 25-<30 = 'Overweight (25-<30)' 30-51 = 'Obese (30+)'; VALUE sexfmt 0 = 'Female' 1 = 'Male' ; RUN; DATA have; INPUT age bmi sex @@; DATALINES; 20 18.5 1 25 23.5 1 26 24.5 1 20 15.5 1 20 16.2 1 21 18.0 1 20 30.2 1 21 26.5 1 22 29.0 1 22 29.5 1 20 22.5 0 21 23.5 0 20 24.5 0 23 25.5 0 23 25.2 0 25 19.0 0 26 38.2 0 23 36.5 0 24 29.0 0 25 16.5 0 30 22.5 0 31 23.5 0 30 24.5 0 33 25.5 0 33 25.2 0 35 19.0 0 36 38.2 0 33 36.5 0 34 29.0 0 35 16.5 0 30 18.5 1 35 20.5 1 36 24.5 1 30 15.5 1 30 16.2 1 31 18.0 1 30 30.2 1 31 26.1 1 32 29.1 1 32 29.5 1 40 22.5 0 40 23.5 0 40 24.5 0 42 25.5 0 42 20.2 0 45 39.0 0 46 38.2 0 43 36.5 0 44 29.0 0 45 30.5 0 40 12.5 1 41 28.5 1 40 24.5 1 43 25.5 1 43 25.2 1 45 19.0 1 46 38.2 1 43 36.5 1 44 29.0 1 45 16.5 1 ; DATA want; SET have; FORMAT age agefmt.; FORMAT bmi bmifmt. ; FORMAT sex sexfmt.; RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-27-2023 09:59 PM
Likes given to
View All
Quick links