*hand8.txt;

DATA TRAVEL;
 INFILE 'A:\TRAVEL.TXT';
 LENGTH DEST $12.;
 INPUT AIR REGION DEST $ & NAME $ HOTEL;
PROC REPORT HEADLINE HEADSKIP NOWD LS=64;
 COLUMN   DEST  NAME;
 DEFINE DEST    / GROUP 'DESTINATION';
 DEFINE NAME    / ACROSS 'TRAVELER NAME'  ;
 RBREAK AFTER   /DUL DOL SUMMARIZE;
 TITLE 'FREQUENCY OF VISITS';
RUN;


options missing='0';
DATA TRAVEL;
 INFILE 'A:\TRAVEL.TXT';
 LENGTH DEST $12.;
 INPUT AIR REGION DEST $ & NAME $ HOTEL;
PROC REPORT HEADLINE HEADSKIP NOWD LS=74;
 COLUMN   DEST  NAME n;
 DEFINE DEST    / GROUP 'DESTINATION';
 DEFINE NAME    / ACROSS 'TRAVELER NAME'  ;
 define n       / 'TOTAL' format=9.;
 RBREAK AFTER   /DUL DOL SUMMARIZE;
  COMPUTE AFTER;
   DEST='TOTAL';                            *adds the word TOTAL to bottom line;
  ENDCOMP;
 TITLE 'FREQUENCY OF VISITS';
RUN;