topic Re: Need help with this question in SAS Programming

Need help with this question

kmante — Wed, 30 May 2012 23:06:41 GMT

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

Re: Need help with this question

PGStats — Wed, 30 May 2012 23:42:02 GMT

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?

Re: Need help with this question

kmante — Thu, 31 May 2012 05:19:20 GMT

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.

Re: Need help with this question

FloydNevseta — Thu, 31 May 2012 13:00:14 GMT

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;

Re: Need help with this question

kmante — Thu, 31 May 2012 17:18:41 GMT

Hi SAS_Bigot,

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