Hello good people,

I have to work with CompustatCRSPExecucomp merged dataset. I need to count the number of firms and the number of executives in the merged dataset. I have cusip, gvkey, fyear, permno, execid. Please suggest how can I get the number of firms and the number of executives in the dataset. is the following code okay?

egen cusiptag=tag(cusip)
count if cusiptag

Thanks in advance for your kind help.