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
How to Append .txt fileHi, how can I append a dataset with another using files that are in .txt format? I tried to use the …
gsem mlogit: set base categoryHi, I've estimated a latent profile analysis in Stata 17.0 with three continuous dependent variables…
Stata graph twoway scatter ignores variable formatHi, I am trying to create a graph of means and confidence intervalls for 6 different variables (fee…
Panel vs Pooled cross sectionHi all, I want to ask for your advice. I will research the difference in wages of minority and majo…
Second-order factor analysisDear StataListers, I am working on a project on which I am trying to estimate a factor analysis usi…
Subscribe to:
Post Comments (Atom)
0 Response to How to drop date row from dataset
Post a Comment