to be exact:
replace v25=. if v25>.
(with one '=' sign)
Unless of course the extended missing values are required. then one
needs to look into the exact values and assign the extended codes,
where SAS has missed it.
Also try to export your dataset from SAS in double precision to see if
this helps.
Sergiy
On 1/9/08, Nick Cox <[email protected]> wrote:
> If this is correct, then
>
> . replace v25 == . if v25 > .
>
> is a way to fix your data.
>
> Nick
> [email protected]
>
> Sergiy Radyakin
> ===============
>
> Hello Nils,
>
> it could be that the missing values are not exactly Stata's missing
> codes (say they fall _between_ (.) and (.a). They are considered
> missing, but not equal to (.). I guess a formal name for these is .a_
>
> Try:
>
> format v25 %21x
> format v25 %16L // (Windows)
>
> to see what are the exact values stored in the variable and whether
> they correspond to Stata's expectations.
>
> Best regards,
> Sergiy Radyakin
>
>
> On 1/9/08, Drews Nils <[email protected]> wrote:
> > Dear all,
> >
> > I have trouble with missing values with a variable which was created
> with SAS. For some reason the missing values do not seem to be the
> system missing value, but I cant figure what the value actually is, see
> log below. Has anyone an idea what I am overlooking? Why do I get "no
> observations" when I type "tab v25 if v25 == ., mis"?
> >
> > Thanks,
> >
> >
> > Nils
> >
> >
> >
> > . use v25
> >
> > . li in 1013926/1013930
> >
> > +----------+
> > | v25 |
> > |----------|
> > 1013926. | .3333333 |
> > 1013927. | .8009968 |
> > 1013928. | . |
> > 1013929. | .6666665 |
> > 1013930. | .786561 |
> > +----------+
> >
> > . tab v25 if v25 == ., mis
> > no observations
> >
> > . tab v25 if v25 >= ., mis
> >
> > frauenant. | Freq. Percent Cum.
> > ------------+-----------------------------------
> > . | 310,286 100.00 100.00
> > ------------+-----------------------------------
> > Total | 310,286 100.00
> >
> > . d v25
> >
> > storage display value
> > variable name type format label variable label
> >
> ------------------------------------------------------------------------
> -------
> > v25 float %9.0g frauenant.
>
> *
> * 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/
>
*
* 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/
