The SAS Output Delivery System and reporting techniques

How to unwrapped header text in proc report?

Reply
Contributor
Posts: 27

How to unwrapped header text in proc report?

This is the code for my proc report. Somehow the header is cut off and wrapped text. I wanted unwrapped the header but not sure what am I missing in my code.

 

ODS Tagsets.ExcelXP OPTIONS ( orientation='landscape' PAPERSIZE='LEGAL' sheet_name='SAMHSA_SA_OTP_Matched'
FITTOPAGE='yes' AUTOFIT_HEIGHT='yes' FROZEN_HEADERS='5' /*FROZEN_ROWHEADERS='6'*/) style=fancyprinter;


proc report data=SAMHSA_final nofs split=' *'
style(header)=[background = $color. foreground=BLACK BORDERCOLOR=black borderspacing=1 borderwidth=1
font_face=ARIAL font_size=1.5 font_weight=bold /*CELLWIDTH=100pt*/]
style(column)=[font_face=ARIAL font_size=1.5 BORDERCOLOR=BLACK borderspacing=1 borderwidth=1 /*CELLHEIGHT=11pt*/]
style(report)=[BORDERCOLOR=BLACK borderspacing=1 borderwidth=1 ];


column ('Substance Abuse and Mental Health Services Administration (SAMHSA) Provider Listing'
SAMHSA_NAME_1 SAMHSA_NAME_2 SAMHSA_STREET_1 SAMHSA_STREET_2
SAMHSA_CITY SAMHSA_STATE SAMHSA_ZIP SAMHSA_COUNTY SAMHSA_PHONE
SAMHSA_LATITUDE SAMHSA_LONGITUDE SAMHSA_Type_Facility);

 

define SAMHSA_NAME_1/display width=20 style={just=left foreground=black} style(header)={background=CXB0C4DE }
style(column)={background=CXB0C4DE} flow ;
define SAMHSA_NAME_2/display width=15 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_STREET_1/display width=15 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_STREET_2/display width=15 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_CITY/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_STATE/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_ZIP/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_COUNTY/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_PHONE/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_LATITUDE/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_LONGITUDE/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;
define SAMHSA_Type_Facility/display width=10 style={just=left foreground=black} style(header)={background=CXB0C4DE}
style(column)={background=CXB0C4DE} flow;

run;

 

This is the output now: 

Capture.PNG

This is what i want:

Capture2.PNG

Ask a Question
Discussion stats
  • 0 replies
  • 124 views
  • 0 likes
  • 1 in conversation