Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: destring command


From   Nick Cox <njcoxstata@gmail.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: destring command
Date   Sat, 24 Sep 2011 11:43:11 +0100

Try

. tab v13 if missing(real(v13))

to get an idea of what else there is. In extremis,

. ssc inst charlist
. charlist v13

Nick

On 24 Sep 2011, at 11:27, Abu Camara <abucamara@gmail.com> wrote:

Nick,

Many thanks.
I applied your suggestion but this is the error I keep getting.

. destring v13, gen(yr1983) ignore(, n/a )
v13 contains characters not specified in ignore(); no generate
Abu.

On 24 September 2011 12:20, Nick Cox <njcoxstata@gmail.com> wrote:
The problem is not in using -ignore()-. You are asking -destring- to
ignore a character you want. So, don't do that.

From your evidence, you need -ignore(, n/a)-

Nick

On Sat, Sep 24, 2011 at 10:08 AM, Abu Camara <abucamara@gmail.com> wrote:
Nick,

Without the ignore option destring won't work for these string variables.
It has worked for me in cases where (--) does not exist.
Abu.

v13
n/a
n/a
n/a
n/a
n/a
2,605.11
-1.388
-3.301
n/a
n/a


On 24 September 2011 12:02, Nick Cox <njcoxstata@gmail.com> wrote:
Your problem is self-inflicted. As you are instructing -destring- to
ignore "-", all negative signs are stripped.

Nick

On Sat, Sep 24, 2011 at 9:30 AM, Abu Camara <abucamara@gmail.com> wrote:

I am trying the following command to destring variables in the
IMF weo data just released. I imported it to Stata but all variables
become string.
When I use Stata's destring command, values that are negative becomes
positive,i.e  lose the negative sign.
Any help would be appreciated. A loop to do this task at once will
also be appreciated.

Command: destring v13, gen(yr1983) ignore(, n/a -- )


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


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