topic How to render html cotes in ods pdf in SAS Enterprise Guide

How to render html cotes in ods pdf

RameshReddy — Wed, 28 Dec 2011 12:28:35 GMT

Dear Team,

i have html quotes in text that i want show in proper format thru ods pdf,

below code is located in data set,

As per the calendar of reviews approved by

the Board of Directors of the Bank, the Audit Committee is required to review, on a half-yearly basis, the loss assets

with a balance of `

1.0 million and above in each

account outstanding for more than two years and where legal action has not been initiated.

i want to show this in pdf like below format,

Asper the calendar of reviews approved by the Board of Directors of theBank, the Audit Committee is required to review, on a half-yearlybasis, the loss assets with a balance of `1.0million and above in each account outstanding for more than two yearsand where legal action has not been initiated.

thanks

How to render html cotes in ods pdf

NN — Wed, 28 Dec 2011 18:35:28 GMT

Hi,

I think you should look at ODS PDF TEXT =

and ODS ESCAPECHAR=

It should help in what i think you are trying to achieve.

How to render html cotes in ods pdf

RameshReddy — Thu, 29 Dec 2011 11:54:48 GMT

thanks for ur response NN,,but ODS ESCAPER is still showing same status

How to render html cotes in ods pdf

Tom — Thu, 29 Dec 2011 17:04:34 GMT

You cannot render HTML code into PDF with SAS. You could generate an HTML file an use another tool like Adobe Acrobat to convert the HTML into a PDF file.

Now if what you really want to do is display some parts of your PDF file with different fonts then look at this page of tips on using ODS PDF on the SAS website.

http://support.sas.com/rnd/base/ods/odsprinter/

In particular look at this document.

http://support.sas.com/resources/papers/sgf2008/odspdf.pdf

Re: How to render html cotes in ods pdf

Cynthia_sas — Thu, 29 Dec 2011 19:23:33 GMT

Hi,

I'm not entirely sure I understand what the real need is. I do not have either of those fonts on my system, so I could not check the existence of the "grave accent" or the rupee symbol character in the fonts which the OP showed (in the string `1.0 million ). However, in Courier New and Arial and Verdana, the "grave accent" character is Unicode 0060 and the Rupee symbol is Unicode 20A8 in Arial Unicode MS. So if the issue is how to change fonts, that is possible using an ODS ESCAPECHAR and STYLE override. If the issue is how to insert a unicode string, (if the Zurich BT and/or the Rupee Foradian fonts have the grave accent or similar symbol that is needed), then ODS ESCAPECHAR with the UNICODE function allows that.

The code below was used to create the attached screenshot using ODS PDF and SAS 9.3. I attached additional screenshots that show the "grave accent" symbol in 3 different fonts (using Windows Character Map) and also one that shows the Rupee sign as a Unicode character.

cynthia

data longchar;

length longcharvar $500 shortvar $50;

shortvar = '^{unicode 20A8}1.0 million';

longcharvar = catx(' ',

'^{style[font_face="Courier New"]As per the calendar of reviews',

'approved by the Board of Directors}',

'of the Bank, the Audit committee is required',

'^{style[font_face="Courier New"]to review, on a half-yearly basis,}',

'the loss assets with a balance of ^{unicode 0060}1.0 million and',

'above in each account, outstanding, for more than two years and where',

'legal action has not been initiated.');

run;

options nodate nonumber;

ods listing close;

ods escapechar='^';

ods pdf file='c:\temp\insert_unicode_char.pdf' style=journal

bookmarkgen=yes bookmarklist=hide;

proc report data=longchar nowd

style(report)={rules=none frame=void cellspacing=0 width=100%}

style(column)={fontfamily='Verdana, sans-serif' font_size=11pt};

title 'Use Unicode Escapechar to insert grave accent and switch fonts in mid-sentence';

column shortvar longcharvar;

define shortvar / display 'Use Unicode Rupee Symbol';

define longcharvar/ display 'Use Grave Accent';

run;

ods _all_ close;