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

# Re: st: Regressing a specific number of observations containing values

 From Tirthankar Chakravarty To statalist@hsphsun2.harvard.edu Subject Re: st: Regressing a specific number of observations containing values Date Tue, 6 Sep 2011 07:06:57 -0700

```As Nick says, not directly. Depending on whether you would like to use
the same 250 every time, or a different 250 from among the
non-missing, you can exclude the lines relating to the variable
"randsort" in the code below:

****************************************
// generate some data
clear*
set obs 1000
foreach x of newlist x y z {
g `x' = cond(runiform()<.1, ., runiform())
}

// tag non-missing
g notmiss = !missing(x, y, z)

// random sort order
tempvar randsort
g `randsort' = runiform()
gsort -notmiss `randsort'

reg y x z in 1/250
****************************************

T
On Tue, Sep 6, 2011 at 5:35 AM, Robin Schmidt <r_schm28@uni-muenster.de> wrote:
> Dear all,
>
> I am working on a finance-related event study where in a first step I have to
> get coefficients (alpha and beta) from a linear regression of two variables.
> The regression has to comprise of 250 observations (in this case 250 stock
> returns of 250 trading days). The problem is that one of the variables is
> missing some observations while the other one is not. However I need exactly
> 250 observations containing values. Working with "range" is not satisfactory
> as it ignores whether a certain observation is missing a value or not. Is
> there a way of regressing an exact number of obsverations which contain a
> value (i.e. which are "nonmissing")?
>
> Best regards,
>
> Robin Schmidt
> *
> *   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/
>

--
Tirthankar Chakravarty
tchakravarty@ucsd.edu
tirthankar.chakravarty@gmail.com

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