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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.