Hi! When you created the high_score variable, there are cases marked as 1, however, they have a missing value in the original variable, therefore they should be considered as missing not 1 (high score). How do you manage those cases? Would adding !=missing at the end of the command sentence work?
Great catch! Thank you so much for pointing this out, Daniela! There are two ways to fix this. One is after you have already created the high_score variable this way, you can simply replace the "1"s that should be missing. Note that in stata, missing is represented as a period (.). So, you could simply add the line of code: replace high_score = . if missing(score) And that should replace those extra 1's to missing. On the other hand, another way to do it is to prevent those 1's in the first place by instead setting the original command as gen high_score = 1 if score >=1000 & !missing(score) replace high_score = 0 if score < 1000 And finally, you can do both steps above in a single line of code if you wanted, using the following shortcut: gen high_score = score >=1000 if !missing(score) Hope this helps!!
THANK YOU! GREAT VIDEO!
You're welcome! Thanks for the kind words :)
Hi! When you created the high_score variable, there are cases marked as 1, however, they have a missing value in the original variable, therefore they should be considered as missing not 1 (high score). How do you manage those cases? Would adding !=missing at the end of the command sentence work?
Great catch! Thank you so much for pointing this out, Daniela! There are two ways to fix this. One is after you have already created the high_score variable this way, you can simply replace the "1"s that should be missing. Note that in stata, missing is represented as a period (.). So, you could simply add the line of code:
replace high_score = . if missing(score)
And that should replace those extra 1's to missing. On the other hand, another way to do it is to prevent those 1's in the first place by instead setting the original command as
gen high_score = 1 if score >=1000 & !missing(score)
replace high_score = 0 if score < 1000
And finally, you can do both steps above in a single line of code if you wanted, using the following shortcut:
gen high_score = score >=1000 if !missing(score)
Hope this helps!!
Hi, Could you pls help me learning bayer & hanck cointegration in stata or eviews. thanx
how to get 23rd percentile?
I suggest to remove your serial number from the screen... :D