01312015 06:32 AM
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.
01312015 06:39 AM
Could you give data set example and the desired output.
01312015 04:08 PM
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?
01312015 10:35 PM
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"?