02-12-2018 05:48 PM
Hello, I have the following formatting in Enterprise guide:
proc format library=mylib;
low - < 0 = '00000.0'(prefix='-')
0 = '9'
0 < - high = '00000.0' (prefix='+');
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.
02-12-2018 08:07 PM
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: