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
Use the weekday function.
where weekday(date)=6;
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: