Creating "GDP in 1960" variable from GDP variables for different years

Posted by Tom Smith on Stack Overflow See other posts from Stack Overflow or by Tom Smith
Published on 2010-04-30T14:32:15Z Indexed on 2010/05/01 8:37 UTC
Read the original article Hit count: 229

Filed under:

stata

Hi all,

I'm pretty new to stata...

I have a set of observations of the form "Country GDP Year". I want to create a new variable GDP1960, which gives the GDP in 1960 of each country for each year:

USA     $100m   1960        USA    $100m  1960  $100m
USA     $200m   1965   -->  USA    $200m  1965  $100m
Canada  $60m    1960        Canada $60m   1960  $60m

What's the right syntax to make this happen? (I assume egen is involved in some mysterious way)

Related posts about stata

Stata output files in surveys

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some survey data which I'm using Stata to analyze. I want to compute means of one variable by group and save those means to a Stata file. My code looks like this: svyset [iw=wtsupp], sdrweight(repwtp1-repwtp160) vce(sdr) svy: mean x I tried svy: by grp: mean x but that did not work… >>> More
Stata - Multiple rotated plots on graph (including distributions on sides of axes)

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to produce a single graph containing both: (1) a scatter plot (2) either histograms or kernel density functions of the Y and X variables to the left of the Y axis and below the X axis. I found a graph that does this in MATLAB -- I would just like to produce something similar in Stata:… >>> More
Stata Nearest neighbor of percentile

as seen on Stack Overflow - Search for 'Stack Overflow'
This has probably already been answered, but I must just be searching for the wrong terms. Suppose I am using the built in Stata data set auto: sysuse auto, clear and say for example I am working with 1 independent and 1 dependent variable and I want to essentially compress down to the IQR elements… >>> More
Exporting Stata results

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm sure this is an issue anyone who uses Stata for publications or reports has run into: how do you conveniently export your output to something that can be parsed by a scripting language or Excel? There are a few ADO files that to this for specific commands (try findit tabout or findit outreg2)… >>> More
simple Stata program

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to write a simple program to combine coefficient and standard error estimates from a set of regression fits. I run, say, 5 regressions, and store the coefficient(s) and standard error(s) of interest into vectors (Stata matrix objects, actually). Then, I need to do the following: Find… >>> More

Developer IT

Creating "GDP in 1960" variable from GDP variables for different years - Developer IT

Creating "GDP in 1960" variable from GDP variables for different years

stata

Related posts about stata

Stata output files in surveys

Stata - Multiple rotated plots on graph (including distributions on sides of axes)

Stata Nearest neighbor of percentile

Exporting Stata results

simple Stata program

Categories cloud