topic can i see if dates are same without transposing in SAS Programming https://communities.sas.com/t5/SAS-Programming/can-i-see-if-dates-are-same-without-transposing/m-p/371583#M88779 <P>i need to find subjects which has same visit 6 and 7 dates. what is the most simple way to do that</P> <P>&nbsp;</P> <TABLE width="197"> <TBODY> <TR> <TD width="60">subj</TD> <TD width="64">visit</TD> <TD width="73">date</TD> </TR> <TR> <TD>2568</TD> <TD>1</TD> <TD>06-11-2015</TD> </TR> <TR> <TD>2568</TD> <TD>2</TD> <TD>11-12-2015</TD> </TR> <TR> <TD>2568</TD> <TD>3</TD> <TD>06-01-2016</TD> </TR> <TR> <TD>2568</TD> <TD>4</TD> <TD>22-01-2016</TD> </TR> <TR> <TD>2568</TD> <TD>5</TD> <TD>18-03-2016</TD> </TR> <TR> <TD>2568</TD> <TD>6</TD> <TD>20-05-2016</TD> </TR> <TR> <TD>2568</TD> <TD>7</TD> <TD>17-06-2016</TD> </TR> </TBODY> </TABLE> Thu, 29 Jun 2017 09:31:43 GMT vraj1 2017-06-29T09:31:43Z can i see if dates are same without transposing https://communities.sas.com/t5/SAS-Programming/can-i-see-if-dates-are-same-without-transposing/m-p/371583#M88779 <P>i need to find subjects which has same visit 6 and 7 dates. what is the most simple way to do that</P> <P>&nbsp;</P> <TABLE width="197"> <TBODY> <TR> <TD width="60">subj</TD> <TD width="64">visit</TD> <TD width="73">date</TD> </TR> <TR> <TD>2568</TD> <TD>1</TD> <TD>06-11-2015</TD> </TR> <TR> <TD>2568</TD> <TD>2</TD> <TD>11-12-2015</TD> </TR> <TR> <TD>2568</TD> <TD>3</TD> <TD>06-01-2016</TD> </TR> <TR> <TD>2568</TD> <TD>4</TD> <TD>22-01-2016</TD> </TR> <TR> <TD>2568</TD> <TD>5</TD> <TD>18-03-2016</TD> </TR> <TR> <TD>2568</TD> <TD>6</TD> <TD>20-05-2016</TD> </TR> <TR> <TD>2568</TD> <TD>7</TD> <TD>17-06-2016</TD> </TR> </TBODY> </TABLE> Thu, 29 Jun 2017 09:31:43 GMT https://communities.sas.com/t5/SAS-Programming/can-i-see-if-dates-are-same-without-transposing/m-p/371583#M88779 vraj1 2017-06-29T09:31:43Z Re: can i see if dates are same without transposing https://communities.sas.com/t5/SAS-Programming/can-i-see-if-dates-are-same-without-transposing/m-p/371587#M88780 <P>Sort the data, then use retain or lag functions. &nbsp;Or merge the two where visit=6 and visit=7. &nbsp;As mentioned in all your other posts:</P> <P><STRONG>Post test data in the form of a datastep!</STRONG></P> Thu, 29 Jun 2017 09:48:54 GMT https://communities.sas.com/t5/SAS-Programming/can-i-see-if-dates-are-same-without-transposing/m-p/371587#M88780 RW9 2017-06-29T09:48:54Z