Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
The list's guidelines preclude attachments but certainly do not preclude ASCII text within a posting showing part of your data. Nick n.j.cox@durham.ac.uk In reply to my question: On Mon, Jun 13, 2011 at 6:21 PM, Partho Sarkar <partho.ss@gmail.com> wrote: > Hello all, > > I am quite new to Stata (and this list), and trying hard to quickly > pick up the skills while on the job. Would really appreciate some > help with this task, and please excuse if this seems too elementary! > > Problem: > > I have a large dataset which gives prices of a commodity at each date > for different markets across the country. The markets are classified > by State, District & Market (names). (The commodity is only traded in > some markets, in some districts, and some states). I need to get an > idea of the periods/dates for which the data are ?sparse?, i.e., there > are too few of the Markets reporting a price. > > So I need, > > 1. For each date, the total number of markets (over all states and > districts) for which a price is reported, and > 2. The maximum number of markets for which a price is reported for any > date in the dataset > > In addition, to do a geographical analysis, I would like to record, > for each date > > 1. The number of reporting markets in each district versus the total > no. of markets in that district, > 2. The number of districts in each state for which prices are > reported, versus the total no. of districts in that state > 3. Similarly, the number of states for which prices are reported, > versus the total no. of state s where a price is ever reported > > I hope this is clear, as I think the List rules prevent me from > including a preview/sample of my data. > > Thank you > > P. Sarkar > Consultant Econometrician > India > * * 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/