Hello programmers,   I am trying to use the retain or lag function to help me calculate the Incidence density ratios. My IDR= Incidence density for value=1/ incidence density for value=0 and i want to output only the last observations.   Please i'll be glad if anyone can give me an idea on how to go about this? I want to calculate the respective Incidence density for I_DPD, I2_DPY, I_AnginaPD and I2_AnginaPY. data one; input tc tn $ value I_DPD I2_DPY I_AnginaPD I2_AnginaPY; datalines; 1 Exhaustion 0 0.016 6.07 0.002 0.904 1 Exhaustion 1 0.016 5.91 0.003 1.265 2 Problemwalking 0 0.016 6.140 0.002 0.970 2 Problemwalking 1 0.015 5.71 0.004 1.004 3 ProblemStanding 0 0.016 6.17 0.008 0.95 3 ProblemStanding 1 0.014 5.43 0.005 0.98 ; run; proc print; run;   ... View more

Hello guys,   I have two datasets A  and B. A is a baseline dataset and B is the death dataset.    I want to merge using the "In= " to select only Ids that are in dataset A.   Then also in the merge i want to create a flag using "in=" to determine that the patient died.    My code is attached.   Any help will be appreciated. data forty; merge sleep2(in=x) three (in=y); if in=x then died=y; run; proc print; run; ... View more

Hello guys,   I know it's probably an easy code to write but  i want to be corrected on this.   I want to create a variable heartvar6 , such that heartvar6=1 if a participant has 1 or more heart failures (eg any of heartvar1-heartvar5 = 1). I also want to call heartvar6 as missing if the patient has a combination of 0's and missings . And then 0 otherwise. For example, in the dataset i posted, i want observation 3 to be missing but observation 5 will be 0.     data one; input heart1 heart2 heart3 heart4 heart5; datalines; 1 0 0 0 0 0 1 . .0 0 0 0 . 0 1 1 0 1 0 0 0 0 0 0 ; run; data two; set one; if heartvar1 =1 or heartvar2=1 or heartvar3=1 or heartvar4=1 or heartvar5=1 then heartvar6=1; else if heartvar1=0 and heartvar2=0 and heartvar3=0 and heartvar4=0 and heartvar5=0 then heartvar6=0; else heartvar6=.; proc print; run;   please can i use an array for this? This code gave me the logic that i wanted to implement. is there a more efficient way of writing this?   Thanks      ... View more

Hello programmers,   I have  my variables like this: heart1, heart2, heart3, and each of these variables have responses  coded as 1(most of the time), 2 (some of the time), 3 (rarely or never)   I want to create 3 new dichotomous (0,1) variables named heartvar1-heartvar3 which corresponds to heart1-heart3 such  that heartvar1=1 if heart1=1 and heartvar1=0 otherwise, if heart1 is not missing. I want to also do this for heart2 and heart3.     I know i can use an array and a do over statement. Code is shown below data one; set have; array heart1-heart3; array heartvar1-heartvar3; do over ya heart1-heart3; if heart1=1 and heart1 ne . then heartvar1=1; else heartvar1=0; if heart2= 1 and heart2 ne . then heartvar2= 1; else heartvar2=0; if heart3 = 1 and heart3 ne . then heartvar3= 1; else heartvar3=0; end; end; end;  My code did not run well and i was wondering what could be wrong.     Thanks ... View more

Hello programmers,   I wanted to create a dichotomous 0, 1 variable for CVD death.  If the cause of death is between codes  '410' and '41499' then the person has CVD death.   My codes are attached.  data xyz; input id death $ ; datalines; 1 195 19 414 26 431 27 414 29 414 40 414 ; run; data abc; set xyz; if death = '410' then Dix= 1; if death= '411' then Dix=1; If death= '412' then Dix=1; If death= '413' then Dix=1; If death='414' then Dix=1; else Dix=0; RUN; This code worked because i checked the CVD codes to see that there were only codes '410' '411' '412' '413' and '414'. Sometimes there may be '41099' '41080' '41499' etc . Is there a better way i could write this code so that it checks every code without me having to do it in this pattern?   Thanks ... View more

Hello programmers,   I have a dataset in which only the year of death relative to baseline (not the actual days till death ) is provided. For example. If yrofdeath=1, the person died in year 0-1 (within 365  days);                      if yrofdeath=2, the person died in year 1-2 (days 366-730)                       If yrofdeath=3, the person died in year 2-3(731 -1096)   I want to use a rauni function to assign the number of days until death based off the given yrofdeath in the dataset and to round it up using the round function. I have read papers and texts on ranuni but i have no idea how to approach this particular problem. How can i convert 0-1 to 0-365? I know for yrofdeath 2 and 3, i also have to add 365 and 730 respectively. How do i do this? data one; input site id yrofdeath cause; datalines; 3 1 2 195 3 19 3 414 3 26 2 431 3 27 2 414 3 29 1 414 3 40 2 414 3 42 3 188 3 52 1 557 3 55 3 429 3 56 2 153 3 56 2 153 3 59 3 3 67 2 496 3 79 2 414 3 80 3 440 3 81 2 157 3 82 2 199 3 94 1 414 3 95 1 414 3 99 2 436 3 105 1 507 3 119 2 153 3 127 1 414 3 143 3 599 3 145 3 410 3 158 2 162 3 165 1 496 3 172 1 414 3 177 3 481 3 188 3 174 3 199 3 414 3 202 2 414 3 203 1 185 3 203 1 185 3 211 3 518 3 220 2 153 3 223 2 154 3 226 1 414 3 233 2 429 3 243 3 402 3 251 1 145 3 266 3 162 3 269 3 429 3 271 3 410 3 274 3 414 3 281 1 518 3 289 3 575 3 296 2 496 ; run;   ... View more