BookmarkSubscribeRSS Feed
sanjay1
Obsidian | Level 7

Hi SAS Experts,

 

Is there is anyway to display  the values within in the bars of waterfall chart.  Below is my data and code.

 

data new;
input amount name$;
informat amount dollar10.;
format amount dollar10.;
datalines;
10004556 a1
56477557 a2
582578977 a4
575668686 a5
57657888 a6
56454778 a7
5643898968 a8
8643966 a9
567865787 a10
7547785787 a11
;
run;


proc sgplot data=new;
styleattrs datacolors=(CXF98D29 CX404040 CXDF84BA CXFFD923);
waterfall category=name response=amount/ colorgroup=name datalabel DATALABELATTRS=(Size=8 Weight=Bold) dataskin=none finalbarattrs=(color=CXF6B333);
xaxis display=(nolabel) discreteorder=data;
yaxis offsetmin=0;
run;

 

Thanks & Regards,

Sanjay

1 REPLY 1
ballardw
Super User

How do you want to display a value "within a bar" when the Bar is less than a single character thick?

You also would need to consider contrast such as not attempting to display black text on a black (or other very dark color).

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 665 views
  • 0 likes
  • 2 in conversation