Hi all,   I hope you are doing well. I am trying to calculate person years. I am not sure if there is any code we can use in proc phreg to get person year and number of events directly.   I also have another question. I selected participants who did not have health outcome and try to calculate person year by hand. I was wondering if there is any code I can use to get the sum of each product of each column* time: h:persist good person time=2*176+4*340+6*272+.......     Table of time by hear_p4cat time hear_p4cat h:persist good h:poor to good h:good to poor h:persist poor Total 2 176 25 18 19 238 4 340 29 39 68 476 6 272 37 33 51 393 8 319 21 33 36 409 10 229 22 26 30 307 12 247 24 17 31 319 14 1275 63 79 143 1560 Total 2858 221 245 378 3702   Thanks! ... View more

Hi All,   I hope this message finds you well. I am trying to the characteristics of the participants included and exclude. Here are my inclusion criteria. How could I get the dataset that I excluded? Thanks!   data elsa02; set elsa01; if age1<50 or age2<50 then delete; if sight_persist=. then delete; if hear_persist=. then delete; if (cesd1>=0 or cesd2>=0); if missing(cesd1) then cesd1=cesd2; if missing(cesd2) then cesd2=cesd1; if cesd3=. and cesd4=. and cesd5=. and cesd6=. and cesd7=. and cesd8=. and cesd9=. then delete; if n(of cesd3-cesd9)<2 then delete; if (cesd1>=3 or cesd2>=3) then delete; run; ... View more

Hi,   I hope you are doing well. I am trying to combine the dataset and it shows the error:  Variable has been defined as both character and numeric. How can I solve it?       70 data hrslong.hrs; 71 merge 72 randhrs (in=a) 73 h92 (in=b) h93 (in=c) h94 (in=d) h95 (in=e) h96 (in=f) h98 (in=g) 74 h00 (in=h) h02 (in=i) h04 (in=j) h06 (in=k) h08 (in=l) h10 (in=m) h12 (in=n) h14 (in=o) 75 h16 (in=p) h18 (in=q); ERROR: Variable AHHID has been defined as both character and numeric. ERROR: Variable ASUBHH has been defined as both character and numeric. ERROR: Variable BPPN has been defined as both character and numeric. ERROR: Variable APPN has been defined as both character and numeric. ERROR: Variable CPPN has been defined as both character and numeric. ERROR: Variable ESUBHH has been defined as both character and numeric. ERROR: Variable APPN has been defined as both character and numeric. ERROR: Variable BPPN has been defined as both character and numeric. ERROR: Variable CPPN has been defined as both character and numeric. ERROR: Variable APPN has been defined as both character and numeric. ERROR: Variable BPPN has been defined as both character and numeric. ERROR: Variable CPPN has been defined as both character and numeric. 76 if a=1; 77 by hhidpn; 78 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set HRSLONG.HRS may be incomplete. When this step was stopped there were 0 observations and 119681 variables. WARNING: Data set HRSLONG.HRS was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.43 seconds cpu time 0.32 seconds ... View more

Hi SAS Communities, I tried to use the mean to represent the missing value, but it still showed there were missing value.     data elsa02(drop = a _a m); _a = a; do _N_ = 1 by 1 until (last.idauniq | a); set elsa01(rename = drinkd = a); by idauniq ; end; m = mean(_a, a); do _N_ = 1 to _N_; set elsa01(rename = drinkd = a); drinkd = coalesce(a, m); output; end; run;   NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 444 at 935:8 NOTE: There were 45648 observations read from the data set WORK.ELSA01. NOTE: There were 45648 observations read from the data set WORK.ELSA01. NOTE: The data set WORK.ELSA02 has 45648 observations and 50 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 second     ... View more