How to extract day of the week from a date column

Reply
Frequent Contributor
Posts: 134

How to extract day of the week from a date column

Hi,

I have a column with dates, I want to filter records for Friday only... e.g. I want to filter March 1, 2013... Feb 22, 2013... Feb 15 2013... and so on

how can I do it?

Thanks in advance

Super User
Posts: 19,780

Re: How to extract day of the week from a date column

Use the weekday function.

where weekday(date)=6;

Frequent Contributor
Posts: 81

Re: How to extract day of the week from a date column

Hi,

Please find below the code and its output:-

=====================================

data new;

informat mydate mmddyy10.;

input mydate ;

format mydate mmddyy10.;

datalines;

03/01/2013

03/02/2013

03/03/2013

03/04/2013

03/05/2013

03/06/2013

03/07/2013

03/08/2013

03/09/2013

03/10/2013

03/11/2013

03/12/2013

03/13/2013

;

run;

data new1(drop= month day year);

set new;

if weekday(mydate) NE 6 then delete;

run;

=====================================

Ouptut:-

============================================

                                                         Obs        mydate

                                                          1     03/01/2013

                                                          2     03/08/2013

=============================================

/Daman

Ask a Question
Discussion stats
  • 2 replies
  • 212 views
  • 0 likes
  • 3 in conversation