ODS Excel

DLROW — Tue, 05 Feb 2019 16:38:22 GMT

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;

Re: ODS Excel

SuryaKiran — Tue, 05 Feb 2019 17:23:29 GMT

Please provide some sample data in the form of a data step.

Re: ODS Excel

DLROW — Tue, 05 Feb 2019 22:53:42 GMT

Hi,

I used options- (ROW_HEIGHTS='20,0,0,0,0,0,0') to reduce the cell height and style(header)= (tagattr='Wrap:no') to wrap the fiield 'country'. It worked. Thanks!

topic Re: ODS Excel in ODS and Base Reporting

ODS Excel

Re: ODS Excel

Re: ODS Excel