The new management of a local hotel decided to update their recently acquired (and very outdated) property by installing wireless Internet service for their guests. They are also considering updating their billing system because the method used by the previous owner seems faulty. In order to conduct a billing analysis, they would like some calculations about the guests who stayed with them during the first part of February (this was the first month after the change of ownership). The raw data file Hotel.dat contains variables with information on room number, number of guests, check-in month, day, year, check-out month, day, year, use of wireless Internet service, number of days of Internet use, room type, and room rate.
a) Examine the raw data file Hotel.dat and read it into SAS. Next, create date variables for the
check-in and check-out dates, and format them to display as readable dates.
b) Create a variable that calculates the subtotal as the room rate times the number of days in the stay, plus a per person rate ($10 per day for each person beyond one guest, for example for
3 guests, the total per person rate will be (3-1)*10=$20), plus an Internet service fee ($9.95
for a one-time activation and $4.95 per day of use).
c)Create a variable that calculates the grand total as the subtotal plus sales tax at 7.75%. The
result should be rounded to two decimal places.
