Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

The VJUST= style attribute can be used in the HTML, PRINTER (PCL/PDF/PS), and RTF destinations to control vertical justification of a cell. The valid values are T (TOP), M (MIDDLE) and B (BOTTOM). If this style attribute is used to override the default for a cell, the style override is ignored when output is created with the EXCELXP tagset.

To circumvent the problem, use PROC TEMPLATE to create a customized style element with the desired vertical justification setting, and reference that element in the STYLE= option in PROC TABULATE, REPORT, or PRINT. Please see the Full Code tab for an example.

Operating System and Release Information

proc template; 
  define style styles.test; 
  parent=styles.sasweb; 
    style topc from rowheader / 
      vjust=top 
      font_face=Arial 
      font_size=10pt 
      borderwidth=1px; 
  end; 
run; 

ods listing close;
ods tagsets.ExcelXP file="vjust_t.xml" style=styles.test;

proc tabulate data=sashelp.class;
  class age name;
  classlev age / style=topc;
  var height;
  table age*name, height*sum=' '*f=8.;
run;

ods tagsets.ExcelXP close;
ods listing;