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 at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: Time series - what to do before a product launch?; how to count n obs showing an attribute in each year?


From   Rodrigo Refoios Camejo <refoioscamejo@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Time series - what to do before a product launch?; how to count n obs showing an attribute in each year?
Date   Mon, 12 Apr 2010 18:42:04 +0100

I have 10 years of panel data on pricing and quantities sold of
pharmaceuticals. For each presentation (i.e. dosage and package) of
each product I have data on the prices and quantities sold in each
quarter. My idea is to fit a regression model with price as the
dependent variable and independent variables related to competition
like: # products in the therapeutic class at time of launch; #
generics in the therapeutic class at time t; market share of market
leader at time t; price of market leader at time t-1; etc.

How can I deal with the fact that some products were only launched
half-way the data timeframe and some were discontinued after launch,
i.e. when price==”0” & quantity==”0” for all t before t launch and for
some after t launch. How can I have STATA including in the regression
only the data for which price and quantity is available? Simply drop
if price==0? Will it not treat it as missing if I do so?

Another side question, how can I make STATA count the # products with
a particular characteristic (e.g. generic==1) marketed in each group
(subclass) of drugs in each quarter? And then assign to each product
the count corresponding to the quarter in which that product was
launched?

I hope I was clear enough…many thanks in advance!

All the best,
Rodrigo

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