I want to identify which observations in my variable has non-numeric characteristics and what is these non-numeric characteristic before I use destring and its options.
The destring command will only work if the string variable we are trying to convert to numeric contains no non-numeric characters. For example, if we have a variable coded as “0” or “1”, but in a given observation, it was coded by mistake as “1b”, the destring command will not work. When dealing with small databases, it might be easy to visually identify which observation was wrongly coded. However, this process might be difficult if we have a large database containing many observations.
Is there any Stata command that searches for non-numeric characters within a string variable and lists the observations that have this issue?
Related Posts with How to find nonnumeric characters within a string variable and lists the observations that have this issue
Fuzzy match via -matchit- and -reclink-Hi Statalisters, I have a project that requires me to use fuzzy match to identify firm names in dif…
categorical timeID in tobit regression and LR test to decide between tobit and xttobitDear Statalist members. For my thesis, I am running a tobit regression with the DV being the owners…
Graph BarHello Sir, i have a query in bar graphs on STATA.. when i ran the following command i get my figure…
Calculating conditional probabilities in Stata with continuous dataHello statalist, I am involved in a project looking at net use in preventing malaria. I have a data…
Poisson autoregressive in STATAHi All, How I can fit Poisson autoregressive model in STATA? Any help, please Thanks …
Subscribe to:
Post Comments (Atom)
0 Response to How to find nonnumeric characters within a string variable and lists the observations that have this issue
Post a Comment