DATA Step, Macro, Functions and more

can i see if dates are same without transposing

Accepted Solution Solved
Reply
Regular Contributor
Posts: 161
Accepted Solution

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
Super User
Posts: 7,997

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!

View solution in original post


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

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation