Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Reshaping dataset

From   Andrea Molinari <>
To   statalist <>
Subject   st: Reshaping dataset
Date   Fri, 26 Apr 2013 13:24:42 -0300

Dear statalisters,

I´m working with a dataset which groups many dimensions and I´m having
a little trouble reshaping the data for the (rather basic)
calculations I need to do.

The dataset has the following columns:

year flow partner value cadena usoecon subcadena cadenacompartida1
subcadenacompartida1 cadenacompartida2 subcadenacompartida2

In order to regroup the data summing "value" by year, flow, cadena
subcadena and usoecon, I need that:

- the values in cadenacompartida1 and cadenacompartida2 go under those
in the column "cadena"

- the values in subcadenacompartida1 and "subcadenacompartida2"   go
under those in the column "subcadena"

To do so, I tried several options with -reshape long-, but I don´t
seem to get the right reshaping to get the data in the way I need to
then calculate:

bysort year flow cadena subcadena usoecon: egen double svalue=sum(value)

Any ideas of those handling large datasets would be more than welcomed!


Andrea Molinari, PhD
Investigadora Asistente
Consejo Nacional de Investigaciones Científicas y Técnicas (CONICET)
Instituto Interdisciplinario de Economía Política de Buenos Aires (IIEP- BAIRES)
Córdoba 2122, 2do. piso (
Tel: +54 11 4374-4448, int. 6362

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index