topic Re: Using unicode in a picture format in ODS and Base Reporting

Using unicode in a picture format

bconner — Mon, 01 Jul 2019 18:10:31 GMT

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;

Re: Using unicode in a picture format

data_null__ — Mon, 01 Jul 2019 18:20:13 GMT

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

Re: Using unicode in a picture format

bconner — Mon, 01 Jul 2019 18:36:36 GMT

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

Re: Using unicode in a picture format

data_null__ — Wed, 03 Jul 2019 13:37:40 GMT

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

Re: Using unicode in a picture format

gabonzo — Tue, 01 Jun 2021 19:28:35 GMT

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