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??
Not sure. Could you use
format date qtr.3 ;
thanks for reply
but i m talking about changing quarter cycle.
Look at the months entry, so something along the lines of to=month2.3?
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?
Try the ROUND function.
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.
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.