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?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.