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
Generate a variable containing the values of other variablesHi, I know this may seem simple but I just can't figure it out. I have 3 variables: Time, serial, c…
tabm varlist output takes the variable labelsHi, When I execute Code: tabm variables , the outputs take the variable labels instead of variab…
A 2-stage crossover design with repeated measurements : threeway-interaction?Dear STATA list user, I am currently working with a 2-stage crossover design testing a new innovatio…
Drop Specific DataI am working with CRSP/WRDS data. I have company names in one column, dates/months (1990-2010) in ot…
Linear mixed effects with unbalanced, survey-weighted, longitudinal dataHello, I have panel household survey data that is a longitudinal study of individuals, so an unbalan…
Subscribe to:
Post Comments (Atom)
0 Response to ISOweek from dates in Stata: Code below
Post a Comment