topic How to set custom Y Axis interval in SAS VA Graph Builder? in SAS Visual Analytics

How to set custom Y Axis interval in SAS VA Graph Builder?

MoMoMay — Fri, 12 Jul 2019 03:11:00 GMT

I want to create customized interval for the Y axis scale on my line chart. Under the option of graph builder, I can choose the Y axis range. However, it just offered the minimum and maximum. I want to disable the auto scale of Y axis and set the customized interval of the Y axis scale. For example, it auto scale the interval of Y axis is 5...10...15...20...etc. I want to change the interval to be a 2..4...6..8...10...etc. How can I do it? Thanks

Re: How to set custom Y Axis interval in SAS VA Graph Builder?

z525541 — Sat, 16 Apr 2022 08:46:27 GMT

I need help with this too!

Re: How to set custom Y Axis interval in SAS VA Graph Builder?

acordes — Tue, 19 Apr 2022 14:52:12 GMT

You can achieve this with user-defined formats.

First run the code, then enter manage environment with admin rights.

assume super-user role and create empty format lib, copy the code-created format to it.

call the format when promoting the table.

now in VA you can see the correct behaviour of the variable (according to the format).


proc casutil;
deletesource casdata="myFmtLib.sashdat" incaslib="public";
run;

proc format library=work.formats casfmtlib="myFmtLib";
value mmonth
0-6 = "0"
6-18="12"
18-30 = "24"
30-42="36"
42-54 = "48"
54-66="60"
66-78 = "72"
78-90="84"
other=">90"
;
run;


cas mysession savefmtlib fmtlibname=myFmtLib         /* 5 */
   table="myFmtLib.sashdat" caslib=PUBLIC replace;

cas mysession addfmtlib fmtlibname=myFmtLib     /* 2 */
   table="myFmtLib.sashdat" caslib=PUBLIC replacefmtlib;

cas mysession promotefmtlib fmtlibname=myFmtLib REPLACE;

data public.rema1(promote=yes);
set casuser.rema;
FORMAT f_meses_efectivos mmonth_copy.;
f_meses_efectivos=meses_efectivos;
run;