https://communities.sas.com/t5/SAS-Programming/creating-flag-by-compare-single-row-with-multiple-rows/m-p/480096#M124040 <P>Can someone suggest some idea on this issue</P> Fri, 20 Jul 2018 23:08:50 GMT reddy19 2018-07-20T23:08:50Z https://communities.sas.com/t5/SAS-Programming/creating-flag-by-compare-single-row-with-multiple-rows/m-p/479961#M123977 <P>Hi all,</P> <P>I have a data like this</P> <P><BR />site&nbsp; pt&nbsp; &nbsp;visitname&nbsp; visit_dt&nbsp;&nbsp;&nbsp;&nbsp; visit1&nbsp;&nbsp; &nbsp;visit1_dt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flag<BR />1101&nbsp; 11011001&nbsp; visit1&nbsp;&nbsp;&nbsp;&nbsp; 2017-12-22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;data in crf not in vendor<BR />1101&nbsp; 11011001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit1&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;2017-12-22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data in vendor not in CRF</P> <P>1104&nbsp; 11041002&nbsp; visit4&nbsp;&nbsp;&nbsp;&nbsp; 2017-07-07&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data in crf not in vendor&nbsp; <BR />1104&nbsp; 11041002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;Unscheduled&nbsp;&nbsp;&nbsp;&nbsp; 2017-07-07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; data in vendor not in CRF&nbsp;&nbsp;&nbsp; <BR />&nbsp;<BR />9910&nbsp; 99011002&nbsp;visit5&nbsp;&nbsp;&nbsp; 2018-02-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;data in crf not in vendor&nbsp;</P> <P><BR />I want ouput to be like this:</P> <P>site&nbsp; pt&nbsp; &nbsp;visitname&nbsp; visit_dt&nbsp;&nbsp;&nbsp;&nbsp; visit1&nbsp;&nbsp; &nbsp;visit1_dt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flag<BR />1101&nbsp; 11011001&nbsp; visit1&nbsp;&nbsp;&nbsp;&nbsp; 2017-12-22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;date mismatch<BR />1101&nbsp; 11011001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit1&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;2017-12-21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date mismatch</P> <P>1104&nbsp; 11041002&nbsp; visit4&nbsp;&nbsp;&nbsp;&nbsp; 2017-07-07&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit mismatch<BR />1104&nbsp; 11041002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;Unscheduled&nbsp;&nbsp;&nbsp;&nbsp; 2017-07-07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit mismatch&nbsp;&nbsp; <BR />&nbsp;<BR />9910&nbsp; 99011002&nbsp;visit5&nbsp;&nbsp;&nbsp; 2018-02-01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;data in crf not in vendor&nbsp;</P> <P><BR />need to check all the rows in a dataset to see site,pt and visit&nbsp; is same then need to create the 'date mismatch' flag.same for visit.<BR />I'm using below code but it is flagging only one record instead of 2 records,let me know how can i fix this issue.&nbsp;&nbsp;&nbsp;</P> <P><BR />data final2;<BR />&nbsp;MERGE final1 (firstobs=1)<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; final1 (firstobs=2 rename=(site = st<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; pt=pt2<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visitname=visitname1<BR />&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit_dt=visit_dt1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit1_dt=visit1_dt1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; visit1=visit1_1<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; flag=flag_1));<BR />&nbsp;&nbsp; if&nbsp;&nbsp;&nbsp; site = st<BR />&nbsp;&nbsp; and&nbsp; pt&nbsp;= pt2<BR />&nbsp;&nbsp; and visitname = visit1_1 <BR />&nbsp;&nbsp; and visitname1 = visit1<BR />&nbsp;&nbsp; and flag_1 ne flag&nbsp; then Flag2 = "Date Mismatch";<BR />&nbsp;&nbsp; else&nbsp; flag2 = " ";</P> <P>/*&nbsp; drop st pt2 visitname1 visit_dt1 visit1_dt1 visit1_1 flag_1;*/</P> <P>run;&nbsp;</P> <P>Can you please guide me how to fix this issue.</P> <P>Thank you so much.&nbsp;&nbsp;</P> Fri, 20 Jul 2018 17:11:59 GMT https://communities.sas.com/t5/SAS-Programming/creating-flag-by-compare-single-row-with-multiple-rows/m-p/479961#M123977 sasg 2018-07-20T17:11:59Z https://communities.sas.com/t5/SAS-Programming/creating-flag-by-compare-single-row-with-multiple-rows/m-p/480096#M124040 <P>Can someone suggest some idea on this issue</P> Fri, 20 Jul 2018 23:08:50 GMT https://communities.sas.com/t5/SAS-Programming/creating-flag-by-compare-single-row-with-multiple-rows/m-p/480096#M124040 reddy19 2018-07-20T23:08:50Z