04-11-2013 03:42 PM
I'm having a problem with a picture format that I haven't been able to find a solution to in SAS documentation. I'm using a picture format to format visual acuity values (eg, 20/20 vision, 20/30 vision). This way the value of the variable is the denominator and I can keep it as numeric and sort properly, etc. The code is something like:
proc format; picture vaf low-high="0000" (prefix='20/'); run;
The problem comes in when I have a separate category for "Worse than 20/200 vision". This needs to be formatted as such (or similar) BUT when I use the picture format, such as:
picture vaf 201-high="Worse than 20/200" low-200="0000" (prefix='20/');
Since it's a picture format, the "20/200" portion of the "worse than 20/200" format is read as digit selectors and I get values like:
Is there anyway to mask or hide the "20/200" portion of this format to tell SAS to treat it as a string rather than digit selectors? Any alternative solutions to this formatting issue are also welcome!
Thanks in advance for anyone who can help!
Need further help from the community? Please ask a new question.