Sentry Page Protection

Please Wait...

Exercise (1-9)

Run the code in the yellow box before working on this exercise:

Data Phonebill; Input BillNo $ Minutes Messages Data; Datalines; B001 238 15 670 B002 323 39 1300 B003 89 2 230 B004 124 22 890 B005 156 34 1290 B006 122 22 1180 B007 211 26 450 B008 189 28 990 B009 123 23 220 B010 101 7 330 ; Run;

The PHONEBILL data set contains 4 variables related to the mobile phone usage:

• BillNo: Bill Number
  
• Minutes: Number of minutes used
  
• Messages: Number of text messages sent and received
  
• Data: The amount of data used (in MB)

The $30 monthly plan includes 200 minutes, 25 text messages and 1000 MB data usage.

Below is the additional charges incurred when the usage exceeds the monthly limit:

• Minutes: $0.1 per minute when over 200 minutes
  
• Messages: $0.5 per message when over 25 messages
• Data: $0.05 per MB when over 1000 MB

Write a SAS program to calculate the total amount for each bill.

Next