Filter data

[danielhu]

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.

Table 1

Year	ISIN	Name	Consolidation code
2000	Uk123	ABC	C1
2000	Uk123	ABC	C*
2000	Uk123	ABC	U1
2001	Uk123	ABC	C2
2001	Uk123	ABC	U1
2001	UK345	DEF	U1
2001	UK345	DEF	C*
2002	UK345	DEF	U*

Table 2

Year	ISIN	Name	Consolidation code
2000	Uk123	ABC	C1
2001	Uk123	ABC	C2
2001	UK345	DEF	C*

[LinusH · Accepted solution]

See answer in the other thread

Please just create one thread/discussion per issue.

[danielhu]

Linus,

Thanks for pointing that out, but I was told by the administrator to do another discussion because my first one was not loading.