I'm pretty new to Stata and have a basic idea on programming (only a bit of python). I know how to do what I need in Excel but the data I'm dealing with now is more than 30'000'000 observations so cannot export to excel.
my observation looks like this (let's call the var: letters):
a
a
c
b
c
and I have another table with two columns that shows (this table is now in excel - my first problem is how to use it in stata) :
a=5
b=3
c=10
I want to make a new variable (let's call this var: numbers) that at the end of operation will look like that:
5
5
10
3
10
Please help me!
Thank you very much!
my observation looks like this (let's call the var: letters):
a
a
c
b
c
and I have another table with two columns that shows (this table is now in excel - my first problem is how to use it in stata) :
a=5
b=3
c=10
I want to make a new variable (let's call this var: numbers) that at the end of operation will look like that:
5
5
10
3
10
Please help me!
Thank you very much!
