Blaming the victims is probably a too strong critic but the fact that such interpreter error was never fixed and this post has no SAS people helping does reflect how SAS deals with its problems. Many people continue to use SAS only because the company they work has legacy SAS datasets, think about how many new grad actually learnt SAS instead of Python or SQL? ... View more

Please provide an example of data where you are having trouble filtering.  (Note in your example you have mistakenly added an equal sign and typed a semi-colon instead of comma between the quoted list of values.) proc sql; create table target as select * from source where value in ("Tom's Trucks" , "Carstop") ; quit; Also since this is SQL code are you perhaps not running that WHERE clause in SAS but have actually pushed it into some remote database that has a different understanding of the meaning of double quote and single quotes? ... View more