https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445037#M283070 Do you have "proc sql;" before and "quit;" after your select-statement? Tue, 13 Mar 2018 05:36:10 GMT error_prone 2018-03-13T05:36:10Z https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445035#M283069 <P>I am trying to pull records that are equal to 'Unknown' and DRG =469. What is wrong with my where statement?</P><P>&nbsp;</P><P>&nbsp;</P><P>select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown' and clm_drg_cd ='469';</P><P>&nbsp;</P><P><U><STRONG>LOG BELOW</STRONG></U></P><P>&nbsp;</P><P>1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;<BR />61<BR />62 select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown'<BR />______<BR />180<BR />62 ! and clm_drg_cd ='469';<BR /><BR />ERROR 180-322: Statement is not valid or it is used out of proper order.<BR /><BR />63<BR />64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;<BR />77</P> Tue, 13 Mar 2018 05:32:11 GMT https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445035#M283069 fpascal 2018-03-13T05:32:11Z https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445037#M283070 Do you have "proc sql;" before and "quit;" after your select-statement? Tue, 13 Mar 2018 05:36:10 GMT https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445037#M283070 error_prone 2018-03-13T05:36:10Z https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445040#M283071 late night programming ... thanks<BR /> Tue, 13 Mar 2018 05:39:19 GMT https://communities.sas.com/t5/SAS-Programming/Where-condition-with-multiple-variables/m-p/445040#M283071 fpascal 2018-03-13T05:39:19Z