Solved
New Contributor
Posts: 3

# Need help with this question

Hi, I looking for help with this question. I have a dataset with columns A and B and want to calculate C such that the final dataset looks something like this:

A   B   C

1   5   (4*5)=20

2   6   (3*5)+(4*6)=39

3   7   (2*5)+(3*6)+(4*8)=56

4   8   (1*5)+(2*6)+(3*7)+(4*8)=70

I will be more than glad to get techie hands on this one for me.

Thanks

kmante

Accepted Solutions
Solution
‎05-31-2012 09:00 AM
Frequent Contributor
Posts: 103

## Re: Need help with this question

Start here:

data want (drop=_;

input a b;

do _i = 0 to (a-1);

c = sum( c, (b-_i)*(b-a-_i) );

end;

cards;

1 5

2 6

3 7

4 8

;

run;

All Replies
Posts: 5,521

## Re: Need help with this question

Shouldn't it be

3   7   (2*5)+(3*6)+(4*7)=56

There are many ways to guess what is required. What would be the result if the dataset contained only the first three lines?

PG

PG
New Contributor
Posts: 3

## Re: Need help with this question

Hi PG,

Yes thanks for the correction it should be (4*7)...

The actual dataset contain more observations than the example but the logic should work for the bid data if found for this.

Solution
‎05-31-2012 09:00 AM
Frequent Contributor
Posts: 103

## Re: Need help with this question

Start here:

data want (drop=_;

input a b;

do _i = 0 to (a-1);

c = sum( c, (b-_i)*(b-a-_i) );

end;

cards;

1 5

2 6

3 7

4 8

;

run;

New Contributor
Posts: 3

## Re: Need help with this question

Hi SAS_Bigot,

That was a brilliant and simple answer and works perfect. Thanks a lots.

🔒 This topic is solved and locked.