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
I need help with this too!
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;
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.