topic Re: How to create a column where the value in each row is the sum of all values in another column? in New SAS User

How to create a column where the value in each row is the sum of all values in another column?

KarolineN — Mon, 17 Aug 2020 14:59:54 GMT

Dear SAS community,

Would someone be so kind to help me with a small challenge? It is probably very simple, but being a beginner I have not been able to figure it out: I have a dataset with two columns (A and B) that very simplified looks something like this:

A B

Cars 90

Buses 50

Planes 10

Helicopters 2

and I would like to create an additional column C, where the value in each row is the sum of all the values in column B, like this:

A B C

Cars 90 152

Buses 50 152

Planes 10 152

Helicopters 2 152

Thank you very much for your kind help!

Best regards,

Karoline

Re: How to create a column where the value in each row is the sum of all values in another column?

novinosrin — Mon, 17 Aug 2020 15:02:16 GMT

proc sql;
 create table want as
 select *, sum(b) as c
 from your_dataset;
quit;

Re: How to create a column where the value in each row is the sum of all values in another column?

novinosrin — Mon, 17 Aug 2020 15:09:14 GMT

And if you may prefer a datastep instead-


data want;
 set your_dataset(in=t1) your_dataset(in=t2);
 if t1 then c+b;
 if t2;
run;

Re: How to create a column where the value in each row is the sum of all values in another column?

KarolineN — Mon, 17 Aug 2020 15:24:12 GMT

Thank you very much @novinosrin! That worked 🙂 I am grateful for your quick help.

Best regards,

Karoline