Dear all.
I'm trying to divide my dataset into pieces based on the values in an variable. My set is an large panel data, containing a number of companies. Each company has a value in the variable "industryid", which allows me to identify what industry it operates in.
I am now trying to divide this large dataset into smaller sets for each single industry.
The reason why I'm struggling is that I wish to apply this separation for a number of different sets, which might contain a different amount of industries, without having to identify the values in the industry-variable myself.
I have tried to make a macro with the values using the "levelsof" command, and then apply it with:
foreach industryid in `industryids' {
keep if industryid==`industryids'
save industry_`industryids'
}
But this runs back as "invalid '10'".
Any suggestions on how to do this?
Forgive me if this is way to basic...
Your feedback will be appreciated.
-Andreas
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
