Desktop productivity for business analysts and programmers

How can i split row and column headings in summary tables in SAS Enterprise guide

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

How can i split row and column headings in summary tables in SAS Enterprise guide

Can anyone tell me how can i split row and column headings in summary tables in SAS Enterprise guide so that i can print them properly? I am looking for a result like split=" " in proc print code.


Accepted Solutions
Solution
‎02-11-2018 12:48 PM
Occasional Contributor
Posts: 8

Re: How can i split row and column headings in summary tables in SAS Enterprise guide

In EG right click on the task the creates the summary and open last submitted code to see the Procedure used to create the table  then check the SAS documentation to add a split, in the Example below for Proc Report the keyword is "spanrows" and specifying the width of the columns:
proc report data=work.TBL spanrows

style(report)={font_face=arial font_size=1 font_weight=bold}

style (column)={font_face=arial font_size=1}

style(header)={font_face=arial font_size=1};

columns  Mnth Supervisor';

define Mnth / group;

define Supervisor / style (column)={CELLWIDTH=2in};

run;

View solution in original post


All Replies
Solution
‎02-11-2018 12:48 PM
Occasional Contributor
Posts: 8

Re: How can i split row and column headings in summary tables in SAS Enterprise guide

In EG right click on the task the creates the summary and open last submitted code to see the Procedure used to create the table  then check the SAS documentation to add a split, in the Example below for Proc Report the keyword is "spanrows" and specifying the width of the columns:
proc report data=work.TBL spanrows

style(report)={font_face=arial font_size=1 font_weight=bold}

style (column)={font_face=arial font_size=1}

style(header)={font_face=arial font_size=1};

columns  Mnth Supervisor';

define Mnth / group;

define Supervisor / style (column)={CELLWIDTH=2in};

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 167 views
  • 1 like
  • 2 in conversation