BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
DLROW
Quartz | Level 8

 

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.

 

 InstateOutstate
Paid MonthInstate_Invoice1Instate_Invoice1Instate_Invoice1Outstate_InvoiceOutstate_InvoiceOutstate_Invoice

 

 

Count
ry
country1country1country1

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;

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
DLROW
Quartz | Level 8

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!

View solution in original post

2 REPLIES 2
SuryaKiran
Meteorite | Level 14

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

 

 

Thanks,
Suryakiran
DLROW
Quartz | Level 8

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!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 768 views
  • 1 like
  • 2 in conversation