/*soh*********************************************************************************
  Program name   : template.sas
                                                                  
  Program Path   : /home/yun/bkup
                                                                  
  Project Number : N/A
                                                                  
  P.I.           : N/A
                                                                  
  Contact        : N/A
                                                                  
  Programmer     : Lingsong Yun
                                                                  
  Creation date  : 05-Mar-2006
  
  Purpose        : Customize output using ODS 
 
  Methods        : 1) Define table templates
                   
  Input files    : N/A

  Output files   : N/A
                                                                  
  Notes          : tab1: 
*eoh**********************************************************************************/

/*================================================
  
  Define table template

  ================================================*/

ods path work.temptemp (update)
         sasuser.templat (update)
         sashelp.tmplmst (read);

proc template;
   define table tab1;

      ***define macro variables used in headers and footers***;
      mvar title1 title2 title3 foot1 foot2 foot3 foot4 foot5;

      ***colum header to be changed in each table***;
      dynamic colheader;

      column var1 var2;

      ***declare table headers (titles of table) and footers (footnotes of table)***;
      header h1 h2 h3 h4 ;
      footer f1 f2 f3 f4 f5;
      classlevels;

      ***define headers***;
      define h1;
         text title1;
         just=l;
         style=header{font_face="Arial Narrow" font_size=2 font_weight=bold htmlstyle="text-align:left"};
                                                                            
         split="$";
      end;

      define h2;
         text title2;
         just=l;
         style=header{font_face="Arial Narrow" font_size=2 font_weight=bold };
         split="$";
      end;

      define h3;
         text title3;
         just=c;
         style=header{font_face="Arial Narrow" font_size=2};
      end;

      define h4;
         text ' ';
      end;


      ***define id column (column 1) of the table***;
      define column var1;

*------------------------------------------------------;
         generic;
	 ID; *bolded and center;
         blank_dups; *if duplicate, then blank ----because it is id variable;
         just=l; *in effect in HTML but not in Excel;
*------------------------------------------------------;

         define header colhead;
            text colheader;
            just=c;
            vjust=center;
            split="$";
         end;
         header=colhead;
         style={cellwidth=3.5in};
      end;

      ***define rest columns of the table***;
      define column var2;
         generic;
         just=c;
         define header colhead;
            text colheader;
            just=c;
            split="$";
         end;
         header=colhead;
         style={htmlstyle="mso-number-format:\@;text-align:center"};*treat as text and in center;
      end;

      
      ***define footers***;

      define f1;
         text foot1;
         just=l;
         style=header{font_face="Arial Narrow" font_size=0.8 htmlstyle="text-align:left"};
         split="$";
      end;

      define f2;
         text foot2;
         just=l;
         style=header{font_face="Arial Narrow" font_size=0.8 htmlstyle="text-align:left"};
         split="$";
      end;

      define f3;
         text foot3;
         just=l;
         style=header{font_face="Arial Narrow" font_size=0.8 htmlstyle="text-align:left"};
         split="$";
      end;

      define f4;
         text foot4;
         just=l;
         style=header{font_face="Arial Narrow" font_size=0.8 htmlstyle="text-align:left"};
         split="$";
      end;

      define f5;
         text foot5;
         just=l;
         style=header{font_face="Arial Narrow" font_size=0.8 htmlstyle="text-align:left"};
         split="$";
      end;
   end;
run;   
      

      
*INITIAL VALUE;
%LET TITLE1=; 
%LET TITLE2=; 
%LET TITLE3=;
%LET FOOT1=; 
%LET FOOT2=;
%LET FOOT3=;
%LET FOOT4=;
%LET FOOT5=;