proc sql; create table slc.NEWSYS_201610_1 as select * from Slc.NEWSYS_201610 where Open_DT between "01Jan2019"d and "31JAN2020"d;= (select Open_DT between "01Jan2019"d and "31JAN2020"d ; Open_Date = datepart(Open_DT) format Open_DT datetime. Open_Date date9); run;   above is my query  Below is the error message. Please what am i doing wrong. I am new to SAS   NOTE: Table SLC.NEWSYS_201610_1 created, with 0 rows and 72 columns. 34 ! = _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 35 36 (select Open_DT between "01Jan2019"d and "31JAN2020"d ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 37 Open_Date = datepart(Open_DT) _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 38 39 format Open_DT datetime. Open_Date date9);   ... View more