This is very difficult for anyone to comment on without 
any detail. For example, when you say that
Stata collapses, what do you mean, precisely? 
Nick 
[email protected] 
D Jimenez Rubio
> I am working with a large micro data which contains approx. 
> 110,000 obs.
> I am having lots of problems when trying to work with my data as Stata
> collapses very frequently. I have set my memory up to 1g and I have
> compressed all my variables, but the problems persist. I would
> appreciate any suggestions in this respect. 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/