Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

How to deal with Multipul Permnos when calculating CAR?

Reply
Occasional Contributor
Posts: 8

How to deal with Multipul Permnos when calculating CAR?

Hi all,

I want to get the stock information for my sample in order to calculate abnormal cumulative return(CAR). However, there are some companies having more than one permnos at the time of my event. I am very confused how to deal with this kind of situation? Is there any reasonable way that I could delete all the duplicates? Cheers.

Super User
Posts: 19,820

Re: How to deal with Multipul Permnos when calculating CAR?

Posted in reply to MR_Xishuai

You have to make some business decisions before making programming decisions?

I'm going to use ID instead of Permno to avoid autocorrect in the rest of my answer.

Why are there duplicate ID's?

Is there a duplicate record in terms of time or just name?

Are the company with the same name actually the same business entity?

If you want to delete a record and they're not identical other than ID's how do you decide which record(s) to delete?

For removing duplicates look into PROC SORT.

If you need help with the programming please post sample data with expected output.

Ask a Question
Discussion stats
  • 1 reply
  • 258 views
  • 0 likes
  • 2 in conversation