I have a quarter variable that is in format YYQ6. I would like to do some date comparison such as if quarter = 2014Q3. I used to be able to do it with "if date = '01Sep2014'd then ...." in SAS 9.3 but cannot do it now since I upgraded SAS. So I am not sure if my syntax is wrong or SAS changed something with the 9.4 version. Please help! data WORK.TEST;
infile datalines dsd truncover;
input TICKER:$10. CUSIP:$10. PRC:BEST12. quarter:YYQ6.;
format PRC BEST12. quarter YYQ6.;
datalines4;
AE,00003210,6.25,1977Q1
AE,00003210,6.5,1977Q2
AE,00003210,9,1977Q3
AE,00003210,9.25,1977Q4
AE,00003210,8.875,1978Q1
AE,00003210,,1978Q2
AMFD,00016510,6.25,1983Q3
AMFD,00016510,7.5,1983Q4
AMFD,00016510,6.5625,1984Q1
AMFD,00016510,5.9375,1984Q2
;;;;
... View more