BookmarkSubscribeRSS Feed
Aman4SAS
Obsidian | Level 7

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

6 REPLIES 6
Ksharp
Super User

Not sure. Could you use

format date qtr.3  ;

Aman4SAS
Obsidian | Level 7

thanks for reply

but i m talking about changing quarter cycle.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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
Obsidian | Level 7

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
Quartz | Level 8

Try the ROUND function.

cov_derek
Fluorite | Level 6

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 1226 views
  • 0 likes
  • 5 in conversation