topic Re: sort by quarter in SAS Programming

sort by quarter

mpajoh — Mon, 23 Aug 2010 17:42:33 GMT

I have data set with SAS date variable spanning several years.
I want to create a variable that contains the year and the quarter (e.g 2010Q2), which can then be used to sort by.

Can anyone help?

Masoud

Re: sort by quarter

Cynthia_sas — Mon, 23 Aug 2010 18:01:42 GMT

Hi:
Read about the various YYQ formats. For example, a SAS date value for 03/15/2006 could be used to create a character variable called QTRVAL with this code:
[pre]
qtrval = put(date,yyq6.);
[/pre]

And the resulting value would be: 2006Q1

The documentation on the various formats is here:
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#/documentation/cdl/en/lrdict/63026/HTML/default/a001263753.htm
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#/documentation/cdl/en/lrdict/63026/HTML/default/a000201247.htm
http://support.sas.com/documentation/cdl/en/lrdict/63026/HTML/default/viewer.htm#/documentation/cdl/en/lrdict/63026/HTML/default/a002231398.htm

cynthia

Re: sort by quarter

mpajoh — Mon, 23 Aug 2010 19:07:06 GMT

Thanks Cynthia.

Re: sort by quarter

Peter_C — Mon, 23 Aug 2010 19:30:17 GMT

Masoud

what difference do you expect when sortng by (internal) sas date and sorting by quarter?

just interested
Peterc

Re: sort by quarter

sbb — Mon, 23 Aug 2010 20:11:29 GMT

With a multiple-variable BY statement, the order of observations that have date values throughout a given quarter, may get sorted differently if only considering the "formatted" value sort-sequence, presuming the BY statement has additional variables to the right of the date variable itself.

Scott Barry
SBBWorks, Inc.

Re: sort by quarter

mpajoh — Tue, 24 Aug 2010 18:31:09 GMT

I am using the quarter variable to for proc summary's class variable.

Masoud

Re: sort by quarter

data_null__ — Tue, 24 Aug 2010 18:55:05 GMT

You can use the CLASS statement option GROUPINTERNAL to have you cake and eat it too.

Re: sort by quarter

mpajoh — Wed, 25 Aug 2010 12:53:55 GMT

Thank you all.
I will have to investigate and learn.

Masoud