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

st: ST: creating new variables from a long list

From   "Eric Uslaner" <>
To   <>
Subject   st: ST: creating new variables from a long list
Date   Thu, 29 Oct 2009 15:47:03 -0400


I have a data set of 92 sets of crime rankings by SMSA.  But whoever put them together made a mess out of them (originally in Excel, but I have them in Stata).  The data set consists of about 230 SMSAs (standard metropolitan statistical areas) and their crime totals and ranks in 4 columns: data set number, SMSA name, total, rank--92 times (one for each data set number) so I have about 30,000+ entries. 

What I want to do is to create 92 * 2 variables so that the data set would look like this:

SMSAname total1 rank1 total2 rank2...total92 rank92

ideally using SMSAname only once rather than 92 times.  Any suggestions as to how to do this would be greatly appreciated.

Thanks much,


*   For searches and help try:

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