*================================
 prepare
 - pre-specified macro vars
 ================================;

*%let removabledrive=c;
*%let pgmpath=&removableDrive.:\SAS presentation;

%let pgmpath=C:\Documents and Settings\canmvm\Desktop\HUG Presentations\SAS presentation;

%let outpath=&pgmpath;

libname yun "&pgmpath";

*================================
 - options
 - clear title/footnote
 - run programs
 ================================;
title;
footnote;

options nocenter nodate nonumber orientation=landscape linesize=140 pagesize=50 mprint;

ods escapechar='^';

%inc "&pgmpath.\00template.sas";

*=================================
 macro variables 
 - exedate: pgm running date
 - exeday :
 - exetime:
 =================================;
 proc format;
      value exeday 1='Sunday'
                   2='Monday'
                   3='Tuesday'
                   4='Wednesday'
                   5='Thursday'
                   6='Friday'
                   7='Saturday'
             
;
run;
%let exeday=%sysfunc(weekday(%sysfunc(date())), exeday.);
%put &exeday.;

%let exedate=%sysfunc(putn(%sysfunc(date()),date9.));
%put &exedate; 

%let exetime=%sysfunc(putn(%sysfunc(time()), time5.));
%put &exetime;

*===================================
 macro variables
 - html tags: let titles span 5 columns in html/Excel

 ===================================;

 *macro variable for html tags;
 %let tagstart=%str(<tr><td colspan=5 align=left><b>);
 %let tagend  =%str(</b></tr>);

*===================================
 macro variables for general titles
 - non-ODS titles:	&gt1 and &gt2
 - ODS titles:		&odst1 and &odst2
 ===================================;

   *macro variable for 'general title' used in non-ODS output;
   %let gt1=Project : Use ODS html to generate reports (PI: Kathy Sykora);
   /*%let gt2=Prepared: by L YUN at &exetime. on &exedate. (&exeday.);*/
   %let gt2=Date: &exedate. (&exeday.) by L Yun.;

   *macro variable for 'ODS title' used in ODS output;
   %let odst1=&tagstart. &gt1. &tagend.;
   %let odst2=&tagstart. &gt2. &tagend.;
  
*=====================================
 titles used

 =====================================;  

   title1 &odst1.;
   title2 &odst2.;
   title3;