duplicate entries in compustat north america annual fundamentals??
Posted: 28 June 2016 08:39 AM   [ Ignore ]
Newbie
Rank
Total Posts:  1
Joined  2016-06-27

Even if i did not change the default settings (it is written on the query page that the default setting should result in a unique gvkey-year combo), I did get a large number of duplicates (same year&gvkey;). Annoyingly enough, the numbers for the variables are usually not even close to each other; sometimes one of the entries has a lot of missing values , but I couldn’t find any pattern. Sometimes the fiscal year changes, but not always. I did remove automatically the first of each duplicate entries since i had no idea which one was the correct one, and WRDS customer service didn’t bother to answer. By the way, could anyone find a working phone number? They refuse to give any,but it is really frustrating to wait every time ages until getting an answer. Got way better customer service from other less pricey data services…

Profile
 
 
Posted: 29 June 2016 04:24 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Anac,

If you filter on this: “indfmt=‘INDL’ and datafmt=‘STD’ and popsrc=‘D’ and consol=‘C’”—do you then still have duplicates?

Best,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile