Dear all,
I want to rotate column headers (90 deg) in proc report and the output should be in a pdf file. example of my code is as below.
%LET Reports = \\him\DataStore\Internal\HIM_Water_Quality_Administration\GPsites\Catchment;
ODS _ALL_ Close;
ODS ESCAPECHAR = '~';
ODS pdf FILE = "&Reports\test&pdf_file" ;
PROC REPORT DATA=sashelp.cars split='*' spanrows
style (column) = [fontsize=5.5pt /*cellheight=0.15in*/ font=("Arial",18pt,Normal)]
style (header) = [fontsize=5.5pt /*backgroundcolor = lightblue*/ fontweight = bold cellheight = 18.08mm
font=("Arial",18pt,Normal) frame=void htmlstyle="mso-rotate:90; height:50pt"]
style (report) = [fontsize=5.5pt /*cellheight = 0.15in*/ font=("Arial",18pt,Normal) borderColor=BLACK] /*headline ls=100*/;
title1 j=l font=Arial bold height=1.2 cars;
where make in ('Acura', 'Audi');
column make type EngineSize Cylinders Horsepower Weight;
DEFINE make/ 'make' group STYLE(COLUMN) = [cellheight = 0.15IN vjust=middle JUST = left ];
DEFINE type/'type' group STYLE (COLUMN) =[width=15% cellheight = 0.15IN font=("Arial",12pt,Normal) vjust=center];
DEFINE EngineSize/'EngineSize' order DISPLAY STYLE (COLUMN) = [CELLWIDTH = 0.3IN cellheight = 0.15IN JUST = l font=("Arial",12pt,Normal)];
DEFINE Cylinders/'Cylinders' DISPLAY STYLE (COLUMN) = [CELLWIDTH = 0.3IN cellheight = 0.15IN JUST = l font=("Arial",12pt,Normal)];
DEFINE Horsepower/'Horsepower' DISPLAY STYLE (COLUMN) = [CELLWIDTH = 0.3IN cellheight = 0.15IN JUST = l font=("Arial",12pt,Normal)];
DEFINE Weight/'Weight' DISPLAY STYLE (COLUMN) = [CELLWIDTH = 0.3IN cellheight = 0.15IN JUST = l font=("Arial",12pt,Normal)];
RUN;
The below statement yield the desired output, however it is in word not in pdf
ods tagsets.rtf file="&Reports\Blesbokspruit Catchment.pdf"
OPTIONS(TRHDR="\trrh2750"
TROWHDRCELL="\cltxbtlr" ) style=styles.minimal;
