topic Converting week and year variables to MM/DD/YYYY in SAS Enterprise Guide

Converting week and year variables to MM/DD/YYYY

claireluen — Tue, 16 Jul 2013 14:06:50 GMT

I have variables in my data set for both the week number and year number. I am looking for a way to convert them to a date column (MM/DD/YYYY or similar format). I know how to convert from a date to week/year, but not vice versa. Does anyone have any ideas?

Re: Converting week and year variables to MM/DD/YYYY

Reeza — Tue, 16 Jul 2013 14:41:19 GMT

WeekW. informat

Here's one way, but probably not the neatest:

(EDIT: I've assumed the day to be 1, the first of the week, but you could change that by changing the 01 and the end of week_year)

data have;

input year week ;

cards;

2001 23

2001 24

2003 45

2014 5

2005 36

2006 45

2007 3

;

run;

data want;

set have;

week_year=compress(year||"W"||put(week, z2.)||"01");

date_want=input(week_year, weekw9.);

format date_want date9.;

run;

Re: Converting week and year variables to MM/DD/YYYY

DBailey — Tue, 16 Jul 2013 14:45:22 GMT

You might be able to use date math to get to the first day of the week

FirstOfWeek = mdy(1,1,yearnum) + (7 * ( weeknum - 1));

intnx('week',mdy(1,1,yearnum),weeknum-1);

Re: Converting week and year variables to MM/DD/YYYY

claireluen — Tue, 16 Jul 2013 14:58:30 GMT

That was really helpful. Thanks to both of you!