Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down on April 23, and its replacement, **statalist.org** is already up and running.

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

From |
"Nick Cox" <n.j.cox@durham.ac.uk> |

To |
<statalist@hsphsun2.harvard.edu> |

Subject |
RE: st: Transposing datasets |

Date |
Mon, 2 Aug 2010 18:12:06 +0100 |

Thanks to Neil for the mention of -renvars- by Jeroen Weesie and myself. However, -renvars- is to be downloaded from the Stata Journal site, not SSC. If people are unclear about where my stuff may be found, a package -njc_stuff-, which _is_ to be found at SSC, is dedicated to that purpose. Nick n.j.cox@durham.ac.uk Neil Shephard replied to Kaspar Dardas > I have a dataset with about 32000 observations, which is in long > format (see structure below). gvkey is the identifier for a firm > (about 600 different firms), datadate is the monthend value between > 2002 and 2010, which of course repeats in the dataset (again, long > format) and mcap_sum is my observation, which is different for each > month and gvkey. > > gvkey datadate mcap_sum > 212782 30jun2005 4946.9 > 212782 31jul2005 5042.1 > 212782 31aug2005 5145 > 212782 30sep2005 5302.5 > 212782 31oct2005 5253.5 > 212782 30nov2005 5642.7 > 212782 31dec2005 6230 > etc... > > Well, I would like to transpose my dataset so it shows each month as a > variable and the observations are mcap_sums. My tries with reshape > failed miserably. It's useful and informative to post the code that "failed miserably" and the output that is associated with it; that way people can see what you've been trying and point out where you've gone wrong (all recommended as good practice in the Statalist FAQ, linked from the bottom of every message to the list). In the absence of this I'd suggest reshape wide mcap_sum, i(gvkey) j(datadate) ...but this may be complicated by the format of 'datadate' if it is formatted as a date variable (as underneath the formatting which presents it as you've listed it will be stored as a numeric of sorts). > (xpose wont work because I still want to keep > mcap_sum as an observation).. Does anybody has a suggestion to solve > this quickly? > > gvkey 31dec2005 30nov2005 31oct2005 > 212782 6230 5642.7 5253.5 ........... You'll never achieve these names as Stata variables are not allowed to start with numbers. -renvars- (install with -ssc install renvars-) may be of use in renaming variables here though. * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/statalist/faq * http://www.ats.ucla.edu/stat/stata/

**References**:**st: Transposing datasets***From:*Kaspar Dardas <kaspar.dardas@students.ebs.edu>

**Re: st: Transposing datasets***From:*Neil Shephard <nshephard@gmail.com>

- Prev by Date:
**Re: st: Copying Stata graphs/output to PowerPoint** - Next by Date:
**Re: AW: st: Spss vs Stata** - Previous by thread:
**AW: st: Transposing datasets** - Next by thread:
**st: AW: Transposing datasets** - Index(es):