topic Re: Multiple variables in sum-function in SAS Enterprise Guide

Multiple variables in sum-function

DavidDemeyer — Tue, 19 Feb 2013 17:08:05 GMT

Hi everyone,

I have a dataset with 90 variables, when I want to create a sum-function with the Query Builder I have to dubble-click on each variable.

Is there a way to select all the variables faster? Ideal would be something like: sum(var2 [until] var90).

Thanks,

David

Re: Multiple variables in sum-function

art297 — Tue, 19 Feb 2013 17:27:37 GMT

Do you need do to it with the Query Builder? It would be a trivial request using proc summary.

Re: Multiple variables in sum-function

DavidDemeyer — Tue, 19 Feb 2013 17:42:41 GMT

Well for this step the proc summary is perfect.

But in a later step I need the group them in 4 big groups... (and I don't know if that's possible with the proc summary)

Re: Multiple variables in sum-function

art297 — Tue, 19 Feb 2013 18:09:05 GMT

You would have to explain what you mean by 4 big groups. If it is groups of records, you can use a by variable. If it is groups of variables, you can first use proc transpose (to make the table wide) and then simply use proc summary on the wide tables.

Re: Multiple variables in sum-function

DavidDemeyer — Tue, 19 Feb 2013 18:56:44 GMT

Yes, 4 groups of variables.

Maybe it's more clear with a little example:

var1 var2 var3 var4 var5 var6

A 4 8 6 9 1

B 9 5 3 0 2

C 2 3 2 3 5

D 1 2 5 9 1

E 9 7 3 4 3

And the result should be a new dataset:

var1 group1 group2

A 12 16

B 14 5

C 5 10

...

group1: sum(var1, var2)

group2: sum(var3, var4, var5)

Re: Multiple variables in sum-function

art297 — Tue, 19 Feb 2013 19:46:46 GMT

I would use the sum function in a datastep for that. e.g.,

data have;

input var1 $ var2-var6;

group1=sum(var2,var3);

group2=sum(of var4-var6);

cards;

A 4 8 6 9 1

B 9 5 3 0 2

C 2 3 2 3 5

D 1 2 5 9 1

E 9 7 3 4 3

;

Re: Multiple variables in sum-function

DavidDemeyer — Tue, 19 Feb 2013 21:24:35 GMT

This was exactly what I was looking for! Thank you!