https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33082#M6392 Be sure to include the BY and/or the ID statements. These values will also be added to your output observations.<BR /> <BR /> [pre]data diffclass;<BR /> set sashelp.class;<BR /> if _n_= 1 then age=age+1;<BR /> if _n_= 2 then delete;<BR /> if _n_= 3 then weight = weight*2;<BR /> run;<BR /> <BR /> proc compare data=sashelp.class<BR /> compare=diffclass<BR /> out=cmprdat<BR /> outbase outcomp <BR /> noprint outnoequal;<BR /> id name;<BR /> run;<BR /> proc print data=cmprdat;<BR /> run;[/pre] Fri, 12 Nov 2010 18:53:07 GMT ArtC 2010-11-12T18:53:07Z https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33081#M6391 Hi<BR /> Is there any comparision record identifier which can be seen in the output result set of proc compare <BR /> Basically comapre output will be like this<BR /> <BR /> base<BR /> compare<BR /> dif<BR /> base<BR /> compare<BR /> dif<BR /> I want to have a record identifier for this comparision that will uniquely tell this is the nth comparision.<BR /> comparision number<BR /> base 1<BR /> compare 1<BR /> dif 1<BR /> base 2<BR /> compare 2<BR /> dif 2<BR /> base 3<BR /> base 4<BR /> compare 4<BR /> dif 4<BR /> <BR /> Is this possible please let me know. Fri, 12 Nov 2010 16:40:22 GMT https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33081#M6391 anandbillava 2010-11-12T16:40:22Z https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33082#M6392 Be sure to include the BY and/or the ID statements. These values will also be added to your output observations.<BR /> <BR /> [pre]data diffclass;<BR /> set sashelp.class;<BR /> if _n_= 1 then age=age+1;<BR /> if _n_= 2 then delete;<BR /> if _n_= 3 then weight = weight*2;<BR /> run;<BR /> <BR /> proc compare data=sashelp.class<BR /> compare=diffclass<BR /> out=cmprdat<BR /> outbase outcomp <BR /> noprint outnoequal;<BR /> id name;<BR /> run;<BR /> proc print data=cmprdat;<BR /> run;[/pre] Fri, 12 Nov 2010 18:53:07 GMT https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33082#M6392 ArtC 2010-11-12T18:53:07Z https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33083#M6393 No this gives the observation number of base and compare dataset. <BR /> This is not the comparision record number. Fri, 12 Nov 2010 19:01:01 GMT https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33083#M6393 anandbillava 2010-11-12T19:01:01Z https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33084#M6394 I am sorry, but I do not understand what you are asking for. What is the comparison record number? Fri, 12 Nov 2010 19:20:49 GMT https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33084#M6394 ArtC 2010-11-12T19:20:49Z https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33085#M6395 Question is not clear! could you elaborate on the same. thanks Sun, 14 Nov 2010 07:28:57 GMT https://communities.sas.com/t5/SAS-Programming/Proc-compare-Any-record-identifier/m-p/33085#M6395 sivaji 2010-11-14T07:28:57Z