Embeding logo in spreadsheet using sas ! 1

[mehulzip]

I am using ods htmlcss to generate output in excel files. I have logo of my company at the top of it. To make the logo appear in excel, I used the title statement in sas as follows.

title1 "<div ><img src=""name.jpg""></div>";
Now, logo is there. Now I have spreadsheet (.xls file) and logo(.jpg) files separate in one folder. This is good as long as a person opens the spreadsheet on the system where it is stored but if he e-mails spreadsheet to someone, that person won't be able to look up logo on his system. I have to email the attachement of whole folder that has spreasheet and logo together. This doesn't look good to me.
Is there any better way so that I need to email spreadsheet only and still the person who receives it would be able to look up the logo with it ! How can I embed logo with the spreadsheet from SAS !
I hope I made my point clear ! It would be really very nice if anyone can help me in this regard. thanks in advance.

Mehul

 

[ChrisW75]

I'm afraid I've no idea, I've only ever done this the way you mentioned, it wouldn't surprise me if you can't do it. My advice would be to ask SAS Support for a solution, then post their response here.

What version of SAS are you using? I beleive that version 9 now includes a proper Excel ODS engine, whereas in 8 you basically had to create a html, or htmlcss file which SAS could interpret.

 

[mehulzip]

Hey there,
Thanks for the reply. I am using 8.2 version. I have question, I am using some procedures like htmlcss and markup which are experimental release in 8.2. will there any bad effect on the reports if I have to generate reports in production. what could be the precautions that I should take !
I am going to talk to SAS support ppl abt the issue I mentioned b4, let's hope I will have some good stuff on the site.
thanks.
Mehul

 

[ChrisW75]

OK, yeah, we have the same message everytime we run the ODS HTMLCSS procedure. It's not an issue, it just means that SAS doesn't support it. We've not had any untoward issues with it in production, but just bear in mind that testing is essential to make sure that it really does what you think it does. For instance, ODS CSV is a very useful sounding tagset, but there is a gaping hole in it as it doesn't put quotes around text strings leading to problems if one of your text strings has a comma in it. I ended up creating my own version of it to fix that. You can find instructions on how to deconstruct the ODS tagsets at

http://support.sas.com/rnd/base/topics/odsmarkup/tagsets.html

the process is to extract the code of whatever tagset you want to use as your base, then tweak it to fit your needs.


The thing to remember with ODS HTMLCSS is that you are creating an HTML page with a stylesheet that can be stored separately and Excel interprets this into its own format. If you create a table with more than 1000 rows, you are going to be looking at a lot of processing time to convert it. MY advice is to open the document, then save it through Excel as an Excel document before distributing it, if this is feasible. Alternatively, I wrote a short macro to open the file, then embed the stylesheet into the header of the html which sorted the style side, but still won't fix the problem of the picture.

Another alternative is to have the logo in a centrally available place, but still no ideal.

 

[mehulzip]

thanks chris. I appreciated your detail explaination abt the issue.

 

[mehulzip]

Hi chris,
once again, I have a doubt while using htmlcss for excel. I using code for title statement as follows

title1 "<div style=""margin-top:350px;font-size:12pt;font-face:arial;color:black;text-align:left"">company name:XYZ company ID:122342</div>";

I want some space between "company name:XYZ" and "Company ID:122342", what I am getting right now is " company name:XYZ Company ID:122342".
Is there any html tag that I can use in the <div> tag that results in what I want. I already tried <tab> tag but didn't work.
Is there any other way out of this problem.
thanks in advance.
Mehul

 

[ChrisW75]

Look up HTML tags on the internet, I think you maybe want to put in %20 instead of a space, that might work (you sometimes see this in search engine strings when you do a search on multiple words with spaces between, there's a whole load of these alternatives) you'll probably be able to find one for a tab character as well.