Hi, I need to decrease the verical distance between the top row 1 and row 2 (In excel, 'Instate' and 'outstate' uses two rows). Also, the word country is in double line as shown below.. Please advise. Thanks.
| | Instate | Outstate |
| Paid Month | Instate_Invoice1 | Instate_Invoice1 | Instate_Invoice1 | Outstate_Invoice | Outstate_Invoice | Outstate_Invoice |
Count
ry |
| country1 | country1 | country1 |
ods excel
File=&outfile.
options(sheet_interval='none' sheet_name='by Month' sheet_label=' ' suppress_bylines='yes'
orientation='landscape' fittopage='yes' embedded_titles='no' center_horizontal='yes'
Autofilter="1-15" absolute_column_width='15,15,28,28,15,28,28,15,32,28,15,28,28,15'
/*absolute_row_height='15'*/ /*ROW_HEIGHTS='0,0,0,20,0,0,0'*/ Frozen_Headers='1');
PROC REPORT Data=Prod_Details nowd
style(report)=[borderstyle=solid bordercolor=black BACKGROUND=TRANSPARENT verticalalign=T]
style(header)=[background=CX1F497D color=white fontfamily=calibri fontsize=3.3 textalign= C verticalalign=T cellheight=.1in borderstyle=solid bordercolor=black]
style(column)=[fontfamily=calibri fontsize=2.8 /*textalign=L*/ verticalalign=T borderstyle=solid bordercolor=black cellheight=.1in];
COLUMNS PAID_MONTH
("Instate" Instate_Invoice1 Instate_Invoice2 Instate_Invoice3)
("Outstate" Outstate_Invoice1 Outstate_Invoice2 Outstate_Invoice3)
("country" country1 country2 country3)
("Product" Product1 Product2 Product3)
("ProdPaid" ProdPaid) TOTAL
;
define PAID_MONTH / display'Paid Month';
define Instate_Invoice1 / 'Instate_Invoice1' Format=dollar18.2;
define Instate_Invoice2 / 'Instate_Invoice2' style(column)=[cellwidth=5.5in] Format=dollar18.2;
define Instate_Invoice3 / 'Instate_Invoice3' style(column)=[cellwidth=5.5in] Format=dollar18.2;
define Outstate / 'Outstate_Invoice' Format=dollar18.2;
define Outstate_Invoice2 / ' Outstate_Invoice2' style(column)=[cellwidth=5.5in] Format=dollar18.2;
define Outstate_Invoice3 / ' Outstate_Invoice3' style(column)=[cellwidth=5.5in] Format=dollar18.2;
define country1/ 'country1' Format=dollar18.2;
define country2 / 'country2' style(column)=[cellwidth=6.5in] ;
define country3 / 'country3' style(column)=[cellwidth=6.5in] ;
define Product1 / 'Product' ;
define Product2 / 'Product' ;
define Product3 / 'Product' ;
define ProdPaid / 'ProdPaid' ;
define TOTAL /'Total' Format=dollar18.2 ;
rbreak after / summarize;
compute after;
Paid_Month='Total';
endcomp;
Run;
ods excel close;
