Help using Base SAS procedures

Proc Expand

Reply
Super Contributor
Posts: 265

Proc Expand

Hi ,

Can we change quarter cycle in Proc expand??

i.e default quarter is JAN FEB MAR

i looking for [DEC JAN FEB]  [MAR APR MAY] [JUN JUL AUG] [SEP OCT NOV]

is it possible in PROC EXPAND form Month to Quarter??

Grand Advisor
Posts: 9,466

Re: Proc Expand

Not sure. Could you use

format date qtr.3  ;

Super Contributor
Posts: 265

Re: Proc Expand

thanks for reply

but i m talking about changing quarter cycle.

Esteemed Advisor
Esteemed Advisor
Posts: 7,006

Re: Proc Expand

Try: http://support.sas.com/documentation/cdl/en/etsug/60372/HTML/default/viewer.htm#etsug_intervals_sect...

Look at the months entry, so something along the lines of to=month2.3?

Super Contributor
Posts: 265

Re: Proc Expand

Hi Ksharp,

In sas there is anyway to get rid of unwanted numbers.

for example i have number 312.88965

i want only 312.8 fixed. no other number.

through format , length and informat change the only display numbers, but in behind it carry all number which effect coming calculation.

one way i found that to first export like excel and text then import again, is there any possible way to do it in sas?

Regular Contributor
Posts: 180

Re: Proc Expand

Try the ROUND function.

Contributor
Posts: 23

Re: Proc Expand

If you want your quarters to start in December, March, June, and September, use the interval QTR.3 to shift the starting pont of your interval by 3 months.

Ask a Question
Discussion stats
  • 6 replies
  • 295 views
  • 0 likes
  • 5 in conversation