Hi, I'm trying to concat two numeric variables whit the egen command, I know when it is used a string variable results, but, when I try to destring a "non-numeric characters" appears and the variable isn't replace. I need to do math operations with this variable so I can't leave it as a string. If you know the solution, I would be very grateful for your help.
e.g. I got two weight variables p1005peso_2 for an integer number and p1005peso_2 for a fraction of the weight
+----------+ +----------+
| p1005p~2 | | p100~o_1 |
|----------| |----------|
1. | 103 | 1. | 6 |
2. | 54 | 2. | 9 |
3. | 62 | 3. | 8 |
4. | 61 | 4. | 5 |
5. | 70 | 5. | 4 |
+----------+ +----------+
**egen peso_con = concat(p1005peso_2 p1005peso_1), punct(.)
. list peso_con in 1/5
+----------+ this is how I need the variable shown, but numeric
| peso_con |
|----------|
1. | 103.6 |
2. | 54.9 |
3. | 62.8 |
4. | 61.5 |
5. | 70.4 |
+----------+
in the missing values shows ". . ."
** destring peso_con, replace
peso_con: contains nonnumeric characters; no replace
Related Posts with egen for numeric variables
Question Stata (Seasonal effects in stock market)Hello Guys Im from Switzerland and have some difficulties using Stata. I hope there are some expert…
Renaming multiple string values of a variableHello all. I have an ICD10 code variable that has about 6000 different values in string format. I al…
KMatch: Memory Management in Nearest-Neighbor Matching with TiesHi Everyone! Currently running Stata 16. I'm trying to do nearest neighbor matching with Kmatch usi…
infix with files that do not have suffixesI am trying to read in 1000s of raw data files with the infix command. The files have a numeric name…
January effect regressionHello Guys I have a question related to regression. I have a Data in which in the columns there are…
Subscribe to:
Post Comments (Atom)
0 Response to egen for numeric variables
Post a Comment