Hello all, I was wondering what would be the best procedure to use to calculate pooled odds ratio (OR)? I have a raw data for 6 separate studies where a certain drug (and placebo) were tested for a health condition. I can calculate the ORs for the individual studies but I am having a hard time to calculate the pooled OR when I put all the record level information into one file. Below is the descriptive stats for those studies: Study Placebo Patient_died Count Percent STUDY 1 No No 597 21.5601 STUDY 1 No Yes 78 2.8169 STUDY 1 Yes No 1851 66.8472 STUDY 1 Yes Yes 243 8.7757 STUDY 2 No No 1245 48.0139 STUDY 2 No Yes 155 5.9776 STUDY 2 Yes No 1086 41.882 STUDY 2 Yes Yes 107 4.1265 STUDY 3 No No 768 55.3314 STUDY 3 No Yes 92 6.6282 STUDY 3 Yes No 477 34.366 STUDY 3 Yes Yes 51 3.6744 STUDY 4 No No 238 19.2246 STUDY 4 No Yes 46 3.7157 STUDY 4 Yes No 790 63.8126 STUDY 4 Yes Yes 164 13.2472 STUDY 5 No No 590 65.1934 STUDY 5 No Yes 118 13.0387 STUDY 5 Yes No 171 18.895 STUDY 5 Yes Yes 26 2.8729 STUDY 6 No No 1345 33.0629 STUDY 6 No Yes 202 4.9656 STUDY 6 Yes No 2239 55.0393 STUDY 6 Yes Yes 282 6.9322 I know that the pooled OR can be calculated both from the individual study ORs (which are below) and from the pooled data set where all the raw data for those studies is under one file.     OR LCL UCL STUDY 1 1.0048 0.7661 1.3179 STUDY 2 0.7914 0.6105 1.0258 STUDY 3 0.8925 0.6222 1.2802 STUDY 4 1.0741 0.7511 1.5359 STUDY 5 0.7602 0.4811 1.2012 STUDY 6 0.8386 0.6915 1.017   I was wondering if someone can help to calculate the pooled OR either from the individual study ORs or from the pooled data set.   For reference below is the SAS code I use that does NOT yield the pooled OR.   proc freq data=master; by study; tables placebo*patient_died/nopercent norow nocol out=master_pooled; run;   proc freq data=master_pooled; weight count; tables patient_died*placebo/chisq relrisk; run;   Thanks a lot in advance!   Recep     ... View more

Hello there, I am having trouble to find the right date/time format for the character variable (or_arrival_event) in the attached SAS data file. I use the following code to convert the field into a SAS date/time field but even though the code does not yield any ERROR message it produces the wrong date/times:   if or_arrival_event in ('__/__/__ __:__') then or_arrival_event=' '; or_arrival_datetime=input(or_arrival_event,anydtdtm.); format or_arrival_datetime datetime15.;   Thanks a lot in advance!   Recep   PS: Originally the data was in Excel and the field was numeric with Excel's date/time formatting. After I import it to SAS via PROC IMPORT the field's type became character probably because of the blank values (__/__/__ __:__). ... View more

Hello there, I'm having trouble to convert the following character field to date field with the SAS code below:   data temp1; length id $1. date $10.; infile DATALINES dsd missover; input id date $; CARDS; 1, 7/ 3/2011 2, 3/17/2011 ; run;   data temp2; set temp1; new_date=input(date, mmddyy10.); format new_date date9.; run;   The code works for the second record (3/17/2011) but not for the first one (7/ 3/2011). I think the reason for that is the way the day part of the field was recorded in the second record. As you can notice there is a blank space between "/" and "3".   I was wondering if there is another SAS date format to be able to tackle this issue.   Best,   Recep   PS: I use SAS 9.4 TS Level 1M3 on W32 7Pro platform. ... View more

Hello there,   I'm trying to count the number of visits by each client within the data step for the following data (input) and desired outcome (output):   data input; input client $ visit $; datalines; 1 . 2 . 2 Y 3 Y 4 . 5 . 5 Y 5 . 5 Y 5 . 6 Y ; run;   data output; input client $ visit $ count; datalines; 1 . 0 2 . 0 2 Y 1 3 Y 1 4 . 0 5 . 0 5 Y 1 5 . 2 5 Y 3 5 . 4 6 Y 1 ; run;   Normally counting the number of visits by each client would be relatively simple task for me with the following code:   proc sort data=input;by client; data output; set input; by client; if first.client then count=1; else count+1; run;   But, one complication I would like to add is to start counting when there is a "Y" for the client. For instance Client 1 does not have a "Y" in the VISIT column so the count for him/her will start with 0 and end with 0. Client 2 has a "Y" in his/her second visit so the count will start from his/her first visit as 0 and second visit as 1. Client 5 does not have a "Y" in his/her first visit and has a "Y" in his/her second visit so the count will start from the second visit as 1. Even though his/her 3rd visit does not have a "Y" just because we started to count in the second visit we will continue to count until we see a new client.   I hope I was clear in my explanation and would like to thank in advance!   Regards,   Recep   ... View more

Hello there,   Let me try this one more time:)   I couldn't come up with a relatively simple counting logic and was hoping somebody can help me:   In the sample table created by the code below (which includes what I want to achive as "Desired_result") I would like to create a counter variable that starts to count teams within each "event". The only trick is, the code should start counting from 1 when a team within the event is a "special team".   For instance in the event number 6 (i.e. row 7 to 10), the "Desired_result" gets a value of 1 starting at "row_number" 9 because within that particular "event", team C (in row_number 7) and team A (row_number 😎 are not special teams thus the counter does not start to count from 1 until "row_number" 9. Then because it starts to count at "row_number" 9 it keeps counting after even though the team C at "row_number" 10 is not a special_team. After row_number 10 the counter starts from 0 again because a new "event" starts at "row_number" 11.   data test; input Row_number Event Team $ Special_team $ Desired_result; cards; 1 1 A No 0 2 2 B Yes 1 3 3 C No 0 4 4 B Yes 1 5 4 A No 2 6 5 A No 0 7 6 C No 0 8 6 A No 0 9 6 D Yes 1 10 6 C No 2 11 7 A No 0 12 7 C No 0 run;   I'm pretty sure I need to use a combination of first.event and RETAIN statements together but I couldn't find a solution yet. The code below did not work for me: data test1; set test; by event; retain counter; if first.event then do;    if special_team='Yes' then counter=1;    else if special_team='No' then counter=0; else counter+1; run;   Thanks a lot in advance!   Cheers, ... View more