Re: st: Problem declaring a panel dataset

[Milena Przheska <milena.przheska@cosmicdevelopment.com>]

Please disregard, I found the problem.

I apologize.


Best,
Milena


On Fri, Aug 30, 2013 at 1:18 PM, Milena Przheska
<milena.przheska@cosmicdevelopment.com> wrote:
> Dear Statalist members,
>
> I am getting the following error when declaring a panel dataset:
>
> "repeated time values within panel"
>
> I have checked for duplicate records using the following command:
>
> bys code when: gen dup = cond(_N==1,0,_n)
>
> I get this description of duplicates with -tab-
>
>        dup |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>           0 |    164,787       91.61       91.61
>           1 |      7,241        4.03       95.63
>           2 |      7,241        4.03       99.66
>           3 |        499        0.28       99.93
>           4 |         71        0.04       99.97
>           5 |         18        0.01       99.98
>           6 |         14        0.01       99.99
>           7 |          8        0.00      100.00
>           8 |          8        0.00      100.00
> ------------+-----------------------------------
>       Total |    179,887      100.00
>
>
> But when I listed duplicates, this is what I could see:
>
>
> list if dup>1
>
>  when                                code     dup
> 28apr2013 08:20:55               a          2
> 28apr2013 08:21:06               a          2
> 04may2013 10:44:43             a          2
> 04may2013 10:45:28             a          2
>
>
> The variable "when' is in %tc format, and I use the same format when
> declaring a panel dataset. Yet, Stata seems to only look at the date,
> not the hour, minute and seconds part of the variable.
>
> Can anyone please tell me what can I do to correct this situation?
>
> I appreciate your help and I thank you in advance.
>
>
> Best,
> Milena Przheska
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/