topic Re: Is there a way to extract overlapping observations from a dataset? in SAS Procedures

Is there a way to extract overlapping observations from a dataset?

sneha_dodle — Tue, 12 Mar 2019 15:33:56 GMT

I need to find overlapping advevent value for the same patid and date.
This is the dataset i have:
Patid advevent date
1 vomiting 01jan09
1 vomiting 01jan09
1 vomiting 01jan09
2 delirium 06jan09
2 nausea 06jan09
2 delirium 06jan09
2 delirium 06jan09

My outpout should be

2 delirium 06jan09
2 nausea 06jan09

Re: Is there a way to extract overlapping observations from a dataset?

PaigeMiller — Tue, 12 Mar 2019 15:36:34 GMT

Please explain further. Why are those two records the only output? What is the logic that keeps those two lines and not the others?

Re: Is there a way to extract overlapping observations from a dataset?

sneha_dodle — Tue, 12 Mar 2019 15:49:22 GMT

My task to create a dataset that contains observations with different
advevent value for the same patid and visitdate.
Im creating an outliers dataset. A single patient cannot have two
different adverse events at the same visit date.

Re: Is there a way to extract overlapping observations from a dataset?

sneha_dodle — Tue, 12 Mar 2019 15:50:38 GMT

Ive given only a sample of my dataset. i have patid values that go upto 244 and 4 to 6 advevent values for each patid

Re: Is there a way to extract overlapping observations from a dataset?

Astounding — Tue, 12 Mar 2019 16:11:30 GMT

I would recommend you go back and check on the task you were given.

It is certainly possible for a patient to have more than one adverse event on the same day. It would be unusual to be allowed to report only one.

It is unusual for a patient to report the same adverse event multiple times on the same day. If a patient reports 3 headaches on the same day, they would usually be treated as a single headache.

Re: Is there a way to extract overlapping observations from a dataset?

PaigeMiller — Tue, 12 Mar 2019 17:33:03 GMT

This does not address my earlier question: "Why are those two records the only output? What is the logic that keeps those two lines and not the others?"

Specifically, why are there no output records for Patid 1?

Re: Is there a way to extract overlapping observations from a dataset?

Shmuel — Tue, 12 Mar 2019 17:49:25 GMT

Without entering, is the query logic or not, I assume that next code may give you the requested result:

proc sort data=have out=temp nodupkey;
  by patid date advevent;
run;

data want;
set temp;
   by patid date advevent;;
        if not (first.date and last.date);
run;

Re: Is there a way to extract overlapping observations from a dataset?

s_lassen — Wed, 13 Mar 2019 10:59:34 GMT

Here is an SQL solution:

proc sql;
  create table want as
  select distinct Patid, advevent,date from have
  group by Patid, date
  having count(distinct advevent)>1;
quit;