topic Re: Array and do over in SAS Programming

Array and do over

ChuksManuel — Tue, 06 Jul 2021 00:26:07 GMT

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

Re: Array and do over

blueskyxyz — Tue, 06 Jul 2021 02:46:20 GMT

https://www.cdc.gov/csels/dsepd/ss1978/lesson3/section2.html

Re: Array and do over

blueskyxyz — Tue, 06 Jul 2021 02:50:03 GMT

Data me; 
    input Smoking	Person_years	Ndeath	Ncancerdeath	Nlungdeath;
    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;
cards;
0      4200      900      150      39                                                                                                   
1      5210      1100      200      12 
;
run;

Re: Array and do over

blueskyxyz — Tue, 06 Jul 2021 02:56:13 GMT

sorry, please add semicolon in this row: rdeath=ndeath/person_years;

Data me;
input Smoking Person_years Ndeath Ncancerdeath Nlungdeath;
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;
cards;
0 4200 900 150 39
1 5210 1100 200 12
;
run;