Data visualization with SAS programming

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

Reply
Regular Contributor
Regular Contributor
Posts: 159

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

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;

 

 SAS_example.jpg

Super User
Posts: 13,023

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

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?

Regular Contributor
Regular Contributor
Posts: 159

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

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 

 

LB 

Ask a Question
Discussion stats
  • 2 replies
  • 98 views
  • 0 likes
  • 2 in conversation