Day of the week variable

matt23 — Fri, 03 Aug 2018 15:02:02 GMT

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.?

Re: Day of the week variable

PeterClemmensen — Fri, 03 Aug 2018 15:12:03 GMT

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.

topic Re: Day of the week variable in SAS Enterprise Guide

Day of the week variable

Re: Day of the week variable