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;
proc sql;
create table want as
select ae.id, ae.adverse, d.visit
from ae
left join drug d
ae.subjid=d.subjid
and ae.adverse between d.start_date and d.stop_date;
quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.