https://communities.sas.com/t5/SAS-Procedures/re-Selecting-Data/m-p/343761#M63432 <P>Those conditions are all mutually exclusive.</P><P>&nbsp;</P><P>Are you trying to do something more like "where month(rankDate) in (3, 6, 9)"?</P> Thu, 23 Mar 2017 15:46:03 GMT collinelliot 2017-03-23T15:46:03Z https://communities.sas.com/t5/SAS-Procedures/re-Selecting-Data/m-p/343759#M63431 <P>I want to select observations their month date is march juin september and december. My program does not work what is the problem</P> <P>&nbsp;</P> <P>proc sql;<BR /> create table joint_data as<BR /> select *<BR /> from joint<BR /> where (Month(rankdate)=3 and Month(rankdate)=6 and Month(rankdate)=9 and Month(rankdate)=12);<BR /> quit;</P> Thu, 23 Mar 2017 15:37:00 GMT https://communities.sas.com/t5/SAS-Procedures/re-Selecting-Data/m-p/343759#M63431 sasphd 2017-03-23T15:37:00Z https://communities.sas.com/t5/SAS-Procedures/re-Selecting-Data/m-p/343761#M63432 <P>Those conditions are all mutually exclusive.</P><P>&nbsp;</P><P>Are you trying to do something more like "where month(rankDate) in (3, 6, 9)"?</P> Thu, 23 Mar 2017 15:46:03 GMT https://communities.sas.com/t5/SAS-Procedures/re-Selecting-Data/m-p/343761#M63432 collinelliot 2017-03-23T15:46:03Z