Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

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


From   Partho Sarkar <[email protected]>
To   [email protected]
Subject   st: Analyzing time series data on prices by districts & markets
Date   Mon, 13 Jun 2011 18:21:53 +0530

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index