Hi. I want to produce the duration adjusted prevalence of Diabetes complications by gender. I used this link: https://www.cdc.gov/nchs/tutorials/NHANES/NHANESAnalyses/AgeStandardization/Task1b_SAS92.htm My questions are: can I use the proportion of each group from the study cohort (my_data) instead of "Standard Proportions for 20-year Age Groups Based on the 2000 U.S. Census Standard Population"? The same for duration, see below code. And do I have to adjust for the interaction term as in the link (sex*duration 0.1305 0.1962 0.2347 0.4386 0 0 0 0)? Please note: sex is coded as 1 or 2; duration is coded as 1, 2, 3 or 4. Thank you. proc surveyreg data=final nomcar; strata sdmvstra; cluster sdmvpsu; weight wtmec20yr; class dmdurcat riagendr; domain agegroup*diadmadult; model dncat= riagendr dmdurcat riagendr*dmdurcat/noint clparm solution vadjust=none; estimate "male " riagendr 1 0 dmdurcat 0.1305 0.1962 0.2347 0.4386 riagendr*dmdurcat 0.1305 0.1962 0.2347 0.4386 0 0 0 0 ; estimate "female " riagendr 0 1 dmdurcat 0.1305 0.1962 0.2347 0.4386 riagendr*dmdurcat 0 0 0 0 0.1305 0.1962 0.2347 0.4386; ods output estimates=sexdn; run;    ... View more

  all, I need your help! I'm a beginner in sas and want to do age-adjustment in my sample data. The population is devided into different agegroups according to age like 18-44, 45-64 and 65+.  But I still want to standardize the prevanlence so as to compare different prevanlence in different survey cycles. My codes are as follows:   PROC SURVEYREG data=diffcomcat nomcar; STRATA sdmvstra;CLUSTER sdmvpsu;CLASS weightcat agegroup;WEIGHT wtmec12yr;DOMAIN sub; MODEL microcat=agegroup agegroup agegroup*agegroup/noint solution vadjust=none; ESTIMATE '18-44' agegroup 1 0 0 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0.5305 0.2992 0.1703 0 0 0 0 0 0 /cl; ESTIMATE "45-64" agegroup 0 1 0 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0 0 0 0.5305 0.2992 0.1703 0 0 0 /cl; ESTIMATE '65+' agegroup 0 0 1 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0 0 0 0 0 0 0.5305 0.2992 0.1703/cl; ods OUTPUT estimates=microageadj_prev_age; *ods select ParameterEstimates Estimates; TITLE 'Age-standardized prevalence of persons 18 years and older with microcat-age'; run;   and the logs are as follows: 527 PROC SURVEYREG data=diffcomcat nomcar; 528 STRATA sdmvstra;CLUSTER sdmvpsu;CLASS weightcat agegroup;WEIGHT wtmec12yr;DOMAIN sub; 529 MODEL microcat=agegroup agegroup agegroup*agegroup/noint solution vadjust=none; 530 ESTIMATE '18-44' agegroup 1 0 0 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0.5305 0.2992 0.1703 0 0 0 0 0 0 /cl; 531 ESTIMATE "45-64" agegroup 0 1 0 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0 0 0 0.5305 0.2992 0.1703 0 0 0 /cl; 532 ESTIMATE '65+' agegroup 0 0 1 agegroup 0.5305 0.2992 0.1703 agegroup*agegroup 0 0 0 0 0 0 0.5305 0.2992 0.1703/cl; 533 ods OUTPUT estimates=microageadj_prev_age; 534 *ods select ParameterEstimates Estimates; 535 TITLE 'Age-standardized prevalence of persons 18 years and older with microcat-age'; 536 run; WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored. NOTE: The structure of the Estimates table has changed from an earlier release of SAS. WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored. WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored. WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored. WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored. WARNING: More coefficients than levels specified for effect agegroup. Some coefficients will be ignored.    I know the third line in my code looks stupid and wired but I really don't know how to write this code。 In the output, the estimated values do not appear in the second and third groups. So who can help me ????????   Best wishes!!!!!!!!!!!   ... View more