Help using Base SAS procedures

what is the condition used to solve the query

Reply
Frequent Contributor
Posts: 111

what is the condition used to solve the query

Hi all, can you give your valid comments to solve this type of query.

i have two datasets

1. annuity

2. policy

annuity variables are account_no, account_value, policy_no.

policy variables are policy_no, year, p_type.

in policy_type we have the different types suppose A,B,C,D,E,F,G,H.

We consider A,B,C,D are one type let us consider it as reg_policy. The remaining all are individual.

now we want the output like

Account

Number

Sum_of_acccontvalue

No_of_policies

ranks

2010

2011

2012

2013

2014

2010

2011

2012

2013

2014

2010

2011

2012

The condition is that

1. If the no_of_policies example like in 2010 is 100 then policy_type  in that reg_policy is the maximum value compare to  remaining all. We want only that information.

2. Ranks are given based on sum_of_accountvalue with year wise.

Super Contributor
Posts: 490

Re: what is the condition used to solve the query

Could you give data set example and the desired output.

Super User
Posts: 5,260

Re: what is the condition used to solve the query

Quite a complex query from what it sounds. Why don't you give it a go and get back to us with some more specific question?

Data never sleeps
Respected Advisor
Posts: 3,908

Re: what is the condition used to solve the query

You need definitely to provide some representative sample data.

"annuity variables are account_no, account_value, policy_no"  

Shouldn't there also be a "date" variable in annuity? Else how would you be able to create account_value sums by year, and how would you join "annuity" with "policy"?

Ask a Question
Discussion stats
  • 3 replies
  • 215 views
  • 0 likes
  • 4 in conversation