How do I convert string variables to numeric variables in Stata?

Question

I have two variables in Stata, both numeric variables that have somehow been recorded as string variables. I need them converted to numeric variables so that I can generate a new variable with them.

When I tried, it said type mismatch I have tried the real and the encode commands, none of which are working.

It always help to show exactly what code you tried. Note that real() is a function in Stata, not a command. — Nick Cox
– Nick Cox, Commented Jul 26, 2013 at 18:48

Nick Cox · Accepted Answer · 2013-07-26 18:49:27Z

7

Try destring var, replace in Stata if you want to convert var into numeric

Or,

encode var, generate(var1)

edited Jul 26, 2013 at 18:49

Nick Cox

37.4k6 gold badges37 silver badges51 bronze badges

answered Jul 26, 2013 at 12:30

Metrics

15.5k7 gold badges56 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Exodia16 Over a year ago

Thank you so much, i realised it was string because there were some 'NA' in the dataset, i deleted them and it was fine. !

Nick Cox · Accepted Answer · 2022-07-15 05:53:01Z

0

destring varname, replace ignore(xyz)

xyz is any non-numeric character in the value of the variable

edited Jul 15, 2022 at 5:53

Nick Cox

37.4k6 gold badges37 silver badges51 bronze badges

answered Jul 15, 2022 at 0:05

user19552830

1

Collectives™ on Stack Overflow

How do I convert string variables to numeric variables in Stata?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related