Calcite | Level 5

## Read data and calculate new variables

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.

2 REPLIES 2
Community Manager

## Re: Read data and calculate new variables

This looks a lot like a homework assignment. And you didn't provide the data for anyone to provide help.

Best if you show what you've tried, where you might have got stuck, and of course -- please include the data!

Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
SAS Super FREQ

## Re: Read data and calculate new variables

Hello,

The raw data file Hotel.dat ...

But a .dat extension is very generic. It tells us nothing about the way the file is constructed.

I guess it's just plain text here.
If it's plain text, then import with PROC IMPORT or a data step with INFILE (the latter option is probably the best).

Kind regards,
Koen

Discussion stats
• 2 replies
• 714 views
• 2 likes
• 3 in conversation