Format not carrying through from EG to VA

SASUser_86 — Mon, 12 Feb 2018 22:48:29 GMT

Hello, I have the following formatting in Enterprise guide:

proc format library=mylib;
picture positive_sign
low - < 0 = '00000.0'(prefix='-')
0 = '9'
0 < - high = '00000.0' (prefix='+');
run;

The format works in the EG data set:

When we load the data set to SAS VA, we get the foolowing error:

I have attempted to use a case statement with concat to get the positive sign to display with the value. However, that automatically turns the datatype to string when I want my end result to be numeric.

Has anyone encountered this issue? Any help is appreciated. Thank you very much.

Re: Format not carrying through from EG to VA

SASKiwi — Tue, 13 Feb 2018 01:07:40 GMT

The SAS format catalog where positive_sign is stored - in your case the file formats.sas7bcat in your library MYLIB needs to be copied over to the SAS VA folder location as described here:

http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n1smzfeuhcmcb5n1qfoxg1t2o83k.htm

topic Format not carrying through from EG to VA in SAS Visual Analytics

Format not carrying through from EG to VA

Re: Format not carrying through from EG to VA