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]

From |
Adam Olszewski <adam.olszewski@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Removing "." (in string format) from a variable-->new problem "code too long" |

Date |
Wed, 28 Nov 2012 20:58:14 -0500 |

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 <michaelstewartresearch@gmail.com> 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 > <adam.olszewski@gmail.com> wrote: >> replace yourvariable="" if yourvariable=="." >> >> On Wed, Nov 28, 2012 at 7:16 PM, Michael Stewart >> <michaelstewartresearch@gmail.com> 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/

**Follow-Ups**:**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"***From:*Michael Stewart <michaelstewartresearch@gmail.com>

**References**:**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"***From:*Michael Stewart <michaelstewartresearch@gmail.com>

- Prev by Date:
**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"** - Next by Date:
**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"** - Previous by thread:
**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"** - Next by thread:
**Re: st: Removing "." (in string format) from a variable-->new problem "code too long"** - Index(es):