turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- Calculate all "n-way" sums for a list of values

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

06-18-2009 01:11 PM

I have a list of ID's along with 1 or more values associated to it. What I want to do is calculate all possible sums for the values that belong to each ID. For example

ID Value

A 1

A 2

B 2

B 8

B 10

would become

ID Value

A 1

A 2

A 3

B 2

B 8

B 10

B 10

B 12

B 18

B 20

It's the same idea as listing all possible n-way interactions given n # of treatments. However, I'm looking to calculate all n-way sums.

Is there a procedure that can do this for me, or will I have to create my own stored procedure?

Thanks in advance!

ID Value

A 1

A 2

B 2

B 8

B 10

would become

ID Value

A 1

A 2

A 3

B 2

B 8

B 10

B 10

B 12

B 18

B 20

It's the same idea as listing all possible n-way interactions given n # of treatments. However, I'm looking to calculate all n-way sums.

Is there a procedure that can do this for me, or will I have to create my own stored procedure?

Thanks in advance!

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

06-18-2009 02:39 PM

Have you looked at PROC SUMMARY with and without NWAYS and MISSING parameters?

Scott Barry

SBBWorks, Inc.

Scott Barry

SBBWorks, Inc.