BookmarkSubscribeRSS Feed
Vanya16
Calcite | Level 5

Hi Guys, what code can i use to convert quarterly data to Annual data; Here is a sample of the data. You will notice some quarters in some years are missing. But ideally i want to have annual figures summed up from quarterly figures per year per "Accper".  I want to have totals for TOR and TOE in two new columns computed from adding up the different figures from the different quarters. 

 

StkcdAccperTORTOEyearmonthdayQuarter
131/12/1991334690000188230000199112314
131/12/1992475510800254612800199212314
130/06/1993266495500019936302
131/12/1993407870596.5114621987.4199312314
130/06/1994297087559.499154582.9319946302
131/12/1994662338768.2323169773.6199412314
130/06/1995415720836.9181933045.419956302
131/12/1995944990411.4480495603.7199512314
130/06/1996652159903.4274865660.919966302
131/12/19961261061632495232702.5199612314
130/06/1997650518641300511899.819976302
131/12/19971348895058733785961.5199712314
130/06/1998694283519.3330525163.819986302
131/12/199817581116581117254216199812314
130/06/1999498367080328570297.819996302
131/12/199914712206901119905523199912314
130/06/200056394265952451392220006302
131/12/200014312862641259262034200012314
130/06/200183651415476802407320016302
131/12/200121184413632035715964200112314
131/03/200259599831348961104720023311
130/06/20021315435885128900931520026302
130/09/20022120786642203508685320029303
131/12/200230770988473120449041200212314
131/03/200364996851665002813320033311
130/06/20031428220006143262488820036302
130/09/20032734822115283952789320039303
131/12/200331288362643482265794200312314
2 REPLIES 2
kiranv_
Rhodochrosite | Level 12

may something like this might work.

 

proc sql;

select a.*, sum(TOR) as sum_tor, sum(TOE) as sum_toe from have

group by year, quarter;

quit;

Kurt_Bremser
Super User
proc sql;
create table want as
select year, sum(TOR) as TOR, sum(TOE) as TOE
from have
group by year;
quit;

or

proc summary data=have;
class year;
var TOR TOE;
output
  out=want (drop=_type_ _freq_)
  sum(TOR)=TOR
  sum(TOE)=TOE
;
run;

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Discussion stats
  • 2 replies
  • 1566 views
  • 0 likes
  • 3 in conversation