Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Removing "." (in string format) from a variable-->new problem "code too long"
From
Michael Stewart <[email protected]>
To
[email protected]
Subject
Re: st: Removing "." (in string format) from a variable-->new problem "code too long"
Date
Wed, 28 Nov 2012 21:47:07 -0500
Thanks a lot Adam
Sincerely
Mike
On Wed, Nov 28, 2012 at 8:58 PM, Adam Olszewski
<[email protected]> wrote:
> This is because icd9p refers to "ICD-9-CM Volume 3 Procedure Codes"
> which are four-digits only. If you -icd9 check- you should not see a
> problem. You can look this up at http://www.icd9data.com/
> For example the string 4201 would be read as 420.1 (Acute and subacute
> bacterial endocarditis) by icd9 and as 42.01 (Incision Of Esophageal
> Web) by icd9p.
> So, like with everything, you need to know what you ask for.
> see:
>
> icd9 lookup 4210
> icd9p lookup 4210
>
> AO
>
> On Wed, Nov 28, 2012 at 8:17 PM, Michael Stewart
> <[email protected]> wrote:
>> Hi Adam ,
>> I was successfully able to remove the "." but I ran into another
>> problem. I am still getting the error "variable contains invalid
>> codes " . I ran the icd9p check variable, gen(prob) .I got table
>> which showed that the " Code too long " . But when I check the
>> individual codes by icd9 lookup , I am getting a valid description.
>> I am really puzzled by this.Do you have any thoughts/ suggestions
>> thanks
>> Mike
>>
>>
>>
>> On Wed, Nov 28, 2012 at 7:35 PM, Adam Olszewski
>> <[email protected]> wrote:
>>> replace yourvariable="" if yourvariable=="."
>>>
>>> On Wed, Nov 28, 2012 at 7:16 PM, Michael Stewart
>>> <[email protected]> wrote:
>>>> hello ,
>>>>
>>>> i am working with ICD9 codes and i had to convert the icd-9 codes to
>>>> string format
>>>> Unfortunately , I got some values like following with only dots (as
>>>> shown below).
>>>> |--------------|
>>>> | 996.51 |
>>>> | . |
>>>> | . |
>>>> | . |
>>>> | 327.23 |
>>>> |---------- |
>>>> | . |
>>>> | . |
>>>> | . |
>>>> | . |
>>>> | . |
>>>> |-------------|
>>>> | 555.9 |
>>>> +----------+
>>>>
>>>> As I try to use the icd9 check commnd, I get that the variable has
>>>> invalid icd9 values and following output
>>>>
>>>> . | . Invalid placement of period |
>>>> . | . Invalid placement of period |
>>>> | . Invalid placement of period |
>>>> | . Invalid placement of period |
>>>> | . Invalid placement of period |
>>>> |----------------------------------------|
>>>>
>>>> Is there any way to just remove "." (in string format) from the variable.
>>>>
>>>>
>>>> --
>>>> Thank you ,
>>>> Yours Sincerely,
>>>> Mike.
>>>> *
>>>> * For searches and help try:
>>>> * http://www.stata.com/help.cgi?search
>>>> * http://www.stata.com/support/faqs/resources/statalist-faq/
>>>> * http://www.ats.ucla.edu/stat/stata/
>>> *
>>> * For searches and help try:
>>> * http://www.stata.com/help.cgi?search
>>> * http://www.stata.com/support/faqs/resources/statalist-faq/
>>> * http://www.ats.ucla.edu/stat/stata/
>>
>>
>>
>> --
>> Thank you ,
>> Yours Sincerely,
>> Mike.
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/faqs/resources/statalist-faq/
>> * http://www.ats.ucla.edu/stat/stata/
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
--
Thank you ,
Yours Sincerely,
Mike.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/