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;
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
@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.
so, the accepted solution is: you can't use UNICODE in a picture format, correct?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.