I have a dataset for transportation research. I have imported the data into STATA 17. The dataset contains a variable called age (is of string str5) has five categories <18, 18-29, 30-45, 46-60 and >60. The problem is that it is in string, but I need to convert it so that I can use it for regression. I looked into STATA forum and the majority of posts recommended to use encode( ) to make it numeric. After converting it to numeric what I observed that the label encoding (value labels) shuffled say for 18-29: 1, 30-45: 2, 46-60: 3; <18: 4, >60: 5.
Can anyone help me with the code (reproducible for any string variable) that will convert the variable to numeric (so that can be used for regression task) and relabel it (<18: 0, 18-29: 1, 30-45: 2, 46-60: 3 and >60: 4).
Goal: The goal is to convert it to numeric and change the existing value labels to desired custom value labels.
Thanks in advance.
Related Posts with How to convert a string variable to numeric and customize the label encoding?
Correlated data and structural equation modellingI am trying to examine a cross-lagged model with twin data. Without taking into account the correlat…
OLS Regression and Fixed Effects ModelHi everyone, I was just wondering if anyone could explain the difference between using an OLS regre…
How to conclude significance of moderation effects?I want to explore moderating effects of m1. I also have another moderator m2, and here are the two c…
Negative binomial regression: Coefficient gets insignificant when control variable is loggedHi, please note that this question was cross-posted on StackExchange but didn't receive any feedbac…
Doubt about absorb() in reghdfeHi everyone! I am currently working with a rather big dataset (135mm observations) and I need to ru…
Subscribe to:
Post Comments (Atom)
0 Response to How to convert a string variable to numeric and customize the label encoding?
Post a Comment