First analysis: I have a 2x4 table and am trying to analyze for EMM (effect measure modification). My exposure is dichotomous and my outcome is categorical(ordinal). Second analysis: I have a 2x2 table and am trying to analyze for EMM (effect measure modification). My exposure is dichotomous and my outcome is dichotomous.   What test will be appropriate to assess EMM of these analyses? Any help with the material where I can find the SAS code? ... View more

Hello, Am not sure why I am encountering this problem in my proc reg. Any help?   ... View more

Hi Can someone pls explain what this questions mean. I can't create a dummy variable because I don't understand the question. Any simple sas code to help understand the questions will be appreciated.  1. /*Generate a report on the proportion of: patients on any drug, patients with any physician visit, and patients on any drug or with any physician visit*/ 2. /*Report the distribution of: number of physician visits per patient, number of patients per drugcode, number of patients per diagnostic grouping, and number of prescriptions per drugcode*/ ... View more

Hello,  I know this might seems very simple to some. 1. How do I generate a report on proportion of patients with any physician visit.  2. How do I report the distribution of the number of physician visits per patient. There are multiple records per patient Here is my dummy data data want; set have; input patientid phyvisit$; datalines; 10  xyz 10  abc 10  ijk 11 abc 11 edc 12 abc 12 adc 12 zxc ; run; Thanks   ... View more

Hello, I have dummy variable Var1 and Var2. How will I remove the 2 in R862 so as to have R86 and R86 in both Var1 and Var2. I will like to do this for all the unmatched e.g. C23 and C2357, E89 and E8996 etc. I have over 10,000 encounters my dataset with this issue. Fname  Lname  Firstname  Lastname  Var1   Var2 John     Doe      John           Do             J124   J124 Pat       Cut        Patt            Cot jr         C23    C2357 Riley     Jo Sr     Rilly           Joo            R862  R86 Ellen     Mee      Elen           Meey Sr.    E89    E8996 ... View more

Hi, I have this data and some names did not align with each other. Just like table 1 and I would like to have the names align just like in table 2. Any help please? Table 1: FName LName Sex Age Income City FNameA LNameA SexA AgeA IncomeA BOD John Doe M 20 100 KK John Doe   100 100 121298 Adam Apple F 21 300 BC Peter Cat F   302 031288 John Cloth M 22 400 CU Know Know M 400 412 030695 Eric Dog F 23 500 PO Bill Table     500 092287 Lin Cat M 45 300 YI Lin Cat M 300 300 013076 Know Know F 46 201 HM John Cloth F   201 070777 Bill Table F 50 330 VB Adam Apple   330 330 090999 Peter Cat F   302 OO Eric Dog F 23 500 120388   Table 2: FName LName Sex Age Income City FNameA LNameA SexA AgeA IncomeA BOD John Doe M 20 100 KK John Doe   100 100 121298 Adam Apple F 21 300 BC Adam Apple   330 330 090999 John Cloth M 22 400 CU John Cloth F   201 070777 Eric Dog F 23 500 PO Eric Dog F 23 500 PO Bill Table F 50 330 VB Bill Table     500 092287 Lin Cat M 45 300 YI Lin Cat M 300 300 013076 Know Know F 46 201 HM Know Know M 400 412 030695 Peter Cat F   302 OO Peter Cat F   302 031288   ... View more

I found this macro  online and I may be useful for my analysis but when I tried to run it as it is, its not working. Anyone knows why? Here is the link: https://dlin.web.unc.edu/software/hazardratio/ %macro HazardRatio (Data = Data, Time = Time, Status = Status, Stratum =, Treatment = Treatment, Alpha = 0.05, Accuracy = 0.001, Result = HR_CI); …… %mend HazardRatio; data test; input Treatment Stratum Time Status; datalines; 1 2 1521 1 1 1 1537 0 0 2 963 1 1 2 293 1 0 2 659 1 1 2 1767 1 0 1 1865 0 1 1 1792 0 1 1 1841 1 0 1 1845 1 0 1 1888 1 0 1 1701 1 1 1 887 1 0 1 1918 1 1 1 1822 1 1 1 1638 1 0 1 1772 1 0 2 384 1 0 2 218 1 1 1 1775 1 1 1 1526 1 0 1 1745 1 0 1 1788 1 1 1 1387 1 ; run; %score_bound(Data = test, Time = Time, Event = Event, Stratum = Stratum, Treatment = Treatment, Alpha = 0.05, Accuracy = 0.000001);   >>>>>>>>>>>>This is the log>>>>>>>>>>>> 294 %macro HazardRatio (Data = data, Time = Time, Status = Status, Stratum =, Treatment = Treatment, 294! Alpha = 0.05, Accuracy = 0.000001, Result = HR_CI); 295 296 %mend HazardRatio; 297 data test; 298 input Treatment Stratum Time Status; 299 datalines; NOTE: The data set WORK.TEST has 24 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.28 seconds cpu time 0.12 seconds WARNING: Apparent invocation of macro SCORE_BOUND not resolved. 324 ; 325 run; 326 %score_bound(Data = test, Time = Time, Event = Event, Stratum = Stratum, - 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 327 Treatment = Treatment, Alpha = 0.05, Accuracy = 0.000001);   ... View more

Hi,  I have two strata output from proc lifetest. How can I calculate a single confidence interval from both results  from the Survival Standard Error in the two tables below?     ... View more