BookmarkSubscribeRSS Feed
pranaya_12
Calcite | Level 5

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

3 REPLIES 3
PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
pranaya_12
Calcite | Level 5
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
Super User

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?

 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 911 views
  • 0 likes
  • 3 in conversation