Step-by-Step Programming with Base SAS 9.4

Writing to Separate Data Sets

Writing Observations to Separate Data Sets

Tradewinds Travel wants overall information about the tours that were conducted this year. One SAS data set is needed to contain detailed information about each tour, including the total amount that was spent on that tour. Another SAS data set is needed to contain the total number of bookings with each vendor and the total amount spent with that vendor. Both of these data sets can be created using the techniques that you have learned so far.

Begin the program by creating two SAS data sets from the SAS data set MYLIB.SORTTOUR using the following DATA and SET statements:

data tourdetails vendordetails;
   set mylib.sorttour;

The data set TOURDETAILS will contain the individual ...