topic Re: correct code for sum in Programming 1 and 2

correct code for sum

Ripalsshah0 — Wed, 11 Nov 2020 11:40:58 GMT

Here below is my example data.

product price

boots $20

slipper $30

trainners $40

boots $25

boots $65

from above dataset I want to do sum of Boots Price.

What function should i use to add all value in column.

thanks,

Ripal

Re: correct code for sum

Kurt_Bremser — Wed, 11 Nov 2020 11:43:15 GMT

In SQL, select sum(price) where product = "boots"

Re: correct code for sum

PaigeMiller — Wed, 11 Nov 2020 11:45:56 GMT

@Ripalsshah0 wrote:

Here below is my example data.

product price

boots $20

slipper $30

trainners $40

boots $25

boots $65

from above dataset I want to do sum of Boots Price.

What function should i use to add all value in column.

thanks,

Ripal

proc means data=have(where=(product='boots')) sum;
var price;
run;

or even better yet, you can get the sums of all products

proc means data=have sum;
class product;
var price;
run;

Re: correct code for sum

Ripalsshah0 — Wed, 11 Nov 2020 12:03:55 GMT

thanks its working.