Hi everyone,
For company data analysis for my thesis, I wanted to create industry dummy variables based on the company's SIC Code 2's. Yesterday I successfully managed to do that by writing this code (and similar ones with different industry names):
generate Ind_Manu=.
replace Ind_Manu=1 if inrange(Sic_code_2,2000,3999)
replace Ind_Manu=0 if Sic_code_2>3999
replace Ind_Manu=0 if Sic_code_2<2000
As a result I got a beautiful dummy variable that indicated a 1 if the company's SIC Code 2 was between 2000-3999, and a value of 0 if not.
Today I tried patching the missing SIC Code 2 values through an alternative database. I basically copied the SIC-Code from the database and inserted it into my dataset at the place of the missing value of my Sic_code_2 variable.
The value was still black, so I assumed it would still be recognized as a numerical value.
However, now I wanted to update the Dummy variable with the new Sic Code 2 data, by running the following line again:
replace Ind_Manu=1 if inrange(Sic_code_2,2000,3999)
Yesterday this line worked perfectly fine, but somehow now I get the error: "no variables defined"
I did not change the name of the variable, so I think it has something to do with the fact that I manually entered data into the Sic Code 2 variable.
Does anyone know how to resolve this issue?
Thanks in advance!
Ruben
Related Posts with Variable not recognized after modification
Using for loop to plot multiple graphs.Hey Everyone, I am trying to plot multiple graphs using a for loop. At the time, I am trying to mak…
drop in all rangeHi there, I have some difficulties dropping observations. If the ID did not receive subsidy in all…
Creating new variables on the basis of relationship to head, age and wages?Hi, I want to do two things in STATA but I do not know the commands to it. The data is of two rounds…
pooled mean group estimationHello. I get errors when I run below command and could not figure out what is the cause. It would be…
Stata only creates 4 out of 5 quintiles?I have a continuous variable in some panel data (xtset by id and year over 5 years) that I would lik…
Subscribe to:
Post Comments (Atom)
0 Response to Variable not recognized after modification
Post a Comment