topic Re: Create date variable from week, month, year in SAS Enterprise Guide

Create date variable from week, month, year

claireluen — Fri, 13 Jun 2014 17:12:23 GMT

I have week, month, and year variables and need to create a date variable from these. Suggestions on how to do this?

Reeza — Fri, 13 Jun 2014 17:31:15 GMT

How does your week look, it is 25 indicating 25th week of the year or 2 indicating the 2nd week of a month?

Assuming its between 1 and 5

something like the following may work:

date=mdy(month, 7*(week-1)+1 , year);

claireluen — Fri, 13 Jun 2014 17:41:32 GMT

It is numbered 0 through 52, so 25 indicates the 25th week of the year.

ballardw — Fri, 13 Jun 2014 17:42:17 GMT

Would you like the date to reflect any specific day of the week?

claireluen — Fri, 13 Jun 2014 17:48:07 GMT

Thursdays preferably, but if it is too difficult that way it doesn't particularly matter that much.

Reeza — Fri, 13 Jun 2014 17:54:49 GMT

Weeks can cross months so having a specific day may not be possible

claireluen — Fri, 13 Jun 2014 18:38:15 GMT

Even just an approximate day would be ok.

e.g.

wk 1 = 1/1/14

wk 2 = 1/8/14

wk 3 = 1/15/14

etc.

Reeza — Fri, 13 Jun 2014 18:48:41 GMT

Aligns to the beginning of the week;

date=mdy(1,1,year)+(week-1)*7;

intnx('week', mdy(1,1, year), week, 'middle');

And look at the alignment options for intnx function, ie beginning end, middle.