topic Filter data in SAS Programming https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218717#M40310 <HTML><HEAD></HEAD><BODY><P>Hi, I am new to SAS and would like some help in filtering this set of data from bankscope which has a problem with duplications. There are instances where a certain bank in a certain year has 3 rows of financial data, hence there is a need to remove/delete duplicates according to the following priority of filtering - C1/C2, C*, U1/U2, U*. From table 1 to table 2.</P><P></P><P>Table 1</P><TABLE><TBODY><TR><TD>Year</TD><TD>ISIN</TD><TD>Name</TD><TD>Consolidation code</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C1</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C*</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>C2</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>C*</TD></TR><TR><TD>2002</TD><TD>UK345</TD><TD>DEF</TD><TD>U*</TD></TR></TBODY></TABLE><P>Table 2</P><TABLE><TBODY><TR><TD>Year</TD><TD>ISIN</TD><TD>Name</TD><TD>Consolidation code</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C1</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>C2</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>C*</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 26 May 2015 00:30:01 GMT danielhu 2015-05-26T00:30:01Z Filter data https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218717#M40310 <HTML><HEAD></HEAD><BODY><P>Hi, I am new to SAS and would like some help in filtering this set of data from bankscope which has a problem with duplications. There are instances where a certain bank in a certain year has 3 rows of financial data, hence there is a need to remove/delete duplicates according to the following priority of filtering - C1/C2, C*, U1/U2, U*. From table 1 to table 2.</P><P></P><P>Table 1</P><TABLE><TBODY><TR><TD>Year</TD><TD>ISIN</TD><TD>Name</TD><TD>Consolidation code</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C1</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C*</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>C2</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>U1</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>C*</TD></TR><TR><TD>2002</TD><TD>UK345</TD><TD>DEF</TD><TD>U*</TD></TR></TBODY></TABLE><P>Table 2</P><TABLE><TBODY><TR><TD>Year</TD><TD>ISIN</TD><TD>Name</TD><TD>Consolidation code</TD></TR><TR><TD>2000</TD><TD>Uk123</TD><TD>ABC</TD><TD>C1</TD></TR><TR><TD>2001</TD><TD>Uk123</TD><TD>ABC</TD><TD>C2</TD></TR><TR><TD>2001</TD><TD>UK345</TD><TD>DEF</TD><TD>C*</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 26 May 2015 00:30:01 GMT https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218717#M40310 danielhu 2015-05-26T00:30:01Z Re: Filter data https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218718#M40311 <HTML><HEAD></HEAD><BODY><P>See answer in the other thread <A __default_attr="274467" __jive_macro_name="message" class="jive_macro jive_macro_message" href="https://communities.sas.com/"></A></P><P>Please just create one thread/discussion per issue.</P></BODY></HTML> Tue, 26 May 2015 06:48:26 GMT https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218718#M40311 LinusH 2015-05-26T06:48:26Z Re: Filter data https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218719#M40312 <HTML><HEAD></HEAD><BODY><P>Linus,</P><P></P><P>Thanks for pointing that out, but I was told by the administrator to do another discussion because my first one was not loading. </P></BODY></HTML> Tue, 26 May 2015 23:20:28 GMT https://communities.sas.com/t5/SAS-Programming/Filter-data/m-p/218719#M40312 danielhu 2015-05-26T23:20:28Z