topic prohibited medications check in SAS Health and Life Sciences

prohibited medications check

deleted_user — Mon, 23 Aug 2010 13:33:21 GMT

How to check programmatically if patient is taking medications more than 3 times a week? Patient ID, drug name and dates are known.

Thanks,
Eugene

Re: prohibited medications check

sbb — Mon, 23 Aug 2010 13:46:16 GMT

Using DATE, create a WEEK_START date using the INTNX function. Then use a SAS PROC (SUMMARY, MEANS), as required, for aggregation and analysis.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

intnx function site:sas.com

Related DOC:
http://support.sas.com/documentation/cdl/en/basess/58133/HTML/default/a001304321.htm Message was edited by: sbb

Re: prohibited medications check

deleted_user — Mon, 23 Aug 2010 14:41:36 GMT

Hi SBB,
please see data below, I need to have a list of ID/DRUG/DATE, that have taken the same drug more than 3 times a week. Thank you for you help.

ID DRUG DATE
100001 ADVIL 2010-03-25
100001 TILENOL 2010-04-08
100001 TILENOL 2010-04-10
100001 TILENOL 2010-04-12
100001 TILENOL 2010-04-14
100001 TILENOL 2010-04-28
100001 TILENOL 2010-05-01
100002 ADVIL 2010-04-01
100002 ADVIL 2010-04-09
100002 ADVIL 2010-04-10
100002 ADVIL 2010-04-12
100002 ADVIL 2010-04-14
100002 TILENOL 2010-04-28
100002 TILENOL 2010-05-01

Re: prohibited medications check

sbb — Mon, 23 Aug 2010 16:45:56 GMT

Suggest you have a look at some SAS DOC on DATA step programming to get you started with learning SAS Base programming skills, my friend.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

data step programming site:sas.com

data step input data site:sas.com

Re: prohibited medications check

SPR — Tue, 09 Nov 2010 19:11:52 GMT

Hello Evolod,

This is a possible solution to your problem. For the data you supplied all patients took less than 3 medications a week.

data a;
input ID 1-6 DRUG $ 8-14 DATE YYMMDD11.;
format date date7.;
datalines;
100001 ADVIL 2010-03-25
100001 TILENOL 2010-04-08
100001 TILENOL 2010-04-10
100001 TILENOL 2010-04-12
100001 TILENOL 2010-04-14
100001 TILENOL 2010-04-28
100001 TILENOL 2010-05-01
100002 ADVIL 2010-04-01
100002 ADVIL 2010-04-09
100002 ADVIL 2010-04-10
100002 ADVIL 2010-04-12
100002 ADVIL 2010-04-14
100002 TILENOL 2010-04-28
100002 TILENOL 2010-05-01
;
run;
/* Add Year, Week */;
data a1;
set a;
yr=YEAR(Date);
wk=WEEK(Date);
run;
/* Check if patient is taking meds more that 3 times a week */;
proc SQL;
create table r as
select ID, yr, wk, Count(*) as n,
case
when calculated n > 3 then ' >3'
else '<=3'
end as result
from a1
group by ID, yr, wk
;quit;

Sincerely,
SPR

Re: prohibited medications check

SPR — Tue, 09 Nov 2010 19:31:07 GMT

Sorry, part of the code has been cut by forum software. It does not like apostrophes.
This is the last proc SQL:

proc SQL;
create table r as
select ID, yr, wk, Count(*) as n,
case
when calculated n > 3 then 'n GT 3'
else 'n LE 3'
end as result
from a1
group by ID, yr, wk
;quit;

SPR

Re: prohibited medications check

Cynthia_sas — Wed, 10 Nov 2010 03:10:30 GMT

Hi:
The issue is not the apostrophe, it is the < or > symbol. When you post to the forum using the posting mechanism, the < and > symbols, in particular, look like HTML tags. So you have to "hide" them from being mis-interpreted as HTML tags.

This previous forum posting:
http://support.sas.com/forums/thread.jspa?messageID=27609毙

explains how to use the < and > coding (for < and > respectively) to stop those symbols from being treated as HTML and truncating your posts.

cynthia

Re: prohibited medications check

sivaji — Tue, 16 Nov 2010 16:11:17 GMT

This program will check before 7 days for each record's date and if the count is ge 3 then will print the patient id and drug name corresponding to it.

data pat;
input ID DRUG : $10. d_DATE : yymmdd10.;
format d_date date9.;
cards;
100001 ADVIL 2010-03-25
100001 TILENOL 2010-04-08
100001 TILENOL 2010-04-10
100001 TILENOL 2010-04-12
100001 TILENOL 2010-04-14
100001 TILENOL 2010-04-28
100001 TILENOL 2010-05-01
100002 ADVIL 2010-04-01
100002 ADVIL 2010-04-09
100002 ADVIL 2010-04-10
100002 ADVIL 2010-04-12
100002 ADVIL 2010-04-14
100002 TILENOL 2010-04-28
100002 TILENOL 2010-05-01
;run;

proc sql;
select unique id, drug
from
(
select
id,
drug,
d_date,
count(*) as cnt
from
(
select
a.*,
b.id as b_id,
b.drug as b_drug,
b.d_date as b_d_date
from pat a
join pat b on a.id=b.id
and a.drug=b.drug
and a.d_date between b.d_date-7 and b.d_date
) a
group by 1,2,3
having count(*)>=3
);
quit;