Dear Colleagues,
I have been trying to extract the first three characters of an ICD variable. I tried using the following command:
substr(icd_code,1,3)
I get an error saying that "unrecognized command: substr". This is despite of the fact that substr turns into blue in the do file confirming that software has recognized it as a command.
I would highly appreciate your helps and answers.
Best,
Mehdi
You need to combine the string function (-substr-) with other commands to "extract" the data. You could, for instance, display a frequency table:
tab icd_code if substr(icd_code,1,3)
... or generate a new variable:
gen icd_new = substr(icd_code,1,3)
Amir
hi both: thanks for the above. I find similar problem but starting from a numeric variable when using the string() function to make it string I already get the "unrecognized command" message. So when testing Amir's solution .
gen sic0b=substr(sic0,1,.)
I get a "type mismatch"
I need to differentiate between 6 and 06 for example in a numeric vble.
Best and thanks
Pablo
This means that the variable sic0 is numeric. substr works for string variables. In any numeric variable 6==06 and so 06==6. Assuming sic0 is a one digit numeric variable, you ought to use
gen sic0b =substr("0"+string(sic0),1,.)
This works
Kind regards
Wow this is great and very helpful to me as I am new in using Stata, what could be the expression if I wanted the last 2 characters of my variable.
Kind Regards,
Mbusi
Hi Mbusi Ngema , there are a number of options here https://www.statalist.org/forums/forum/general-stata-discussion/general/112429-extracting-last-three-digits-from-a-string-regex
I am facing a really odd problem. I want to extract the 6th and 7th characters as 'state code' from my string variable of total 8 characters (e.g. 0029334F). I am using the code:
gen Scode = substr( FACTORY_Id,6,7)
However, this code is giving me the last three digits. So, I tried an alternative code to investigate the problem:
gen Scode = substr( FACTORY_Id,6,6)
This is also returning the last three characters. Does anyone know why this is happening?
Hi Sheetal ,
to get the 6th and 7th character you have to do the following, after generating the Scode
replace Scode = substr(Scode,1, length(Scode)-1)
HI,
Thank you for your helpful comments.
Could you please advise me on how to combine two variables with letters and numbers in each (both are icd-10 codes) in a way that I can extract some special codes such as "S0" from the newly made variable?
I do thank you in advance.
Hi All!,
Thanks for all the above answers. But I am unable to understand the explanation which is given above. I am also facing a problem with nsso data. kindly help me to solve this issue. my problem is that I need to merge four files such as household, demographic, principal status, and subsidiary status into one where two files are having the same number of digits in the key variable (eg:20000110102) and the other two files having the same digits in the key variable (eg:1120000110102). I want to exclude the first two digits (i.e.11) from 1120000110102 to have same values in all four files. how I can do it.
Thanking you in advance.
Gegam Shagbazian
: Your code only works when the variable has the same number of characters.Say I want to extract: the last 2 characters of the following values: 1. hyundai (extract: ai) and 2 Mazda (extract: da). Could anyone advise on how to proceed with this, please?
hello there.... how can one deal with the missing values in the data.? for instance I have a variable called lev with some missing values written as n.a.
how can I deal with this? please help.
- Badges
- Science topic
- Similar topics
- Filing