topic Somme Sql in SAS Programming

Somme Sql

WilliamB — Fri, 27 Apr 2018 08:45:01 GMT

Hello,

I have a table, I would like in SQL the sum of prices per ID.

Thanks for your help

Table: what I want:

ID	Price	ID	Somme Price
147	14	147	14
145	45	145	63
174	17	174	17
145	18	178	83
178	18	1798	68
1798	45	14567	67
14567	67	1646	34
1646	34
1798	23
178	65

Re: Somme Sql

PeterClemmensen — Fri, 27 Apr 2018 08:49:42 GMT

Do like this

data have;
input ID$ Price;
datalines;
147 14 
145 45 
174 17 
145 18 
178 18 
1798 45 
14567 67 
1646 34 
1798 23 
178 65 
;

proc sql;
   create table want as
   select ID, sum(Price) as SumPrice
   from have
   group by ID;
quit;

Re: Somme Sql

RW9 — Fri, 27 Apr 2018 08:50:14 GMT

Something like:

proc sql;
  create table want as 
  select id,sum(price) as some_price from have group by id;
quit;

Re: Somme Sql

emrancaan — Fri, 27 Apr 2018 09:22:53 GMT

proc tabulate data=HAVE out=want (drop =_type_ _page_ _table_ Price_N);
  class ID;
  var Price;
  tables ID, Price*(sum);
   ;
run;