Stata has features that make it quite different from other languages. Replace mtax = r(mean) if categ = '`part'' Summarize tax if categ = '`part'', meanonly You (including your future you) and your readers will prefer collapse. With expand 1000000, shows that speed is virtually the same. Run help collapse and help export for details.īecause you insist, below is an example that gives the same result using loops. To take to Excel you can try export excel or put excel. Why bother with the loop and creating the indicator variables? If I understand correctly, your initial dataset allows the use of a simple collapse: clear all My goal is to create a separate Excel file with each of the computer categories I've created (38 total) and the average tax for each category by year. How can I use a loop in Stata to automatically display all the mean Taxes charged for each category? I would do it by hand without a problem, but I want to repeat this process for multiple years, so I would like to use a loop for each year in order to come up with this output. Gives me the mean Tax for the category representing Hard Drives. I would like to display the averages of all these categories using a loop in Stata, but I'm not sure how to do this. I have a list of over 40 variables (two of them representing X and Y, and the rest is a bunch of dummy variables for the different categories I've created for computer items). HD dummy variable for Hard-Drives, takes value of 1 when variable X represents a HD, etc). I've created categories for these computer items using dummy variables (e.g.

Variable Y represents the tax charged for each code of variable X (e.g.

001X01, 001X02, etc) for multiple computer items with different brands.

Variable X represents distinct codes (e.g.

My dataset includes TWO main variables X and Y.

Stata 13 for dummies