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

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

From |
R Zhang <r05zhang@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: RE: sxpose -not possible; would exceed present limit on number of variables |

Date |
Wed, 19 Feb 2014 18:30:52 -0500 |

Kieran, the data I posted is just one observation with 21 variable to show what it looks like and what I want after transformation. the actual data 13,458 observation and 21 variables. I apologize for the confusion. -Rochelle On Wed, Feb 19, 2014 at 4:20 PM, Kieran McCaul <kieran.mccaul@uwa.edu.au> wrote: > ... > > > The data you have looks like the following, is that correct? > > input str20 v1 v2 > EntityID 100091 > corpid1 8101 > begyr1 1961 > gvkey1 1000 > endyr1 1970 > corpid2 8091 > begyr2 1971 > gvkey2 1000 > endyr2 1973 > corpid3 8011 > begyr3 1974 > gvkey3 1001 > endyr3 2000 > corpid4 8011 > begyr4 1974 > gvkey4 1001 > endyr4 2000 > corpid5 8011 > begyr5 1974 > gvkey5 1001 > endyr5 2000 > end > > This dataset has 21 observations and 2 variables. > > You say your data has 21 variables and 13,458 observations. If it is in the form above, then your data had 21 observations and 13,458 variables. > > Your version of Stata has a limit to how many variables you can read in: You are exceeding it. > > > > > > > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of R Zhang > Sent: Thursday, 20 February 2014 5:06 AM > To: statalist@hsphsun2.harvard.edu > Subject: st: sxpose -not possible; would exceed present limit on number of variables > > Hi Statalisters, > > > My data has 13,458 observation and 21 variables. > EntityID corpid1 begyr1 gvkey1 endyr1 corpid2 begyr2 gvkey2 endyr2 > corpid3 begyr3 gvkey3 endyr3 corpid4 begyr4 gvkey4 endyr4 corpid5 > begyr5 gvkey5 endyr5 > 100091 8101 1961 1000 1970 8091 1971 1000 1973 8011 1974 1001 2000 > 8012 2000 1001 2002 8012 2003 1001 2005 > > > for each unique EntityID, the corresponding gvkey and corpid could vary over time as indicated by begyr and endyr, > > what I want is a dataset that give me the gvkey and corpid for each time period, so I can match it to another dataset that has company specific financial data , the match variable will be gvkey, year. > > as of now, i thought I should reshape the data, Someone on the forum kindly offered me the following program to reshape my data. sample code (see below) works for his hypothetical data, but when i ran with my data (13,458 observation and 21 variables.). I got an error "not possible; would exceed present limit on number of variables", could you shed light on this? > > ***************** > input str20 v1 v2 > EntityID 100091 > corpid1 8101 > begyr1 1961 > gvkey1 1000 > endyr1 1970 > corpid2 8091 > begyr2 1971 > gvkey2 1000 > endyr2 1973 > corpid3 8011 > begyr3 1974 > gvkey3 1001 > endyr3 2000 > corpid4 8011 > begyr4 1974 > gvkey4 1001 > endyr4 2000 > corpid5 8011 > begyr5 1974 > gvkey5 1001 > endyr5 2000 > end > > compress > sxpose, clear firstnames force > reshape long corpid begyr gvkey endyr, i(EntityID) j(pd) > *********************** > > what I ultimately want is : > EntityID corpid year gvkey > 100091 8101 1961 1000 > 100091 8101 1962 1000 > 100091 8101 1963 1000 > 100091 8101 1964 1000 > 100091 8101 1965 1000 > 100091 8101 1966 1000 > … > 100091 8091 1971 1000 > 100091 8091 1972 1000 > 100091 8091 1973 1000 > 100091 8091 1974 1000 > > p.s if you think there is a better way , please also share. > > thanks!!! > > -R > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/faqs/resources/statalist-faq/ > * http://www.ats.ucla.edu/stat/stata/ * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**RE: st: RE: sxpose -not possible; would exceed present limit on number of variables***From:*Kieran McCaul <kieran.mccaul@uwa.edu.au>

**References**:**st: sxpose -not possible; would exceed present limit on number of variables***From:*R Zhang <r05zhang@gmail.com>

**st: RE: sxpose -not possible; would exceed present limit on number of variables***From:*Kieran McCaul <kieran.mccaul@uwa.edu.au>

- Prev by Date:
**st: SYS GMM with xtabond2 [company profitability]** - Next by Date:
**st: Mata compatibility problem** - Previous by thread:
**st: RE: sxpose -not possible; would exceed present limit on number of variables** - Next by thread:
**RE: st: RE: sxpose -not possible; would exceed present limit on number of variables** - Index(es):