Hi all,
I have created a categorical variable (values 1 through 5) in excel based on certain characteristics of US states in a 20 year time period.
I have a large data set with over 2 million rows and I am trying to assign the value of the categorical variable to each row in my data set based on the state and the year.
What I have tried so far is:
gen state_year = 1
replace state_year = 5 if (year==1962 & state==1)
And so on etc.
However, since there are a 1000 combinations of states and years (50*20), this is going to take a very long time to code in a do-file.
Is there a way to import my excel file so that it creates a variable and assigns the value of that variable depending on what is in the excel?
I have attached a screenshot of the first few rows of my excel document.
Array
Any help would be much appreciated. Thanks in advance!
Harry
Related Posts with Creating a new variable based on the value of other variables
Opening huge data files in STATADear Satalist I am having difficulty opening and working with several huge data files in Stata. The…
Calculating the Smallest Effect Size of Interest and rejecting the presence of a meaningful effectHello, I came across this quite interesting blog article on the topic of the smallest effect size o…
Linear Regression with Multiple Regressors with stataHello everyone, Are there anyone can help me to solve these questions? 1. Run a regression of Grow…
twoway area and unwanted outlineI use twoway area to draw chronograms, and like to suppress the outline of the area, using fill-colo…
The spatial lag command does not generate the variableHi all, I am using the HTML Code: spmon command to generate the spatial lag term. However, I am …
Subscribe to:
Post Comments (Atom)
0 Response to Creating a new variable based on the value of other variables
Post a Comment