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-.
Nick
[email protected]
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:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/