Proc Expand

[Aman4SAS]

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??

[Ksharp]

Not sure. Could you use

format date qtr.3  ;

[Aman4SAS]

thanks for reply

but i m talking about changing quarter cycle.

[RW9]

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?

[Aman4SAS]

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?

[CTorres]

Try the ROUND function.

[cov_derek]

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.