topic Re: How to extract day of the week from a date column in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129448#M294703 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find below the code and its output:-</P><P></P><P>=====================================</P><P>data new;</P><P>informat mydate mmddyy10.;</P><P>input mydate ;</P><P>format mydate mmddyy10.;</P><P>datalines;</P><P>03/01/2013</P><P>03/02/2013</P><P>03/03/2013</P><P>03/04/2013</P><P>03/05/2013</P><P>03/06/2013</P><P>03/07/2013</P><P>03/08/2013</P><P>03/09/2013</P><P>03/10/2013</P><P>03/11/2013</P><P>03/12/2013</P><P>03/13/2013</P><P>;</P><P>run;</P><P></P><P>data new1(drop= month day year);</P><P>set new;</P><P>if weekday(mydate) NE 6 then delete;</P><P>run;</P><P>=====================================</P><P></P><P>Ouptut:-</P><P></P><P>============================================</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Obs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mydate</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 03/01/2013</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 03/08/2013</P><P></P><P>=============================================</P><P></P><P>/Daman</P></BODY></HTML> Thu, 07 Mar 2013 04:29:52 GMT damanaulakh88 2013-03-07T04:29:52Z How to extract day of the week from a date column https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129446#M294701 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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</P><P></P><P>how can I do it?</P><P></P><P>Thanks in advance</P></BODY></HTML> Thu, 07 Mar 2013 04:13:50 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129446#M294701 tparvaiz 2013-03-07T04:13:50Z Re: How to extract day of the week from a date column https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129447#M294702 <HTML><HEAD></HEAD><BODY><P>Use the weekday function.</P><P>where weekday(date)=6;</P></BODY></HTML> Thu, 07 Mar 2013 04:18:11 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129447#M294702 Reeza 2013-03-07T04:18:11Z Re: How to extract day of the week from a date column https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129448#M294703 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find below the code and its output:-</P><P></P><P>=====================================</P><P>data new;</P><P>informat mydate mmddyy10.;</P><P>input mydate ;</P><P>format mydate mmddyy10.;</P><P>datalines;</P><P>03/01/2013</P><P>03/02/2013</P><P>03/03/2013</P><P>03/04/2013</P><P>03/05/2013</P><P>03/06/2013</P><P>03/07/2013</P><P>03/08/2013</P><P>03/09/2013</P><P>03/10/2013</P><P>03/11/2013</P><P>03/12/2013</P><P>03/13/2013</P><P>;</P><P>run;</P><P></P><P>data new1(drop= month day year);</P><P>set new;</P><P>if weekday(mydate) NE 6 then delete;</P><P>run;</P><P>=====================================</P><P></P><P>Ouptut:-</P><P></P><P>============================================</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Obs&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mydate</P><P></P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 03/01/2013</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp; 03/08/2013</P><P></P><P>=============================================</P><P></P><P>/Daman</P></BODY></HTML> Thu, 07 Mar 2013 04:29:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-day-of-the-week-from-a-date-column/m-p/129448#M294703 damanaulakh88 2013-03-07T04:29:52Z