Using unicode in a picture format

[bconner]

Hi,

Is there any way to use a Unicode character (long dash in this instance) in a picture format for a given value?  I need to replace missing values with it in a report.  The long dash appears in the ods text field but not on the 2nd line of the proc print output.

Thanks!

--Ben

ods html;

ods escapechar='^';

ods text='Test with ^{unicode 2014} character';

proc format;

picture uctest .='^{unicode 2014}' other=[5.1];

run;

data test;

r=1; output; r=.; output;

format r uctest.;

run;

proc print;

run;

[data_null__ · Accepted solution]

use VALUE instead of PICTURE since your picture format has no pictures. Or use PICTURE format option NOEDIT. Look at the documentation.

[bconner]

The (noedit)  option threw an error (ERROR: PICTURE options NOEDIT, FILL=, PREFIX=, and MULT= cannot be used with formats-as-labels or functions-as-labels.), but the value worked fine.

Had tried that earlier but got weird results in the actual report.  Worked fine this time though.

Thanks much!!

--Ben

[data_null__]

---

@bconner wrote:

The (noedit)  option threw an error (ERROR: PICTURE options NOEDIT, FILL=, PREFIX=, and MULT= cannot be used with formats-as-labels or functions-as-labels.), but the value worked fine.

Had tried that earlier but got weird results in the actual report.  Worked fine this time though.

Thanks much!!

--Ben

---

I reckon you did not look at PROC FORMAT documentation as I suggested.

[gabonzo]

so, the accepted solution is: you can't use UNICODE in a picture format, correct?