BookmarkSubscribeRSS Feed
SASUser_86
Calcite | Level 5

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.

1 REPLY 1
SASKiwi
PROC Star

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

 

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 747 views
  • 1 like
  • 2 in conversation