Hi guys, I need to classify the 6 adverse events (3 adverse events by subjid)  in the variable visit, any help? Example...the first adverse event of subject 1 (02jan2008)...will correspond visit=1, and, the last visit of subject 1 (03jun2008) will correpond visit=. , and so on... I need to classify the 6 adverse events. It is a simple example...I got 500 subjects..thanks in advance. V. data drug; length subjid visit start stop 8; input @1 SUBJID @4 VISIT @6 START DATE9. @16 STOP DATE9.;  format start stop date9.; datalines; 1  1 01JAN2008 15JAN2008       1  2 16jan2008 30jan2008     1  3 01feb2008 15feb2008         1  4 16feb2008 28feb2008 1  5 01mar2008 15mar2008 1  6 16mar2008 30mar2008 2  1 05jan2009 15jan2009     2  2 16jan2009 25jan2009    2  3 05feb2009 15feb2009       2  4 16feb2009 25feb2009 2  5 05mar2009 15mar2009 2  6 16mar2009 25mar2009 ; RUN; DATA AE; LENGTH SUBJID ADVERSE 8; INPUT @1 SUBJID @3 ADVERSE DATE9.; FORMAT ADVERSE DATE9.; DATALINES; 1 02jan2008 1 24feb2008 1 03jun2008 2 01jan2009 2 05feb2009 2 15mar2009 ; RUN; ... View more

Hi everyone, there are anotehr way in proc sql to obtain the final value, I've had to use another datasset new to get it, but i dunno if i can do it in the proc sql queries...thanks. data have;    length leg  sid 8  phase  treattxt $10;    input sid leg phase $ treattxt $;    datalines;    1 100 active drug    1 100 off    drug    2 101 active placebo    3 101 off    placebo    3 101 active placebo    4 100 active drug    5 100 active drug    6 101 active placebo    6 101 off    placebo    ;    run; proc sql noprint;      create table ntreat as      select count(distinct sid) as n, leg, treattxt    from have    where phase='active'    group leg, treattxt;    create table ntotal as     select count(distinct sid) as n, ' total' as treattxt,9999 as leg    from have    where phase='active';    quit;     data new;       set ntreat ntotal;       col0= ' ';     run; ... View more

Hello everyone, 3 questions.... when I am testing a drug against placebo, 1. what are the test I can make to see if there are significance differences or not? For a SBP data results of adult males, the significance test shows that μ (drug) is significantly different from μ0 (placebo = 129 mm Hg) at the significance level  alpha= 0.05, and the 95% (CI = 129.1 to 130.9 mm Hg) did not include 129 mm Hg. On the other hand, the difference between μ (drug) and μ0 (placebo) is not significant at the alpha=0.01he doifha ; the 99% (CI  = 128.8 to 131.2 mm Hg) for μ does indeed contain μ0. 2. What CI and alpha are better to get? 3. Can someone give a simple explanation that could help me understand this difference between get CI 95 and 99? Thanks, V. V. ... View more