Hi all,
SAS Viya 3.5 VA 8.5.1
Is it possible show negative value with parentheses?
I can't use NEGPARENw.d format, isn't it?
Can I create a custom format?
thanks
Nicola
I'm sure that you can make it work assigning a format to the VA table from the report.
I paste examplary code that works for me.
After running the code, I go to environment manager / formats. With the admin rights I can elevate the newly created format so that VA can see it.
data fmt;
set fmt3(rename=(VALOR=start LITERAL=label)) end=eof;
retain fmtname "brandy" type "c";
output;
if eof then do;
start=""; Label="";
HLO="O"; output;
end;
run;
cas mysession dropfmtlib fmtlibname=myFmtLib /* 2 */
fmtsearchremove;
proc casutil;
deletesource casdata="myFmtLib.sashdat" incaslib="public";
run;
proc format library=work cntlin=fmt casfmtlib="myFmtLib";
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.