How to show negative values with parentheses?

[itanid]

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

[acordes]

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;