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
The e(sample) function evaluates to 0 when it is not defined (and not to missing as I expected). Where is this documented?Good afternoon, To my surprise I learn to today that the e(sample) function when undefined evaluate…
Multinomial logit model with random effectsDear all, I am working on the data of traffic violations recorded in one year. as shown in the tabl…
Coefplot merging coefficients of multiple regressions by categoryI am running two regressions with the same independent variable but different dependent variable twi…
-xtivreg with interaction termDear, I am deploying a 2SLS-regression model, including an interaction term of which one of the var…
Bootstrapped confidence intervalsHello, I have to use bootstrapping to add 90% confidence intervals to a ratio. How could I do that? …
Subscribe to:
Post Comments (Atom)
0 Response to ISOweek from dates in Stata: Code below
Post a Comment