Dear community, As you can read above I am supposed to work with a huge dataset consisting of yearly earnings numbers of >20000 companies. In particular, I am analyzing the persistence of earnings which is measured (amongst others) by the Beta-coefficient estimator of an ARIMA time series Regression. I already cleaned the data set by e.g. deleting observations for firms which reported their earnings for less than 7 consecutive years. Not taking into consideration the ARIMA model specification Theory - assume I use ARIMA (1,0,0) - my issue is: Since I have that many companies which I can group the ARIMA procedure for, the CPU takes infinitely long to run a grouped Analysis. However, if I don't group it (using BY Statement), SAS would not aknowledge the Panel structure of my dataset, would it? I am a fairly unexperienced SAS user, that's why I'm not sure about this one. Alternatively, I ran a proc panel Regression, which I assume acknowledges the Panel structure of my data and gave me results for an overall Regression. However, it obviously does not give descriptive statistics (percentiles, mean, …) concerning the Regression properties for each individual Company. Do you guys have any advice for me to conduct my analysis most efficiently in my case? Does it even make sense to use proc arima for Panel type data? Any help will be much appreciated, thanks a lot in advance!
... View more