topic Re: SAS 'tips' on ODS Excel/Y axis labeling with breaks in Y axis in Graphics Programming

SAS 'tips' on ODS Excel/Y axis labeling with breaks in Y axis

LB — Thu, 01 Feb 2018 19:25:02 GMT

So I have two things I am trying to solve-

1) I am using vbarparm. Some of the stack bars have very small numbers and so there is no room for numbers. I am attempting to use tips in an ODS excel document-Is this even feasible? Or does it have to be pdf?

2) Due to the y axis range statement, the y axis labeling seems inoperable. Code and diagram below. Facilities have been deleted.

Thank you.

Lawrence

proc sgplot data=ID_w4g dattrmap=attrmapxe ;

styleattrs DATACONTRASTCOLORS=(black);

vbarparm category=facid response=numx/group=type grouporder=data dataskin=pressed attrid=MYIDXE TIP=(type) tipformat=(auto)
groupdisplay=stack ;

YAXIS LABEL = "ABC" ;
XAXIS LABEL = " " ;
keylegend /title=' ';
yaxis ranges=(0-175 1100-1300);
run;

Re: SAS 'tips' on ODS Excel/Y axis labeling with breaks in Y axis

ballardw — Thu, 01 Feb 2018 20:44:07 GMT

If you have multiple YAXIS statements I think only the last one gets used.

Try a single statement:

yaxis ranges=(0-175 1100-1300) LABEL = "ABC" ;

How are you sending the results to Excel?

Re: SAS 'tips' on ODS Excel/Y axis labeling with breaks in Y axis

LB — Thu, 01 Feb 2018 21:46:22 GMT

I had incidentally figured out the label part-

For excel-just using an ODS destination

ods excel file="/apps/sas/datasets/data137/NCQOS/dev/nc_qos_sandbox/data/cdiff/xxx.xlsx" style=Seaside options(sheet_name="XXX" SHEET_INTERVAL= 'PAGE' autofilter='NO' FROZEN_ROWHEADERS='no'
embedded_titles='yes' embedded_footnotes='yes' embed_titles_once = 'on'
embedded_titles='on'
gridlines='off' START_AT='3,3');

proc report;

etc etc