Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
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.
profile.txt
File Size: 419 kb
File Type: txt
Download File


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;
Next
Already a member? Go to member's area.