Duplicates

Duplicates

by Michael Flores -

Hello, I am wondering for part 2, sections g&h, if you are wanting all the duplicates of BOTH "id" AND "visitdate" or the duplicates of "id" AND/OR "visitdate"? 

In other words, is there any difference between these two? (the output is different)

duplicates report id visitdate

OR

duplicates report id
duplicates report visitdate

Additionally, do we need to sum all of the duplicates to answer the question "g" or is the report itself the answer?

Thanks!
Mike

Re: Duplicates

by Crystal Langlais -
Hi Mike, thanks for posting.
We are looking for duplicates that exist when considering both variables in combination (your first line of code).

There is a difference in the two options you provided. The first looks for duplicates considering both variables while the later looks at duplicates considering only "id" and then only "visitdate". What we want to know is if there are any patient-visit day combinations that are the same (so we use the former code).

For part g, you will need to provide both the code and a text response of the total duplicates. You will need to comment out the text response in the do file.

Hope this helps.