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]

st: RE: Analyzing time series data on prices by districts & markets


From   Nick Cox <n.j.cox@durham.ac.uk>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Analyzing time series data on prices by districts & markets
Date   Mon, 13 Jun 2011 14:27:55 +0100

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 

Partho Sarkar

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.

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