For same subject If differents visits recorded with same visit date .

[pranaya_12]

For same subject If different visits recorded with same visit date .

[PaigeMiller]

Please explain this in more detail. Please provide a small data set for us to work with. Show the desired output from this small data set.

[pranaya_12]

SUBJECT FOLDERNAME SVVISDT3_RAW
00010 Week 2 10 JAN 2022
01004 Screening 10 JAN 2023
01004 Baseline/Week 1 10 JAN 2023
01004 Week 2 20 JAN 2023
09129 Screening 01 JAN 2022
09129 Baseline/Week 1 1 JAN 2022
10000 Screening 01 JAN 2023
10000 Baseline/Week 1 01 JAN 2023
11116 Screening 1 JUN 2023
12345 Screening 12 JAN 2020
12345 Baseline/Week 1 12 JAN 2020
12345 Week 2 23 FEB 2022
12345 Week 3 24 MAR 2021
20000 Screening 01 JAN 2023
21001 Screening 01 JAN 2022
21001 Baseline/Week 1 20 JAN 2022
21002 Baseline/Week 1 01 JAN 2022
21002 Week 2 02 JAN 2022
21002 Week 3 03 JAN 2022
21002 Week 4 01 MAR 2022
21002 Week 5 01 APR 2022
21002 Week 6 01 MAY 2022
21002 Week 7 01 JUN 2022
21002 Week 8 01 JUL 2022
21002 Week 9 15 JUL 2022
21002 Week 10 15 AUG 2022
21002 Week 11 15 AUG 2022
21002 Week 12 25 AUG 2022
21002 Week 13 15 SEP 2022
21002 Week 14 15 SEP 2022
21002 Week 15 15 SEP 2022

[ballardw]

What do you expect as output?

A data set with a flag value of some sort that a specific visit is a duplicate for the date? What should this look like?

A count for how many subjects have at least one duplicated date?

A data set with just duplicated visit dates for subjects?

A count of the number of duplicated visit dates per subject?