I am trying to convert a non-numeric string ID variable to a numeric variable but I get an error message
"too many values". after I use: encode id, gen(copy_id)
My dataset has >75,000 and I understand this may be part of the problem. Please help because I cant do subsequent analysis if this ID variable is not converted to a numeric variable. I have more than 10 datasets to merge on this ID. I cant extract the data using dataex because I am working in a secure environment where I cant copy the data except as an image below.
Example ID's are shown below.
Array
Thanks.
Related Posts with Convert "string" ID to numeric with non-numeric characters
generate t-statHow can we modify this code to generate t-stat of the means instead of standard deviation (sd), and …
Post-estimation tests or heteroskedasticity check to confirm normality of the residuals?Hi Stata users, I'd like to ask for your help. I read STATA manual pdf on post-estimation for mixed…
what is the base for -collapse- percent statistic with by()?The -collapse- command (https://www.stata.com/manuals/dcollapse.pdf) has a -percent- statistic that …
spatial weight matrixHello, As part of my research, I want to build a spatial weight matrix. I want a variable that shows…
How to store p-value and CI in a new variable in prais-winsten regression?Hi! I'm new to Stata! I have a database model as shown below (hypothetical data). When running Prai…
Subscribe to:
Post Comments (Atom)
0 Response to Convert "string" ID to numeric with non-numeric characters
Post a Comment