Hi guys,   I'm trying to use an array to string out variables in my dataset and create a manuscript table.  Can any help me review this code? I want the stringed variable to appear in the order as in the array. The code was not running well.   proc format; value danfm 1= 'age' 2= 'gender' 3= 'obesity' 4= 'hlth' 5= 'smoke1' 6= 'smoke2' 7= 'smoke3' ; data me; set you; array her age gender obesity hlth smoke1 smoke2 smoke3; do over her; tc=_I_; tn= put (tc,danfm.); value=her; output; end; data me1; set me; if value ne .; run;     ... View more

Hello guys, I working on coding for cancer mortality and lung cancer deaths. My code is shown below. In the code, I want rdeath to represent the death rate per 10,000 person-years (PY). and rcancerdeath and rlungdeath to  represent the cancer and lung cancer death rate per 10,000PY respectively. I've struggled to use an array and a do over for this. Can anyone help me check the code?   Data me; set sc_cancer_surveillance; Array ab ndeath ncancerdeath nlungdeath ; Array cd rdeath rcancerdeath rlungdeath; do over cd; rdeath=ndeath/person_years; rcancerdeath=ncancerdeath/person_years; rlungdeath= nlungdeath/person_years; end; run; Please see the initial table that I got and I want to calculate the rates in person-years,     Obs Smoking Person_years Ndeath Ncancerdeath Nlungdeath 1 0 4200 900 150 39 2 1 5210 1100 200 12 ... View more

Hello guys, I am working on a dataset in which there are duplicate observations to a death record. I used First. statement to find these duplicates. My question now is: If I wanted to select only the first record for each participant, how do I go about implementing this? I know I can use the First. And/or Last. statement in SAS but i can't seem to figure this out. My codes are attached below. proc sort data= ler2; by id; run; data ler3; set ler2; by id; if id ne .; if first.id then output; run;       ... View more

Can anyone help me figure out how i can write a contrast statement for a 3 variable model....each model having only 2 levels (coded 0,1) in SAS. I can't find anywhere that explains this concept well. I am trying to work off this example, but it used a 2 variable model and each variable with 3 levels. Please i need help. proc logistic data = logit_sim desc; class x1 (ref = '1') x2 (ref = '1') / param=ref; model y = x1 x2; contrast 'x1 = 1 x2 1 v 2' x2 1 /e estimate = parm; contrast 'x1 = 1 x2 1 v 3' x2 0 1 /e estimate = parm; contrast 'x1 = 1 x2 2 v 3' x2 1 -1 /e estimate = parm; run; ... View more

if q10_7= '1' then q10_7a=0; if q10_7= '2' then q10_7a=1; if q10_7= '3' then q10_7a=2; if q10_7= '4' then q10_7a=3; if q10_7= '5' then q10_7a=4; if q10_8= '1' then q10_8a=0; if q10_8= '2' then q10_8a=1; if q10_8= '3' then q10_8a=2; if q10_8= '4' then q10_8a=3; if q10_8= '5' then q10_8a=4; if q10_9= '1' then q10_9a=0; if q10_9= '2' then q10_9a=1; if q10_9= '3' then q10_9a=2; if q10_9= '4' then q10_9a=3; if q10_9= '5' then q10_9a=4; if q10_4= '1' then q10_4a=0; if q10_4= '2' then q10_4a=1; if q10_4= '3' then q10_4a=2; if q10_4= '4' then q10_4a=3; if q10_4= '5' then q10_4a=4; if q10_5= '1' then q10_5a=0; if q10_5= '2' then q10_5a=1; if q10_5= '3' then q10_5a=2; if q10_5= '4' then q10_5a=3; if q10_5= '5' then q10_5a=4; if q10_6= '1' then q10_6a=0; if q10_6= '2' then q10_6a=1; if q10_6= '3' then q10_6a=2; if q10_6= '4' then q10_6a=3; if q10_6= '5' then q10_6a=4; Dear programmers, is there a way i can make these code easier? I am just trying to switch numbers to another...eg. "1" in original dataset to "0", "2" to "1" etc. I know i can do an "if..then" statement but that seems long. Can anyone give me an idea how i can do this?   Thanks ... View more

Hello programmers, I am trying to test for proportional odds assumption using sas proc surveylogistic. It seems I am able to do this using proc logistic. But I want to account for the complex sampling in my data, so surveylogistic is a given. Is there a way proc survey logistic implements this? I am doing an ordinal logistic regression.  proc logistic data=asth ; class MDD (Ref= '0') mold (Ref= '0') age_new (Ref= '1') smoker(Ref= '0') gender (ref='0') BMI (ref='0') / param=ref; model activity (descending) = MDD mold age_new smoker gender BMI ; run; proc surveylogistic data=asth; strata strt ; cluster psu ; weight wgt; class MDD (Ref= '0') mold (Ref= '0') age_new (Ref= '1') smoker(Ref= '0') gender (ref='0') BMI (ref='0') / param=ref; model activity (descending) = MDD mold age_new smoker gender BMI ; run;   ... View more

Hello programmers, I wanted to run an analysis taking into account complex sampling. Can anyone help me check my codes? They did not run. New to macros. It didn't give me any errors in the log. %Macro Printit; %surveygenmod(data=adult_asthma3, y=urg_tim,x=MDD mold age smoker income smoke_inside educate, dist=binomial, link=logit, weight=LLcpwt_F, strata=_ststr, cluster=_psu, fpc=, scale=deviance, intercept=y, vadjust=n); run; %MEND printit; ... View more