https://communities.sas.com/t5/SAS-Programming/BASE-SAS/m-p/372555#M89096 <P>Homework or interview? Please make an attempt at your own work. We're more than happy to help but this is not a request for help.</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/150980">@hmc</a> wrote:<BR /> <P>Hi Please help me in the below problem using SAS codes,</P> <P>have attached the excel below.</P> <P>The excel contains four sheets</P> <P>Demo: &nbsp;Demographic details of the customer<BR />Policy &nbsp;Type:Details about the type of policy, age limits &amp; duration limits for each insurance.<BR />Claims: Details regarding claims made, claim date, settlement date, amount claimed and settled<BR />Policy: &nbsp;Details of each policy, sum assured, duration of policy &amp; policy date,</P> <P>I want to calculate:</P> <P>Number of policies per person<BR /> Number of joint policies per person<BR /> Total sum assured<BR /> Gender (in the data for variable gender if the 1st string is “m”, irrespective of being capital or small letter, it means “male”, otherwise “female”)<BR /> Months on book (or number of months since a customer opened his/her 1st policy with the bank)<BR /> Age of the customer<BR /> Number of claims by a customer<BR /> Create a flag for customer who has claimed and for customer who has not claimed till date.<BR /> Flag taking the value 1 for a customer who has purchased a term insurance and 0 otherwise<BR /> Total claims for each customer<BR /> Flag taking value 1 for customer who will be ineligible to buy a term insurance after 5 years and value 0 otherwise<BR /> Date of the policy expiring first, in the format like 12/31/2016<BR /> Number of days since last claim made</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sun, 02 Jul 2017 14:59:37 GMT Reeza 2017-07-02T14:59:37Z https://communities.sas.com/t5/SAS-Programming/BASE-SAS/m-p/372530#M89079 <P>Hi Please help me in the below problem using SAS codes,</P><P>have attached the excel below.</P><P>The excel contains four sheets</P><P>Demo: &nbsp;Demographic details of the customer<BR />Policy &nbsp;Type:Details about the type of policy, age limits &amp; duration limits for each insurance.<BR />Claims: Details regarding claims made, claim date, settlement date, amount claimed and settled<BR />Policy: &nbsp;Details of each policy, sum assured, duration of policy &amp; policy date,</P><P>I want to calculate:</P><P>Number of policies per person<BR /> Number of joint policies per person<BR /> Total sum assured<BR /> Gender (in the data for variable gender if the 1st string is “m”, irrespective of being capital or small letter, it means “male”, otherwise “female”)<BR /> Months on book (or number of months since a customer opened his/her 1st policy with the bank)<BR /> Age of the customer<BR /> Number of claims by a customer<BR /> Create a flag for customer who has claimed and for customer who has not claimed till date.<BR /> Flag taking the value 1 for a customer who has purchased a term insurance and 0 otherwise<BR /> Total claims for each customer<BR /> Flag taking value 1 for customer who will be ineligible to buy a term insurance after 5 years and value 0 otherwise<BR /> Date of the policy expiring first, in the format like 12/31/2016<BR /> Number of days since last claim made</P><P>&nbsp;</P> Sun, 02 Jul 2017 12:33:58 GMT https://communities.sas.com/t5/SAS-Programming/BASE-SAS/m-p/372530#M89079 hmc 2017-07-02T12:33:58Z https://communities.sas.com/t5/SAS-Programming/BASE-SAS/m-p/372555#M89096 <P>Homework or interview? Please make an attempt at your own work. We're more than happy to help but this is not a request for help.</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/150980">@hmc</a> wrote:<BR /> <P>Hi Please help me in the below problem using SAS codes,</P> <P>have attached the excel below.</P> <P>The excel contains four sheets</P> <P>Demo: &nbsp;Demographic details of the customer<BR />Policy &nbsp;Type:Details about the type of policy, age limits &amp; duration limits for each insurance.<BR />Claims: Details regarding claims made, claim date, settlement date, amount claimed and settled<BR />Policy: &nbsp;Details of each policy, sum assured, duration of policy &amp; policy date,</P> <P>I want to calculate:</P> <P>Number of policies per person<BR /> Number of joint policies per person<BR /> Total sum assured<BR /> Gender (in the data for variable gender if the 1st string is “m”, irrespective of being capital or small letter, it means “male”, otherwise “female”)<BR /> Months on book (or number of months since a customer opened his/her 1st policy with the bank)<BR /> Age of the customer<BR /> Number of claims by a customer<BR /> Create a flag for customer who has claimed and for customer who has not claimed till date.<BR /> Flag taking the value 1 for a customer who has purchased a term insurance and 0 otherwise<BR /> Total claims for each customer<BR /> Flag taking value 1 for customer who will be ineligible to buy a term insurance after 5 years and value 0 otherwise<BR /> Date of the policy expiring first, in the format like 12/31/2016<BR /> Number of days since last claim made</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sun, 02 Jul 2017 14:59:37 GMT https://communities.sas.com/t5/SAS-Programming/BASE-SAS/m-p/372555#M89096 Reeza 2017-07-02T14:59:37Z