topic How to deal with Multipul Permnos when calculating CAR? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/How-to-deal-with-Multipul-Permnos-when-calculating-CAR/m-p/200010#M2643 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>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.</P></BODY></HTML> Thu, 12 Mar 2015 15:15:36 GMT MR_Xishuai 2015-03-12T15:15:36Z How to deal with Multipul Permnos when calculating CAR? https://communities.sas.com/t5/SAS-Data-Science/How-to-deal-with-Multipul-Permnos-when-calculating-CAR/m-p/200010#M2643 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>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.</P></BODY></HTML> Thu, 12 Mar 2015 15:15:36 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-deal-with-Multipul-Permnos-when-calculating-CAR/m-p/200010#M2643 MR_Xishuai 2015-03-12T15:15:36Z Re: How to deal with Multipul Permnos when calculating CAR? https://communities.sas.com/t5/SAS-Data-Science/How-to-deal-with-Multipul-Permnos-when-calculating-CAR/m-p/200011#M2644 <HTML><HEAD></HEAD><BODY><P>You have to make some business decisions before making programming decisions?</P><P>I'm going to use ID instead of Permno to avoid autocorrect in the rest of my answer.</P><P></P><P>Why are there duplicate ID's?</P><P>Is there a duplicate record in terms of time or just name?</P><P>Are the company with the same name actually the same business entity?</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">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?</SPAN></P><P></P><P>For removing duplicates look into PROC SORT.</P><P></P><P>If you need help with the programming please post sample data with expected output.</P></BODY></HTML> Thu, 12 Mar 2015 16:50:51 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-deal-with-Multipul-Permnos-when-calculating-CAR/m-p/200011#M2644 Reeza 2015-03-12T16:50:51Z