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 POsitive Sign.JPG](https://communities.sas.com/t5/image/serverpage/image-id/18470iDB35FC12C0043344/image-size/medium?v=v2&px=400)
When we load the data set to SAS VA, we get the foolowing error:
![VA Positive Sign.JPG VA Positive Sign.JPG](https://communities.sas.com/t5/image/serverpage/image-id/18473iC67FBAB4A9D91525/image-size/large?v=v2&px=999)
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.