st: hourly panel data

[Amber Pearson <amberp37@hotmail.com>]

Hello,
I am trying to tell stata that my data are a panel time series. I have the following variables: id (1-120), year (2005-2007), day (1-365), hour (11-15), and value (0-67.5)

The datset looks like this:

id               year                 day                  hour                     value
1                2005                 2                     11                        23.4         
1                2005                 25                   12                        14.5
1                2006                 300                 13                          6.2
2                2005                 151                 11                         44.0
2                2007                 6                    15                         13.6
3                2006                 45                  12                          11.3


I want to be able to tell how many hours are missing for each day by monitor. I also want to be able to tell how many days are missing by monitor.

Any help would be much appreciated!

Thanks,
Amber
 		 	   		  
*
*   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/