Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Format not carrying through from EG to VA

Reply
New Contributor
Posts: 3

Format not carrying through from EG to VA

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:

POsitive Sign.JPG

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

VA Positive Sign.JPG

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.

Super User
Posts: 4,023

Re: Format not carrying through from EG to VA

Posted in reply to SASUser_86

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#n1smzfeuhcmcb5n1qfoxg...

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 116 views
  • 1 like
  • 2 in conversation