Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: RE: Re: no observations

From   "Nick Cox" <>
To   <>
Subject   st: RE: RE: Re: no observations
Date   Tue, 18 May 2004 23:38:42 +0100

Strictly, the -real()- referred to here is a function, 
not a command. More importantly, -real()- here is 
a brute force solution and could result in loss of information. 
As mentioned elsewhere, the better route is to use -destring-. 


Mihalka, Michael
> This problem often arrises when there are empty cells 
> produced by excel. As indicated by others, the variable is 
> interepreted as string. You can simply convert the variable 
> into numeric by using the real command.
> Alternatively, you can replace the empty cell as a period (.) 
> which is interpreted as a missing value by stata.
> BTW, why not simply save the excel file as a tab-delimited ASCII file.
> 	At 16:02 18/05/04 -0400, cheryl wrote:

> 	>  . reg overallscore endowment
> 	>  no observations
> 	>  r(2000);
> 	>
> 	>If 50 obs are pasted in, how come there are no observations?

*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index