can i see if dates are same without transposing

[vraj1]

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

[RW9 · Accepted solution]

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!