BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I seem to be having trouble getting a preimage to work with ExcelXP... Is this something that's supported? The code below works wonderfully with pdf and msoffice2k .....no luck with excelxp though.


ods escapechar = '^';
title1 h=6 j=l '^S={preimage="&gbpath\tables\scotiacapital.gif"}';
ods listing close;
ods tagsets.excelxp file='o:\dev\darryl\test.xls';
proc print data = sashelp.class;run;
ods tagsets.excelxp close;
ods listing;
1 REPLY 1
David_SAS
SAS Employee
Darryl,

Microsoft's SpreadSheet ML language, which underlies ExcelXP, doesn't support images. You'll have to fall back to the MSOffice2k tagset if you need images.

-- David Kelley, SAS
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 985 views
  • 0 likes
  • 2 in conversation