[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Week data, daily data, and end-of-year

From   "Sauermann J (ROA)" <>
To   "''" <>
Subject   st: Week data, daily data, and end-of-year
Date   Wed, 2 Dec 2009 13:39:11 +0100

Dear Statalist, 

I have a dataset containing week information. The variable --week-- is generated from a year variable (2008, 2009) and a week variable (1,...,52). Weeks are defined as calendar weeks, i.e. always ranging from Monday until Sunday. The week "1" of a year are thus a whole week (Mon-Sun) where at least 4 days are in the new year (i.e. for the past two years, week "1" overlaps new year's eve).

Stata defines week "1" as the first 7 days in the new year, i.e. January 1-January 7, irrespective of the weekdays. December 31, 2008 (Wednesday) was for instance week "2547" while January 1, 2009 (Thursday) was week "2548". 

Next to the weekly data, I have an additional dataset which is based on daily data. To use it properly, I transformed it using Stata to weekly data. This obviously gives wrong results since the week break in Stata may be in the middle of the week, while the week break in my weekly data is Sunday/Monday. 

Is there any way to tell Stata to use a date format where week "1" of a year is the first week with at least 4 days in the new year?

[I guess one solution would be to manually generate own week counters which can be matched properly]

Many thanks in advance,


Jan Sauermann

Research Centre for Education and the Labour Market
Maastricht University | ROA
P.O. Box 616, NL-6200 MD Maastricht
T +31 43 3883801 F +31 43 3884914

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index