I would like to filter a data set by a date column that is in YYQ format. The data look something like this: group pay_quarter N 1 2019Q1 454 1 2020Q1 500 2 2021Q1 488 3 2021Q2 400 When I click on the 'pay_quarter' column, SAS specifies that it is type numeric, format YYQ. Can someone explain to me why this doesn't work: proc sql; create table want as select * from have where pay_quarter in ('2019Q1'd, '2021Q1'd); quit; I have found that I can do this where pay_quarter in (21550, 22281); but I'm hoping there is a more user-friendly way.
... View more