Sentry Page Protection
Exercise (10-10)
Background
Jacky has recently been hired as the CEO of a local insurance brokerage in Toronto.
Jacky has a lot of ideas on how to improve the business, increase sales and retention while cutting down operational costs.
However, Jacky needs to first understand the existing customers and he has asked you to create a customer report for him to review.
The data set has been extracted from by the IT department.
Task 1
Download and open the profile.txt below. Copy the code and run it on SAS Studio.
Background
Jacky has recently been hired as the CEO of a local insurance brokerage in Toronto.
Jacky has a lot of ideas on how to improve the business, increase sales and retention while cutting down operational costs.
However, Jacky needs to first understand the existing customers and he has asked you to create a customer report for him to review.
The data set has been extracted from by the IT department.
Task 1
Download and open the profile.txt below. Copy the code and run it on SAS Studio.
profile.txt |
The data set PROFILE will be created from the code.
It contains:
- ID: Customer ID
- Gender
- Age
- Edu: Education Levels
- Height: (cm)
- Weight: (kg)
- Race
- Region: Geographic Locations
- Income
- Premium: Monthly Premium
Check and ensure the data set contains 5000 observations with all of the variables above.
Task 2
Compute the summary statistics (N, Mean, Standard Deviation, Minimum, and Maximum) on the continuous variables (i.e. age, height, weight, income and premium).
Compute the frequency statistics (frequency and percentage) on the categorical variables (gender, edu, race, and region).
Print the results to a PDF file.
Tips: to print the results to a pdf file, you can use the ODS PDF statement as below:
ODS PDF File = '/folders/myfolders/filename.pdf';
<your code>
ODS PDF close;