Sir, I have a dataset in stata which has a string variable having names i want to list only those names which starts or contains a particular characters. Please help me out with the command My question in brief sir .. for example I have a dataset with two variables one string variable and another numeric variable i.e., name and age, if i want to list people who are under age of 10 , the command is like list if age < 10 simply stata list out the data, but i want to list out the only people who's names are starting with "S" or a part of name with "ra".. Usually in mysql we write this command select * from xxxx where name like "S%" or name like "%ran%" Which is very simple... but i couldn't get it stata.. Please help me out.. Thank You Sir
Sir, I have a dataset in stata which has a string variable having names i want to list only those names which starts or contains a particular characters. Please help me out with the command
My question in brief sir .. for example I have a dataset with two variables one string variable and another numeric variable i.e., name and age, if i want to list people who are under age of 10 , the command is like list if age < 10 simply stata list out the data, but i want to list out the only people who's names are starting with "S" or a part of name with "ra"..
Usually in mysql we write this command
select * from xxxx where name like "S%" or name like "%ran%"
Which is very simple... but i couldn't get it stata.. Please help me out.. Thank You Sir
Sofa