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
<[email protected]> 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: [email protected]
> [mailto:[email protected]] On Behalf Of Anna
> Reimondos
> Sent: Monday, 18 May 2009 3:03 PM
> To: [email protected]
> 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/
