How to extract day of the week from a date column

[tparvaiz]

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

[Reeza]

Use the weekday function.

where weekday(date)=6;

[damanaulakh88]

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