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;
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!
Please provide some sample data in the form of a data step.
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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.