Good morning, ****************************** Below is a display of my data (just showing a few observations for a large data set). gvkey year acode 1000 1990 10 1000 1990 20 1000 1991 10 1000 1991 11 1000 1991 12 1001 1990 10 1001 1990 15 1001 1991 11 1001 1991 13 1001 1991 14 Gvkey is firm identifier, acode is the analyst identifier, for firm 1000, it is followed by 2 financial analysts each is identified by its unique acode. I want to compute how many firms each analyst cover in each year, expected outcome : for year 1990, acode=10, coverage=2 (it covers 1000, 1001 firms), for year 1990, acode=20, coverage=1. Etc. I tried proc freq data=a; tables acode*year /out=counts; run; this will not work given that my data has 4 million records, computer froze while running. can you suggest another way? thanks, Lan
... View more