Split country groups and divide variables' values

[Kate HDD]

Hi everyone,

I have a macro-panel set. Some of the variables are not specified by countries but by group of countries: "Venezuela, Peru, Argentina" or "Sub-saharan Africa" or even "Global"
I would like to create new lines, splitting countries of the group and dividing my variables' values by the number of countries. I mean

Turning this:
Venezuela, Peru, Argentina 2004 300 600 900

Into this:
Venezuela 2004 100 200 300
Peru 2004 100 200 300
Argentina 2004 100 200 300

(I have dummies variable for countries' region)

Thanks so much for your help!

[Nick Cox]

Please do read the FAQ Advice http://www.statalist.org/forums/help to learn about

* our preference for full real names

* giving data examples with dataex (SSC)

[Funsho Obakemi]

Hi everyone
(1) I have a panel dataset of 106 countries and 14 years. I intend to group these countries by quantile (10-90 quantiles).
Pls kindly help me with the stata code.
(2) I need stata code to estimate variance inflation factor (VIF) for quantile regression.
Thanks