Saving variables after collapse

[Eddie Brighton]

Dear Statalist:

My goal is to aggregate individual-level data (e.g., age, sallary, etc.) to the organizational-level with average values. I wonder how I can accomodate the values I obtain from using the collapse command to the working dataset. Thanks.

[Maarten Buis]

The easiest way is to not use collapse. Instead you can create those variables with egen

[William Lisowski]

If for some reason you need to use collapse, you can then use merge to add the collapsed results to the matching observations in the individual dataset.

[Eddie Brighton]

Thanks for your replies. I've been using egen, but the problem is that my dataset has become large (60GB), and takes so much time for running a single line. I thought using the collapse command would reduce unneccesary variables and increase computing speed.

[Maarten Buis]

Ok, maybe look at gtools ( https://gtools.readthedocs.io/ ).

[Eddie Brighton]

Thanks for gtools. It's much faster indeed!