Programming the statistical procedures from SAS

keep the sum in proc expand

Reply
Super Contributor
Posts: 399

keep the sum in proc expand

I need help from some proc expand experts Smiley Happy

I have data that has date and units by quarter.. I want it to expand it by month but when the total for the year (by 12 months)  is added up it remains the same as the 4 quarters.

have

2000.Q1  33

2000.Q2  22

2000.Q3  50

2000.Q4  10

want

2000.01 11

2000.02 10

2000.03 12

2000.04   2

2000.05   5

2000.06  15

and so on...

so in the 'want' the sum for the 2000.01 & 2000.02 & 2000.03 remain 33 as per before.

Thanks

Ask a Question
Discussion stats
  • 0 replies
  • 112 views
  • 0 likes
  • 1 in conversation