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 <jdnewmil at
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 <
> jdnewmil at 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"
> ><jeremiejuste at 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 at 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
<
> >>> devazresearch at 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 at 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 at 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 at 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 at 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 at 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.