Statalist


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

Re: st: RE: Creating a table with list of variables, but showing all values even if value is not used


From   Anna Reimondos <areimondos@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Creating a table with list of variables, but showing all values even if value is not used
Date   Mon, 18 May 2009 15:38:15 +1000

Dear Garry,
I just installed the 'fre'  add-on and it worked perfectly!  The
includelabeled option was just what I was looking for.
Thanks you so much, this will really save me hours of copying and
pasting and editing.
Cheers
Anna

On Mon, May 18, 2009 at 3:29 PM, Garry Anderson
<g.anderson@unimelb.edu.au> wrote:
> Hi Anna,
>
> You could try the user written command -fre-
>
> -ssc install fre-
> The includelabeled, include(), and subpop() options may be relevant.
>
> Cheers, Garry
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Anna
> Reimondos
> Sent: Monday, 18 May 2009 3:03 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: Creating a table with list of variables, but showing all
> values even if value is not used
>
> Hello,
> I have a survey dataset with over 2,000 respondents and  I have created
> 30 variables. These 30 variables describe  a persons activity (e.g
> studying, employed) for each age between ages 15 to 44.
> For example if someone was studying between 15 -17 and then starting
> working full-time at age 18 the first 4 variables for this person would
> be:
>
> activity15      activity16      activity17   activity18
>
> Studying         Studying       Studying    Emp.FT
>
>
> In total there are 12 possible activity categories people can be in at
> each age, and the value label for each of the 30 variables is exactly
> the same.
>
> I would like to create a table with 30 columns and 12 rows, containing
> the number of people and percentages in each category (row) at each age
> (column). My current strategy is to tabulate each of the 30 variables
> separately and copy and paste the data into excel. (tab1 activity*).
> Obviously if at some age no person is engaged in one of the 12
> categories (e.g at 15 no one is employed full-time), this category is
> not listed in the tabulation and it makes it very time consuming to
> manually make sure the rows match in excel, when each of the tabs of the
> variables has a different number of categories. Is there an easy way to
> 'force' tab to show all the 12 categories but to have either a missing
> or a zero to indicate that no one was in that category.
>
> I hope I have made the question clear enough.
>
> Thanks very much
> Anna
> *
> *   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/
>
> *
> *   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/
>

*
*   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/



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