Still not showing WHERE you want BMI_status to appear. The values don't really look like class variables at this stage unless you have a not documented format that is assigning the value to categories such as under weight, normal, overweight and obese. Do you want BMI_status to appear as each value with a count or what. Since you started with proc freq something like this might get close: proc tabulate data=<your data set here>; class age_group gender landholding BMI_status; /* if any of your records have missing values you may want the option /missing on this line*/ format Health_status H00001_. Age_group1 AD0000_.; /* if you have a grouping format for BMI then add it here*/ table BMI_status, /* assumes the rows are going to be BMI*/ Health_status*age_group* gender *(n colpctn); /* this will have a column heading for each value of health_status and gender with in each*/ /* if you want a separate table for each value of Health_status*/ table health_status, bmi_status, age_group*Gender * (n colpctn); table BMI_status, /* assumes the rows are going to be BMI*/ Health_status*landholding * gender *(n colpctn); /* this will have a column heading for each value of health_status and gender with in each*/ /* if you want a separate table for each value of Health_status*/ table health_status, bmi_status, landholding *Gender * (n colpctn); run; If you want other percentages you'll want to look up percentages in proc tabulate.
... View more
