DATA Step, Macro, Functions and more

Filter data

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Filter data

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

YearISINNameConsolidation code
2000Uk123ABCC1
2000Uk123ABCC*
2000Uk123ABCU1
2001Uk123ABCC2
2001Uk123ABCU1
2001UK345DEFU1
2001UK345DEFC*
2002UK345DEFU*

Table 2

YearISINNameConsolidation code
2000Uk123ABCC1
2001Uk123ABCC2
2001UK345DEFC*

Accepted Solutions
Solution
‎05-26-2015 02:48 AM
Super User
Posts: 5,441

Re: Filter data

See answer in the other thread

Please just create one thread/discussion per issue.

Data never sleeps

View solution in original post


All Replies
Solution
‎05-26-2015 02:48 AM
Super User
Posts: 5,441

Re: Filter data

See answer in the other thread

Please just create one thread/discussion per issue.

Data never sleeps
Occasional Contributor
Posts: 17

Re: Filter data

Linus,

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 188 views
  • 0 likes
  • 2 in conversation