## can i see if dates are same without transposing

Solved
Regular Contributor
Posts: 214

# can i see if dates are same without transposing

i need to find subjects which has same visit 6 and 7 dates. what is the most simple way to do that

 subj visit date 2568 1 06-11-2015 2568 2 11-12-2015 2568 3 06-01-2016 2568 4 22-01-2016 2568 5 18-03-2016 2568 6 20-05-2016 2568 7 17-06-2016

Accepted Solutions
Solution
‎06-29-2017 05:52 AM
Super User
Posts: 9,599

## Re: can i see if dates are same without transposing

Sort the data, then use retain or lag functions.  Or merge the two where visit=6 and visit=7.  As mentioned in all your other posts:

Post test data in the form of a datastep!

All Replies
Solution
‎06-29-2017 05:52 AM
Super User
Posts: 9,599

## Re: can i see if dates are same without transposing

Sort the data, then use retain or lag functions.  Or merge the two where visit=6 and visit=7.  As mentioned in all your other posts:

Post test data in the form of a datastep!

☑ This topic is solved.