## Day of the week variable

Solved
Frequent Contributor
Posts: 89

# Day of the week variable

Let's say I have this kind of data:

 Year Month Day Hour 2009 1 12 23 2009 1 13 22 2009 2 16 13 2010 3 4 11

Is there a way I can make a new variable called Weekday where 1=Monday 2=Tuesday etc.?

Accepted Solutions
Solution
3 weeks ago
PROC Star
Posts: 1,410

## Re: Day of the week variable

[ Edited ]
``````data have;
input Year	Month	Day	Hour;
datalines;
2009	1	12	23
2009	1	13	22
2009	2	16	13
2010	3	4	11
;

data want;
set have;
date=mdy(Month, Day, Year);
WeekDay=weekday(date)-1;
format date date9.;
run;``````

EDIT: Subtracted 1 when using the Weekday Function. Weekday function assumes sunday=1.

All Replies
Solution
3 weeks ago
PROC Star
Posts: 1,410

## Re: Day of the week variable

[ Edited ]
``````data have;
input Year	Month	Day	Hour;
datalines;
2009	1	12	23
2009	1	13	22
2009	2	16	13
2010	3	4	11
;

data want;
set have;
date=mdy(Month, Day, Year);
WeekDay=weekday(date)-1;
format date date9.;
run;``````

EDIT: Subtracted 1 when using the Weekday Function. Weekday function assumes sunday=1.

☑ This topic is solved.