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;
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?
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.