How to show negative values with parentheses?

itanid — Tue, 04 May 2021 14:50:37 GMT

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

Re: How to show negative values with parentheses?

acordes — Thu, 07 Oct 2021 15:16:13 GMT

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;

topic How to show negative values with parentheses? in SAS Visual Analytics

How to show negative values with parentheses?

Re: How to show negative values with parentheses?