Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

Re: st: Data Manipulation


From   Nick Cox <njcoxstata@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data Manipulation
Date   Thu, 7 Apr 2011 09:29:01 +0100

It is not clear to me what you mean by "a data", which I don't think
is widely accepted as a standard form of words. I can't imagine it
being printed in the Stata Journal, for example.

If you want to create different datasets from this master dataset, my
guess is that would make most analyses much more difficult, especially
one dataset for each person.

Some analyses would be easier with a long data structure in which each
sex act was a separate observation. That's a -reshape long-.

(I set aside the question of whether this is real data or the research
ethical!)

Nick

On Thu, Apr 7, 2011 at 6:55 AM, Rajaram Subramanian Potty
<rajara999@gmail.com> wrote:
>
> I have one data, each selected persons were followed each day and
> enquired about their sex act in each day. For each sex act details
> were collected. For example, if the respondent reported 3 acts were
> reported, information on all the three sex acts were collected. Now
> the data available is for each date. From this data, I wanted to
> create a data for each person and also another data for each sex act.
> these data set should also include all the variables as well.
> Following is an example of the data with few variables for the first 3
> sex acts.
>
> The variable ending with _01, _02, and _03 indicates the 3 sex act in
> the same day.
>
> id      act_dd  act_mm  act_yy  doi_dd  doi_mm  doi_yy  tot_act rep_01  rep_02  rep_03  q1_01   q1_02   q1_03
> 20020001        7       2       2011    8       2       2011    3       X       X       X       4       4       3
> 20020001        8       2       2011    9       2       2011    1       X                       4
> 20020001        9       2       2011    10      2       2011    2       X       X               3       3
> 20020001        10      2       2011    11      2       2011    1       X                       1
> 20020001        11      2       2011    12      2       2011    0
> 20020001        12      2       2011    13      2       2011    2       X       X               4       1
> 20020001        13      2       2011    14      2       2011    1       X                       4
> 20020001        14      2       2011    16      2       2011    2       X       X               4       4
> 20020001        15      2       2011    16      2       2011    2       A       A               2       2
> 20020001        16      2       2011    17      2       2011    1       X                       3
> 20020002        12      2       2011    13      2       2011    0
> 20020002        13      2       2011    14      2       2011    5       A       A       X       1       1       4
> 20020002        14      2       2011    15      2       2011    2       A       A               1       1
> 20020002        15      2       2011    16      2       2011    2       A       A               4       4
> 20020002        16      2       2011    17      2       2011    4       X       A       A       1       4       4
> 20020002        17      2       2011    18      2       2011    2       X       X               3       3
> 20020003        8       2       2011    9       2       2011    0
> 20020003        9       2       2011    10      2       2011    0
> 20020003        10      2       2011    11      2       2011    4       A       A       X       4       4       4
> 20020003        11      2       2011    12      2       2011    3       X       X       X       3       3       4
> 20020003        12      2       2011    13      2       2011    0
> 20020003        13      2       2011    14      2       2011    2       X       X               3       3
> 20020003        14      2       2011    15      2       2011    3       X       X       X       4       3       1
> 20020003        15      2       2011    16      2       2011    3       A       A       X       3       3       3
> 20020004        1       3       2011    2       3       2011    0
> 20020004        11      2       2011    12      2       2011    1       X                       4
> 20020004        12      2       2011    15      2       2011    0
> 20020004        13      2       2011    15      2       2011    2       X       X               3       4
> 20020004        14      2       2011    15      2       2011    1       X                       3
> 20020004        15      2       2011    18      2       2011    0

*
*   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   |   Site index