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

RE: st: RE: still having problems with converting string variables


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: RE: still having problems with converting string variables
Date   Sun, 17 Oct 2004 18:22:40 +0100

There's no dilemma here. The solution is not to -destring- 
but just using correct syntax. As -dxcode1- is string, 
you must bind string values within " ". 

tab dxcode1 if dxcode1 == "4010-"

By the way, such a command would do nothing 
useful except count values. 

count if dxcode1 == "4010-"

is more direct for that purpose. 

Nick 
n.j.cox@durham.ac.uk 

Suzy
> 
> I need the frequency of some of the categories under the string 
> variables. For example, for a numeric variable such as sex, I get the 
> frequency easily....
> . tab sex
> 
>        sex |      Freq.     Percent        Cum.
> ------------+-----------------------------------
>          1 |    133,769       40.88       40.88
>          2 |    193,485       59.12      100.00
> ------------+-----------------------------------
>      Total |    327,254      100.00
> 
> For the string variables such as dxcode1, I cannot obtain the 
> frequency 
> for either code:
> 
> tab dxcode1 if dxcode1==4010-
> invalid syntax
> r(198);
> 
> . tab dxcode1 if dxcode1==40200
> type mismatch
> r(109);
> 
> Thus, I felt that I needed to destring the variable dxcode1.  But 
> because some observations are coded with dashes, it seems 
> that the only 
> way to get it to work is to use the ignore and force option, but then 
> I'd lose the dashed observations since  STATA would treat them as 
> missing. So that has been my dilemma.

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



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