Dear all,

I tried to find an appropriate post which relates to my problem but I was not successfull in doing so. That is why I open a new one.

Overall, I have a quite large dataset which contains ca. 1,500 variables. I wanted to check for collinearity and therefore use the command _rmcoll.

Code:
_rmcoll leverage cashflow roa dividend manager_ID_*
Once, I run this command, I receive information on which variables are omitted because of collinerarity. Ultimately, I would like to drop those variables which are detected by the _rmcoll command but _rmcoll only generates a flagged and expaneded variable list, stored in a macro [ r(varlist) ]:

Code:
dis "$`r(varlist)'"
Forcedrop does not work since most of my variables are factor variables (manager_ID_1, ... , manager_ID_999) indicating whether a specific manager has been employed in the respective firm-year.

Is there anybody who can help me? It is important that I detect and dropp the collinear variables before running the regression. Any help is highly appreciated.

Kind regards,
L