topic Re: Proc Expand in SAS Procedures

Proc Expand

Aman4SAS — Tue, 08 Jul 2014 12:48:45 GMT

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

Re: Proc Expand

Ksharp — Wed, 09 Jul 2014 12:52:06 GMT

Not sure. Could you use

format date qtr.3 ;

Re: Proc Expand

Aman4SAS — Wed, 09 Jul 2014 13:08:53 GMT

thanks for reply

but i m talking about changing quarter cycle.

Re: Proc Expand

RW9 — Wed, 09 Jul 2014 13:26:10 GMT

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

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

Re: Proc Expand

Aman4SAS — Wed, 09 Jul 2014 13:58:37 GMT

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?

Re: Proc Expand

CTorres — Wed, 09 Jul 2014 14:10:40 GMT

Try the ROUND function.

Re: Proc Expand

cov_derek — Thu, 24 Jul 2014 17:07:57 GMT

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.