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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.