Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: creating a variable equal to the last number of another


From   María Paula Cacault <mpaula@fiel.org.ar>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: creating a variable equal to the last number of another
Date   Fri, 16 Nov 2007 10:18:26 -0300

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: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu]En nombre de Apostolos
Ballas
Enviado el: Viernes, 16 de Noviembre de 2007 09:50 a.m.
Para: statalist@hsphsun2.harvard.edu
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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index