Help using Base SAS procedures

Calculate all "n-way" sums for a list of values

Reply
N/A
Posts: 0

Calculate all "n-way" sums for a list of values

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!
Super Contributor
Super Contributor
Posts: 3,174

Re: Calculate all "n-way" sums for a list of values

Posted in reply to deleted_user
Have you looked at PROC SUMMARY with and without NWAYS and MISSING parameters?

Scott Barry
SBBWorks, Inc.
Ask a Question
Discussion stats
  • 1 reply
  • 88 views
  • 0 likes
  • 2 in conversation