Hello Dear Cynthia, I am a beginner and undergraduate student who is trying to replicate a finance paper individually. First obstacle was i needed to learn sas by myself, and still learning. as far as i thought, cusip is an unique identifier which represents a firm or company. this is a sample of my data set: from here, i want to get number of firms by cusip for each year. how may firms in a year. of course, i was not doing anything and i had tried to use count function; proc sql; select count(distinct cusip) as count_cusip, count(distinct names date) as count_names date from tmp1.msenames; quit; i have attached a sample data set. thanks for you reply and feedback, Best wishes, sincerely Daniel
... View more