Dear listers:
I have a variable (occupational code) that takes values 1 to 10000 but
always finishes in 1, 2, 3 or 4 (qualification level). I need to create a
new variable with this last numbers (qualification level) so my new variable
takes values 1 2 3 and 4 (the original variable has no puncts or commas
separating the figures).
Is there a way to do it?
Thank you very much
Mar�a Paula Cacault
Asistente de Investigaci�n
Fundaci�n de Investigaciones Econ�micas Latinoamericanas
Tel: 4314 1990 (int. 514)
-----Mensaje original-----
De: [email protected]
[mailto:[email protected]]En nombre de Apostolos
Ballas
Enviado el: Viernes, 16 de Noviembre de 2007 09:50 a.m.
Para: [email protected]
Asunto: st: Reshaping dataset
My dataset is currently in the following format:
YEAR VARIABLE_1_company1-VARIABLE_1_company190 VARIABLE_2_company1
VARIABLE_2_company190 and so on for about 10 variables
2000
2001
.
.
.
Is there any way to reshape it, within STATA, in the format:
YEAR COMPANY VARIABLE1 - VARIABLE10
2000 Company 1
.
.
2000 COmpany 2
.
.
2000 Company 3
etc
Thnaks in advance for your assistance,
Apostolos Ballas
*
* 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/
*
* 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/
