topic Re: what is the condition used to solve the query in SAS Procedures

what is the condition used to solve the query

Ravikumarkummari — Sat, 31 Jan 2015 11:32:20 GMT

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.

Re: what is the condition used to solve the query

mohamed_zaki — Sat, 31 Jan 2015 11:39:45 GMT

Could you give data set example and the desired output.

Re: what is the condition used to solve the query

LinusH — Sat, 31 Jan 2015 21:08:09 GMT

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?

Re: what is the condition used to solve the query

Patrick — Sun, 01 Feb 2015 03:35:48 GMT

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"?