Hi,
Lets say I do the following steps in a data steps;
data mytest.test;
set mytest.data;
Quarter=yyq(2012,1);
format Quarter yyqs8.;
run;
Quarter variable will be 2012/1 for this table
Now, how do I select the first quarter of 2012 in a proc sql query :
proc sql;
create table myquartertest
select * from mytest.test
where Quarter = "2012/1";
quit;
Thank you for your help and time.
Try :
where year(quarter)=2012 and qtr(quarter)=1;
Thank you very much for the quick reply.
Works like a charm.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.