SAS Write a Program

211 3 2 7 2014 2 11 2014 NO Deluxe Suite 295 214 2 2 2 2014 2 12 2014 NO Basic no view 75 216 4 2 2 2014 2 13 2014 NO Suite 255 220 5 2 3 2014 2 12 2014 YES 2 Basic w/view 155 221 3 2 3 2014 2 12 2014 NO Luxury 195 223 5 2 7 2014 2 13 2014 NO Suite 255 238 4 1 31 2014 2 13 2014 YES 10 Basic w/view 155 241 1 2 1 2014 2 13 2014 YES 3 Luxury 195 244 5 2 3 2014 2 12 2014 YES 9 Deluxe Suite 295 247 4 2 7 2014 2 11 2014 YES 4 Basic no view 75 248 4 2 8 2014 2 13 2014 YES 5 Basic no view 75 253 3 2 2 2014 2 12 2014 YES 7 Suite 255 255 5 2 8 2014 2 13 2014 NO Basic w/view 155 270 1 2 4 2014 2 12 2014 NO Deluxe Suite 295 272 2 2 2 2014 2 11 2014 YES 7 Suite 255 275 1 2 2 2014 2 10 2014 NO Basic no view 75 276 5 2 10 2014 2 12 2014 NO Basic w/view 155 281 1 2 9 2014 2 10 2014 NO Basic w/view 155 283 1 2 8 2014 2 11 2014 NO Deluxe Suite 295 288 3 2 2 2014 2 13 2014 NO Suite 255 293 4 2 7 2014 2 11 2014 YES 4 Basic no view 75 294 5 2 1 2014 2 12 2014 YES 3 Basic w/view 155 298 6 2 1 2014 2 10 2014 NO Suite 255 303 2 2 2 2014 2 12 2014 YES 2 Luxury 195 309 2 2 6 2014 2 12 2014 YES 6 Suite 255 312 3 2 3 2014 2 13 2014 YES 4 Luxury 195 315 6 2 7 2014 2 11 2014 NO Basic w/view 155 319 6 2 4 2014 2 11 2014 NO Suite 255 322 6 2 4 2014 2 11 2014 NO Basic no view 75 325 5 2 7 2014 2 12 2014 YES 5 Basic w/view 155 326 2 2 3 2014 2 12 2014 YES 2 Deluxe Suite 295 342 6 2 7 2014 2 11 2014 YES 4 Basic no view 75 350 2 2 9 2014 2 10 2014 NO Basic w/view 155 370 4 2 2 2014 2 11 2014 YES 4 Basic w/view 155 386 4 2 5 2014 2 12 2014 YES 7 Basic w/view 155 397 2 2 4 2014 2 10 2014 NO Luxury 195 408 3 2 10 2014 2 11 2014 NO Deluxe Suite 295 414 4 2 9 2014 2 10 2014 YES 1 Suite 255 416 5 2 3 2014 2 11 2014 YES 4 Luxury 195 417 6 2 6 2014 2 13 2014 YES 5 Suite 255 421 2 2 7 2014 2 12 2014 NO Basic no view 75 425 5 2 9 2014 2 13 2014 NO Luxury 195 429 4 2 5 2014 2 13 2014 YES 7 Luxury 195 434 4 2 8 2014 2 10 2014 NO Deluxe Suite 295 445 7 2 3 2014 2 13 2014 NO Basic w/view 155 450 4 2 7 2014 2 12 2014 NO Basic w/view 155 451 2 2 5 2014 2 11 2014 YES 2 Luxury 195 461 4 2 4 2014 2 12 2014 NO Luxury 195 469 4 2 6 2014 2 12 2014 NO Suite 255 472 1 2 1 2014 2 11 2014 YES 4 Luxury 195 479 4 2 3 2014 2 10 2014 YES 6 Deluxe Suite 295 503 3 2 4 2014 2 13 2014 NO Basic w/view 155 507 6 2 1 2014 2 11 2014 YES 6 Suite 255 515 2 2 5 2014 2 11 2014 NO Suite 255 521 5 2 3 2014 2 13 2014 NO Basic w/view 155 524 7 2 7 2014 2 11 2014 NO Basic w/view 155 532 4 2 8 2014 2 11 2014 YES 3 Suite 255 535 5 2 7 2014 2 11 2014 NO Basic w/view 155 572 3 2 1 2014 2 12 2014 NO Basic no view 75 574 4 2 10 2014 2 11 2014 NO Luxury 195 580 4 2 10 2014 2 13 2014 NO Basic w/view 155 589 4 2 6 2014 2 13 2014 NO Basic no view 75 590 4 2 3 2014 2 12 2014 NO Basic w/view 155 601 3 2 7 2014 2 13 2014 NO Suite 255 606 7 2 8 2014 2 13 2014 YES 5 Suite 255 608 6 2 6 2014 2 11 2014 YES 5 Basic w/view 155 616 1 2 3 2014 2 12 2014 YES 9 Basic w/view 155 620 5 2 8 2014 2 11 2014 YES 3 Deluxe Suite 295 621 2 2 10 2014 2 12 2014 YES 2 Basic no view 75 622 1 2 2 2014 2 12 2014 YES 7 Basic no view 75 628 7 2 3 2014 2 13 2014 YES 7 Luxury 195 629 5 2 8 2014 2 13 2014 NO Suite 255 631 5 2 8 2014 2 10 2014 YES 2 Basic w/view 155 642 6 2 3 2014 2 11 2014 YES 8 Basic no view 75 643 5 2 9 2014 2 12 2014 NO Suite 255 646 3 2 1 2014 2 10 2014 NO Suite 255 658 3 2 7 2014 2 13 2014 YES 6 Basic w/view 155 667 4 2 3 2014 2 13 2014 NO Luxury 195 684 5 2 3 2014 2 11 2014 YES 8 Basic no view 75 686 4 2 6 2014 2 13 2014 NO Basic w/view 155 688 1 2 4 2014 2 10 2014 YES 6 Basic w/view 155 694 1 2 8 2014 2 12 2014 YES 4 Suite 255 696 6 2 7 2014 2 12 2014 NO Basic no view 75 714 3 2 7 2014 2 12 2014 NO Luxury 195 715 3 2 9 2014 2 13 2014 YES 4 Basic w/view 155 720 2 2 9 2014 2 10 2014 NO Suite 255 742 3 2 3 2014 2 11 2014 NO Deluxe Suite 295 750 6 2 7 2014 2 12 2014 NO Basic w/view 155 753 5 2 6 2014 2 13 2014 NO Basic w/view 155 760 6 2 9 2014 2 10 2014 NO Luxury 195 765 4 2 10 2014 2 13 2014 NO Luxury 195 767 6 2 10 2014 2 11 2014 NO Basic no view 75 769 3 2 9 2014 2 11 2014 YES 1 Luxury 195 787 2 2 10 2014 2 11 2014 YES 1 Luxury 195 802 5 2 3 2014 2 13 2014 YES 9 Basic w/view 155 809 3 2 8 2014 2 13 2014 NO Suite 255 841 7 2 1 2014 2 12 2014 NO Basic w/view 155 847 1 2 1 2014 2 12 2014 NO Basic w/view 155 853 4 2 5 2014 2 11 2014 NO Basic w/view 155 867 4 2 2 2014 2 11 2014 NO Suite 255 871 3 2 8 2014 2 11 2014 NO Basic w/view 155 872 5 2 8 2014 2 11 2014 NO Suite 255 875 4 2 1 2014 2 11 2014 NO Luxury 195 879 5 2 2 2014 2 11 2014 YES 4 Suite 255 888 3 2 5 2014 2 11 2014 YES 5 Basic no view 75 890 3 2 7 2014 2 12 2014 NO Suite 255 899 2 2 9 2014 2 12 2014 YES 3 Deluxe Suite 295 903 1 2 8 2014 2 11 2014 YES 3 Luxury 195 905 7 2 2 2014 2 13 2014 NO Basic w/view 155 914 3 2 4 2014 2 12 2014 NO Suite 255 920 6 2 10 2014 2 12 2014 NO Suite 255 938 2 2 7 2014 2 10 2014 NO Suite 255 952 3 2 6 2014 2 13 2014 NO Suite 255 961 6 2 10 2014 2 11 2014 YES 1 Basic w/view 155 966 3 2 10 2014 2 13 2014 NO Deluxe Suite 295 967 4 2 7 2014 2 11 2014 NO Basic w/view 155 970 2 2 5 2014 2 12 2014 NO Basic no view 75 971 2 2 4 2014 2 12 2014 NO Basic w/view 155 976 5 2 4 2014 2 12 2014 YES 6 Suite 255 984 6 2 9 2014 2 12 2014 NO Basic no view 75 985 2 2 8 2014 2 12 2014 YES 3 Deluxe Suite 295 988 2 2 5 2014 2 12 2014 NO Suite 255 989 4 2 4 2014 2 12 2014 YES 8 Luxury 195 990 6 2 8 2014 2 11 2014 NO Basic w/view 155 996 7 2 3 2014 2 10 2014 NO Deluxe Suite 295 998 4 2 10 2014 2 12 2014 YES 2 Deluxe Suite 295 1003 3 2 10 2014 2 12 2014 YES 1 Deluxe Suite 295 1005 5 2 3 2014 2 11 2014 NO Deluxe Suite 295 1013 2 2 4 2014 2 11 2014 NO Basic w/view 155 1021 2 2 7 2014 2 11 2014 NO Basic no view 75 1027 5 2 8 2014 2 11 2014 NO Suite 255 1029 5 1 31 2014 2 12 2014 NO Suite 255 1031 1 2 2 2014 2 11 2014 YES 7 Suite 255 1035 1 2 6 2014 2 11 2014 NO Luxury 195 1077 2 1 31 2014 2 10 2014 NO Suite 255 1081 2 2 5 2014 2 13 2014 NO Basic no view 75 1083 2 2 3 2014 2 10 2014 YES 2 Basic w/view 155 1084 2 2 6 2014 2 13 2014 NO Basic w/view 155 1086 6 2 9 2014 2 12 2014 YES 2 Suite 255 1087 5 2 7 2014 2 11 2014 YES 4 Luxury 195 1091 5 2 8 2014 2 12 2014 YES 2 Basic w/view 155 1092 5 2 8 2014 2 13 2014 YES 1 Basic w/view 155 1094 7 2 10 2014 2 12 2014 NO Suite 255 1097 5 2 4 2014 2 12 2014 NO Luxury 195 1099 7 2 9 2014 2 10 2014 YES 1 Basic w/view 155 1110 6 1 31 2014 2 13 2014 YES 8 Basic w/view 155 1118 2 2 6 2014 2 12 2014 YES 3 Deluxe Suite 295 1120 4 1 31 2014 2 13 2014 YES 5 Basic w/view 155 1121 6 2 2 2014 2 12 2014 NO Suite 255 1136 4 2 2 2014 2 12 2014 NO Suite 255 1137 7 2 7 2014 2 13 2014 NO Suite 255 1141 1 2 5 2014 2 12 2014 YES 2 Luxury 195 1148 6 2 6 2014 2 10 2014 YES 4 Basic w/view 155 1152 5 2 3 2014 2 11 2014 YES 1 Basic no view 75 1170 3 2 9 2014 2 12 2014 NO Luxury 195 1173 7 2 4 2014 2 13 2014 NO Basic w/view 155 1179 4 2 4 2014 2 13 2014 YES 8 Basic no view 75 1182 4 2 8 2014 2 12 2014 NO Basic w/view 155 1198 5 2 6 2014 2 12 2014 YES 1 Luxury 195 1200 5 2 2 2014 2 10 2014 NO Basic no view 75 1201 6 2 3 2014 2 12 2014 YES 9 Basic no view 75 1205 1 2 8 2014 2 12 2014 NO Suite 255 1207 6 2 6 2014 2 10 2014 YES 4 Basic w/view 155 1211 6 2 2 2014 2 11 2014 YES 9 Basic no view 75 1212 5 2 6 2014 2 13 2014 YES 1 Deluxe Suite 295 1215 6 2 2 2014 2 11 2014 YES 2 Basic w/view 155 1243 6 2 6 2014 2 13 2014 YES 2 Deluxe Suite 295 1244 3 2 5 2014 2 13 2014 NO Basic w/view 155 1250 3 2 9 2014 2 11 2014 YES 2 Suite 255 1254 5 2 3 2014 2 13 2014 YES 6 Luxury 195 1255 2 2 6 2014 2 12 2014 YES 1 Luxury 195 1261 4 2 9 2014 2 10 2014 NO Suite 255 1262 7 2 3 2014 2 11 2014 YES 8 Luxury 195 1266 5 2 2 2014 2 13 2014 YES 8 Basic no view 75 1276 2 2 1 2014 2 11 2014 YES 3 Basic w/view 155 1285 5 1 31 2014 2 11 2014 NO Deluxe Suite 295 1291 1 2 6 2014 2 10 2014 YES 4 Basic no view 75 1294 6 2 8 2014 2 13 2014 YES 5 Suite 255 1298 7 2 7 2014 2 11 2014 NO Basic w/view 155

30. 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 r ate a. Examine the raw data file Hotel.dat and read it into SAS b. Create date variables for the check-in and check-out dates, and format them to display as readable dates Create a variable that calculates the subtotal as the room rate times the number of days in the stav, plus a per person rate ($10 per day for each person beyond one guest), plus an Internet service fee ($9.95 for a one-time activation and $4.95 per day of use). 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 c. d. 30. 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 r ate a. Examine the raw data file Hotel.dat and read it into SAS b. Create date variables for the check-in and check-out dates, and format them to display as readable dates Create a variable that calculates the subtotal as the room rate times the number of days in the stav, plus a per person rate ($10 per day for each person beyond one guest), plus an Internet service fee ($9.95 for a one-time activation and $4.95 per day of use). 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 c. d