Dear all,

I am using Stata 16, on mac. I must collapse my data to region-by-year level. The problem is that the variable region is a string variable and 14 regions are included under this variable such as, Western Europe, North America, Australia and New Zealand. Under the year variable there are three years: 2015, 2016, and 2017.

I tried using collapse region, by(year), which resulted in the error message
type mismatch
r(109)

I would greatly appreciate it if someone could help me fix my command.

Thank you in advance for your help

Jason Browen