Hi all,
I am having some troubles getting quarterly data on CRSP/Compustat Merged database. The same error message keeps appearing:“WHERE clause operator requires compatible variables”. I have been dowloading annual data without any issue though.
Below are the details of the querry:
Libraries/Data Sets crspa/ccmfundq /
Frequency/Date Range qtr / 01Jan1990 - 31Dec2013
Search Variable CUSIP
Input Codes all item(s) -all-
Conditional Statements DATAFQTR eq 199801
Output format/Compression xlsx /
Variables Selected CURCDQ COSTAT CONM TIC CUSIP EXCHG FYR CURNCDQ DATAFQTR CSHOPQ CSHOQ DVPQ NIQ CDVCY DVPY DVPSPQ MKVALTQ PRCCQ
Extra Variables and Parameters Selected C INDL STD
Other questions, I cannot find the variable “Total Shares Repurchased - Quarter” (CSHOPQ) for the annual data (annual amount of share repurchased), have you?
Thanks a lot,
Alex