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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.