Hi everyone,    I am trying to use proc stdrate to calculate age-standardized rates. I am however getting the following error message:  "WARNING: The stratum in the REFDATA= data set, Age_Group_5=10- gender=F, does not have a matched stratum in the DATA= data set."   Does the order of variables or sorting in the relevant data files matter? Perhaps counts for specific stratum is missing and it should be zero? If so, how do I go about addressing this issue?   Can someone please help?! I would really appreciate it!    Below is my code:  PROC STDRATE data=data_set refdata=stdpop  method=direct  stat=rate (mult=1000)  CL=gamma ; *BY X;  POPULATION event=counts=pop_denominator; REFERENCE total=weight;  STRATA Age_Group_5 gender;  RUN; ... View more

Hi everyone,    I want to convert a date variable with the following formatting 01JAN2008 (the format is Date9.)  to a date variable of year only (i.e. 2008).    Could you please provide some guidance on the syntax to do that?    Thanks in advance!  ... View more

Hi everyone,    Proc logistic has a "unit" statement option, to attain an estimate on the association of interest by certain increments.   Can the same be done using proc arima? For example:    proc arima data=data; identify var=&ylist crosscorr=(&xlist); estimate input=(&xlist) p=1 method=ml plot; run; forecast printall; run; quit;   Note: &xlist = continuous exposure/independent variable.  ... View more

  In Proc Logistic we can add 'Units" statement to change the unit of the explanatory variable. Is there any equivalent statement in Proc Genmod procedure?   Instead of one unit change in the covariate "X1" I need 5 units change in "X1". X1 and X1 are continuous.   Example:   proc genmod data=example  DESCENDING;       model epid = x1 x2 female race;       estimate "X1" X1 1 / exp; run;   Thanks! ... View more

Hey everyone,    I am calculating the age standardized rate for a particualr outcome with the folloiwng coe:    proc stdrate data=file refdata=file_standpop method=direct stat=rate(mult=100000) CL=gamma  ; population event=events total=population; reference total=weight; strata age_groups; run;   Upon runing the code, I get an overall age standardized rate for that specific year. How can I attain the rate for each age group and not just the overall rate?   Also, would it be possible to attain the standardized rate for each age group categorized by another dimension such as gender or income? How to go about coding that?    Thansk in advance! ... View more

Hi there,   I get the above error message (Error: Expression using equals (=) has components that are of different data types) upon running the following code:    %MACRO eventsum(period=); proc sql; create table disease_standard as select year, age_group, sex, disease from dataset_name where disease=1 and year=.  quit; run;   %MEND eventsum; %eventsum(period=2013) %eventsum(period=2014) %eventsum(period=2015) %eventsum(period=2016) %eventsum(period=2017)   I'm not sure what the error message means, and how to go about fixing it. Any help?   Thanks ... View more

Hi there,    With two files, one containing survey data, and another with standard population data (age groups, population and weight for each group), I am trying to calculate the age standardized rate for a specific disease (e.g. depression) for each individual year and for all years together - overall that is (i.e. 2011-2017).    Could you please help me with the the codes to accomplish this. Thanks in advance!! ... View more

Hey everyone,    I have a character variable on a SAS profile that has the year, month and day in the following format (example): 20120921.   I am trying to drop the month and day, in order to go from 20120921 to 2012. Could you please help me figure out the code I'd need to do that on SAS?    Thanks in advance! ... View more