- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-04-2021 10:50 AM
(986 views)
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
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;