https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295535#M16750 <P>Hi,<BR />&nbsp;Also, you do not show your ODS statements -- I suspect you are using ODS EXCEL because TAGSETS.EXCELXP does not use images. But you could also use ODS HTML or ODS MSOFFICE2K, so without more information about your destination, it is hard to tell.<BR /><BR />Also, you are using an ESCAPECHAR function but do not show your ODS ESCAPECHAR statement:<BR />ods escapechar='^';<BR /><BR />Last, the reason your destination matters is that you have to be sure that your destination supports both ESCAPECHAR and PREIMAGE. So this might be a question for Tech Support. At this point, no one can test similar code because your ODS destination is unknown.<BR /><BR />cynthia</P> Wed, 31 Aug 2016 15:07:30 GMT Cynthia_sas 2016-08-31T15:07:30Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/294868#M16717 <P>In the attached excel spreadsheet I've store a path to a checkbox image ie</P> <TABLE width="1017"> <TBODY> <TR> <TD width="1017"> <P>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</P> <P>Basically Tabel3 will contain the above information. I expect the below on the PDF. This doesn't appear to be a syntax issue,</P> <P>but i could be mistaken. Any suggestions would be appreciated.</P> <P>&nbsp;</P> <P>What I expect is:</P> <P>checkbox image Normal</P> <P>checkbox image Abnormal</P> <P>checkbox image Normal</P> <P>etc.</P> <P>&nbsp;</P> <P>What I'm gettting is:</P> <P>"Normal";</P> <P>"Abnormal_____";</P> <P>etc.</P> <P>&nbsp;</P> <P>The SAS CODE:</P> <P>&nbsp;</P> <P>ods region x=<STRONG>5.0</STRONG>in y=<STRONG>1.5</STRONG>in;</P> <P>&nbsp;</P> <P>proc report data = pg2tabl3 out=testfile nowindows nowd</P> <P>style(report)=[rules=none frame=void cellspacing=<STRONG>0</STRONG> cellpadding=<STRONG>1</STRONG>pt just=l fontsize=<STRONG>3</STRONG>pt]</P> <P>style(header)=[background=white font_weight=bold just=l font_size=<STRONG>5</STRONG>pt];</P> <P>column table3;</P> <P>define table3 / '* (Mandatory - Complete at least one system)' style(column)=[cellwidth=<STRONG>3.0</STRONG>in] ;</P> <P>rbreak after / summarize;</P> <P>compute table3;</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'style= [font_size=9pt vjust=middle cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>if table3 ^= ' ' then</P> <P>call define (_row_, 'Style', 'Style= [font_size=9pt vjust=center cellwidth=3.0in ]');</P> <P>endcomp;</P> <P>Run;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> </TD> </TR> </TBODY> </TABLE> Mon, 29 Aug 2016 15:41:44 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/294868#M16717 nupedoc79 2016-08-29T15:41:44Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/294935#M16721 <P>Are you expecting to get an actual Image or the text "checkbox image Normal"?</P> <P>&nbsp;</P> <P>I do not see anything in that Proc Report code that references any images.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.</P> <P>&nbsp;</P> <P>If you want to post example data best is a datastep. You can generate that by following the information in this link.</P> Mon, 29 Aug 2016 20:19:50 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/294935#M16721 ballardw 2016-08-29T20:19:50Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295005#M16725 <P>Thanks for the reply.&nbsp; The excel file contains the below statements which are stored in the SAS dataset referenced in the Proc Report statemtent.</P> <TABLE width="1017"> <TBODY> <TR> <TD width="1017">Table3</TD> </TR> <TR> <TD width="1017">Blood Pressure _______________________ Pulse________ Temp_______F/C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight _____lb/kg&nbsp; Height ________in/cm BMI____________&nbsp;&nbsp;&nbsp;&nbsp;</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> <TR> <TD>"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Normal}";</TD> </TR> <TR> <TD>&nbsp;"^{style [ preimage='\\leto\Health Services\Revenue Management\Risk Analytics\Care\PA\2016\Models\Dev-AA\BH\Logo\checkboxv1.png']Abnormal______}";</TD> </TR> </TBODY> </TABLE> Mon, 29 Aug 2016 23:40:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295005#M16725 nupedoc79 2016-08-29T23:40:33Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295089#M16730 <P>I'm expecting a a graphic checkbox next to the words Normal and Abnormal. The variable Table3 on the Proc Report will translated to each of the style statements. The style statements are stored in the sas dataset reference in the Proc Report logic.</P> Tue, 30 Aug 2016 09:23:06 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295089#M16730 nupedoc79 2016-08-30T09:23:06Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295336#M16744 <P>Instead of many repeats of a JPG how about inserting a UNICODE 2610 character?</P> Tue, 30 Aug 2016 21:46:34 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295336#M16744 ballardw 2016-08-30T21:46:34Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295535#M16750 <P>Hi,<BR />&nbsp;Also, you do not show your ODS statements -- I suspect you are using ODS EXCEL because TAGSETS.EXCELXP does not use images. But you could also use ODS HTML or ODS MSOFFICE2K, so without more information about your destination, it is hard to tell.<BR /><BR />Also, you are using an ESCAPECHAR function but do not show your ODS ESCAPECHAR statement:<BR />ods escapechar='^';<BR /><BR />Last, the reason your destination matters is that you have to be sure that your destination supports both ESCAPECHAR and PREIMAGE. So this might be a question for Tech Support. At this point, no one can test similar code because your ODS destination is unknown.<BR /><BR />cynthia</P> Wed, 31 Aug 2016 15:07:30 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Why-Checkbox-graphic-Isn-t-Displaying/m-p/295535#M16750 Cynthia_sas 2016-08-31T15:07:30Z