thanks jeff and jeremie, i am attaching 40 rows of the data, randomly picked from the large table.
the vars are - entity (1-46, with some missing IDs not included due to missing data), group (1/2), sub group (1/2/3/4), year (2002-2016), y, x1 and x2 - large values included due to size of players - (may not be considered as outliers as they constitute the sample and are important countrywide entities) hope this helps. i thought an hts may be a better analytical tool compared to panel (a pivot table in excel helps me obtain some aggregation), hence the query ... thanks for your guidance, *....* *Deva* ............... *in search of knowledge, everyday something is added ....* *in search of wisdom, everyday something is dropped ... an old Chinese Proverb* ::::::::::::::::::::::::: On Thu, Jan 11, 2018 at 12:22 AM, Jeff Newmiller <jdnew...@dcn.davis.ca.us> wrote: > Sorry Jérémie, I mis-read who the OP was. Deva needs to get the ball > rolling. > > I would say that for a hierarchical analysis the sample data generally > needs to be larger than for other types of analysis to illustrate > correlation between classification variables or the example calculation > will break. That is, 10 rows will likely be insufficient for a dry run. > > -- > Sent from my phone. Please excuse my brevity. > > On January 10, 2018 2:02:29 PM PST, Jeff Newmiller < > jdnew...@dcn.davis.ca.us> wrote: > >You are the one with data. Supply what you have (or a simulated version > >of same, hence the reading recommendation) using dput, and someone may > >suggest how to transform it. In most cases a simple tabular format > >(data frame) is sufficient. > >-- > >Sent from my phone. Please excuse my brevity. > > > >On January 10, 2018 12:20:47 PM PST, "Jérémie Juste" > ><jeremieju...@gmail.com> wrote: > >>Hello, > >> > >>It's difficult to help without a sample of the format. Can you provide > >>a > >>short sample like 10 lines and a few columns.? > >> > >>Best regards, > >>Jeremie > >> > >> > >>On Wed, Jan 10, 2018 at 6:12 PM, John Kane via R-help > >><r-help@r-project.org> > >>wrote: > >> > >>> Have a look at > >>http://stackoverflow.com/questions/5963269/how-to-make- > >>> a-great-r-reproducible-example > >>> and > >>> http://adv-r.had.co.nz/Reproducibility.html > >>> > >>> > >>> > >>> > >>> On Wednesday, January 10, 2018, 11:51:22 AM EST, deva d < > >>> devazresea...@gmail.com> wrote: > >>> > >>> dear all, > >>> > >>> i need some help in structuring my data file for a hierarchical time > >>series > >>> analysis. > >>> > >>> can someone help please ? > >>> > >>> i have a 600 row database in the nature of a panel data, with 3 time > >>series > >>> values of interest. the data also has 4 classificatory variables > >>comprising > >>> a code for each entity in the panel, a value for time (year), and > >>> classification of type of entity and a further sub-group of the > >type. > >>> > >>> i am unable to structure the data file for performing the hts > >>analysis. > >>> > >>> thanks in advance. > >>> > >>> *....* > >>> > >>> *Deva* > >>> > >>> > >>> ............... > >>> > >>> > >>> > >>> *in search of knowledge, everyday something is added ....* > >>> > >>> *in search of wisdom, everyday something is dropped ... an old > >>Chinese > >>> Proverb* > >>> ::::::::::::::::::::::::: > >>> > >>> [[alternative HTML version deleted]] > >>> > >>> ______________________________________________ > >>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > >>> https://stat.ethz.ch/mailman/listinfo/r-help > >>> PLEASE do read the posting guide http://www.R-project.org/ > >>> posting-guide.html > >>> and provide commented, minimal, self-contained, reproducible code. > >>> > >>> [[alternative HTML version deleted]] > >>> > >>> ______________________________________________ > >>> R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > >>> https://stat.ethz.ch/mailman/listinfo/r-help > >>> PLEASE do read the posting guide http://www.R-project.org/ > >>> posting-guide.html > >>> and provide commented, minimal, self-contained, reproducible code. > >>> > >> > >> > >> > >>-- > >>Jérémie Juste > >> > >> [[alternative HTML version deleted]] > >> > >>______________________________________________ > >>R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > >>https://stat.ethz.ch/mailman/listinfo/r-help > >>PLEASE do read the posting guide > >>http://www.R-project.org/posting-guide.html > >>and provide commented, minimal, self-contained, reproducible code. > > > >______________________________________________ > >R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > >https://stat.ethz.ch/mailman/listinfo/r-help > >PLEASE do read the posting guide > >http://www.R-project.org/posting-guide.html > >and provide commented, minimal, self-contained, reproducible code. > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/ > posting-guide.html > and provide commented, minimal, self-contained, reproducible code. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.