Hello everyone, I would appreciate your input. I need to add a variable from one data set to another one. They are both sorted by the key variable. I used a proc sql syntax posted here in another thread, but keep receiving error messages.   DDini- main data set DD2- the second data set, from which I need only one variable, named ib14_new. Here is my syntax:   proc sql; create table DDm as select work.DDini.*, work.DD2.ib14_new from work.DDini left join work.DD2 on work.DDini.crn= work.DD2.crn; quit;   The error message is attached. Any help resolving this is very appreciated. ... View more

I am using proc genmod with tweedie distribution and log link to analyze positively skewed outcome. Trying to figure out the actual regression equation to include it in the paper. I am struggling with how to reflect the link function in the equation.   Here is the SAS syntax:  proc genmod data=sasuser...; class sex CAS; model int= sex age_cent age_sq sex*age_cent CAS rstr_cent rstr_sq sex*rstr_cent/dist=tweedie link=log; run;   Here sex is coded 0 and 1, CAS has 4 categories (1,2,3,4), and the last category is used as a reference. The model includes the quadratic effects of age and Rstr. Wondering if the following equation is correct:       Or should it be without Ln's in the formula?        ... View more

This should be fairly simple. Trying to create a new variable for two groups separately. For group a: if diagn =0 or 1, then comorb=0;  if diagn >=2 then comorb=1;   For group b: if diagn =0 then comorb=0;  if diagn >=1 then comorb=1;   The syntax for group2 works fine.   Here is my syntax for group1: data x; set x; if group='a' then do; if diagn =0 or diagn=1 then comorb=0; else if diagn >=2 then comorb=1; end;   This syntax does not calculate the comorb variable at all.   Any ideas on what might be wrong and how to correct it?  Thank you!        ... View more