There is no direct command for generating the ISOweek (ISO8601) from a date in Stata.
The following single-line formula derives the ISOweek from any date post 1 Jan 1900.
Should you require ISOweeks from _before_ that date, substitute mdy(1,1,1753) for mdy(1,1,1900), and that will get you back to before the Industrial Revolution!
** derived from the EXCELLENT description of
** how to derive an ISOweek from a date
** described here: https://www.sqlservercentral.com/art...so-week-number
** based on a post here: http://stackoverflow.com/questions/7...ql-server-2005
** from "t-clausen.dk"
gen ISOweek =int((doy(7*int((datevariable-mdy(1,1,1900))/7)+ mdy(1,1,1900) + 3)+6)/7)
Related Posts with ISOweek from dates in Stata: Code below
Predict after xtlogitI am using xtlogit with fe options. I notice that the results drop some observations due to all posi…
Peer Firm Averages excluding ith observationHi All, I am pretty new to Stata , so a bit lost on this one. I am trying to find Peer Firm averages…
how to store margins after biprobit modelHi, I would like to estimate the predicted probabilities after running a biprobit model. I have trie…
Margins with interactions and factor notation in probit.I'm pretty sure this has a simple solution and thought I would take advantage of the expertise here.…
Logistic regression and year dummiesDear researchers, I have an unbalanced dataset for a period extending from 2002-2019. I am trying t…
Subscribe to:
Post Comments (Atom)
0 Response to ISOweek from dates in Stata: Code below
Post a Comment