06-26-2012 04:52 PM
I successfully created a multisheet excel with the help of various resources available in SAS support website. While i was formatting the look of the output i am facing a difficulty.
In the below picture i was not able to generate the AAAA row. Any ideas would be very helpful. I tried the title option but not able to change the title styles and also it is giving an additional one line gap. Please let me know how i can achieve the below format. I am very much new to SAS.
06-26-2012 05:37 PM
Is this what you want? Title will automatically take two rows though:
ods listing close;
options ( embedded_titles ='yes'
proc print data=sashelp.class;
ods tagsets.excelxp close;
06-27-2012 09:35 AM
I tried title 'AAAAA' but i am not sure how to change the style of the title element. If you know how to control the style of the title i would be happy to use that in my code.
06-28-2012 05:06 PM
Well, if the present factory styles can't meet your need, you probably need to create your own style. And this topic is too big to be addressed in several sentences. Please do a search on proc template and ODS styles.
Also, although 'options' seem to be universal, 'styles' are not. You would only see them working on proc print, report and tabulate. So you are using something else other than these 3 procs to output, forget about styles.