I want to select observations their month date is march juin september and december. My program does not work what is the problem
proc sql; create table joint_data as select * from joint where (Month(rankdate)=3 and Month(rankdate)=6 and Month(rankdate)=9 and Month(rankdate)=12); quit;
Are you trying to do something more like "where month(rankDate) in (3, 6, 9)"?
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.