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 (6-10)

cont... 

Task 3

Tom also wants to find out, on average, how long the majority of the computer will start experiencing problems.
 
Create a new variable called PERIOD that classifies the period where the computers start experience problems:
  • < 1 year
  • Between 1-2 year
  • Between 2-3 year
  • >3 year
 
The classification should be based on the date of purchase and date of repair requested.

Example

Date of Purchase: 01JAN2013
Date of Repair: 01APR2014

Since there are about 15 months between the date of purchase and date of repair, the period should be classified as "Between 1-2 year".

Please note that the date of purchase contains some incomplete date, as most customers didn't remember the exact date when they made the purchase.
 
You should assume middle of the month if the day of purchase is missing.

E.g.
FEB2013 --> 15FEB2013
 
You should also assume middle of the year if the month of purchase is missing.

E.g.
2013 --> 30JUN2013
Next
Already a member? Go to member's area.