I had a dataset which didn't contain month or year columns (I imported monthly spss file with no date column) and created a date column like this:
*created year and month values when I imported (in a loop) like this
gen year= 2020
gen month=`i'
*Created a monthdate column
gen monthdate = ym(year, month)
format monthdate %tm
I then wanted to drop the month of January but I keep getting an error (r(198)). Does this have to do with my data type?
*drop jan 2020
drop if monthdate == 2020m1
I also tried putting 2020m1 in quotations ("2020m1") but I got error r(109).
What am I missing?
Related Posts with How to drop date row from dataset
optimize_init_technique(S, "nr")Hi, I have a methodological question about how optimize works with the Newton-Raphson algorithm. A…
Getting started with STATAHey there, I need to write an essay for which I need Stata. To be honest I never had any experience…
generating change variables in panel-structureDear all, I would like check whether I can overwrite the missing deprivation variable (dep) with the…
Ali UbaidI am trying Heckman two-step analysis for remittances and agriculture investment based on survey dat…
ERM model for Endogenous treatment effect with nointeract optionI am trying estimate treatment effect models using ERM command in Stata 15. However, it has been sho…
Subscribe to:
Post Comments (Atom)
0 Response to How to drop date row from dataset
Post a Comment