Hi all, First time poster (very new to SAS). I'm running an event study and I have a large dataset. I'm trying to include only those company's (ID) that have data from -5 <= time <= 10... but I noticed that there many companies in the dataset that have missing data in the time range. For example, in the tables below, company ID 001 satisfies the requirement while company ID 150 has missing data in the time range. How am I able to scrap the companies in the dataset with missing data in -5 <= time <= 10 ? Thanks kindly! My apologies if this question is trivial. ID time price 001 -5 6.5 001 -4 6.9 001 -3 7.1 001 -2 7.23 001 -1 7.12 001 0 8.02 001 1 8.55 001 2 8.49 001 3 8.52 001 4 8.69 001 5 8.75 001 6 8.65 001 7 8.6 001 8 8.66 001 9 8.7 001 10 8.72 ID time price 150 -5 . 150 -4 . 150 -3 . 150 -2 . 150 -1 . 150 0 22.5 150 1 26.88 150 2 27.16 150 3 27.05 150 4 27.22 150 5 29 150 6 28.64 150 7 28.12 150 8 28.01 150 9 28.29 150 10 28.55
... View more