Conditional SUM for rows

Demographer — Mon, 24 Apr 2017 13:40:09 GMT

Hello,

I have a dataset that looks like this:

year	orig	dest	flow
1990	AT	BE	456
1990	AT	DE	356
1990	AT	DE	21
1990	BE	DE	235

I would like to sum the column "flow" when year, orig and dest have the same value. For instance, in that example, the dataset should become:

year	orig	dest	flow
1990	AT	BE	456
1990	AT	DE	377
1990	BE	DE	235

Is there a simple way to do this?

Re: Conditional SUM for rows

RW9 — Mon, 24 Apr 2017 13:42:49 GMT

Post test data in the form of a datastep!

proc sql;
  create table WANT as
  select  YEAR,
          ORIG,
          DEST,
          sum(FLOW) as FLOW
  from    HAVE
  group by YEAR,ORIG,DEST;
quit;

As a guess.

topic Re: Conditional SUM for rows in SAS Enterprise Guide

Conditional SUM for rows

Re: Conditional SUM for rows