Need help with this question

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

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: 101

Re: Need help with this question

Start here:

data want (drop=_Smiley Happy;

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;

View solution in original post


All Replies
Respected Advisor
Posts: 4,654

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: 101

Re: Need help with this question

Start here:

data want (drop=_Smiley Happy;

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 293 views
  • 1 like
  • 3 in conversation