Where condition with multiple variables

[fpascal]

I am trying to pull records that are equal to 'Unknown' and DRG =469. What is wrong with my where statement?

select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown' and clm_drg_cd ='469';

LOG BELOW

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 select count(desy_sort_key) from etl.inp_claims_lds2013_2016 where Age_Range='Unknown'
______
180
62 ! and clm_drg_cd ='469';

ERROR 180-322: Statement is not valid or it is used out of proper order.

63
64 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
77

[error_prone · Accepted solution]

Do you have "proc sql;" before and "quit;" after your select-statement?

[fpascal]

late night programming ... thanks