I´m really at a loss here. I cannot find any information about my problem online. What I want to do is to create an excel-output (xml-file) with 3 sheets. The last two is where the data is, and the first sheet is like an information page and contains no data but only text.
The code below works, and generates 3 sheets with sheet 1 being blank.
How do I proceed from here? How do I insert text in "Sheet 1" and format it the way I want to (titles bold & larger size, etc)?
Thanks for your answer. It was difficult to use the ods text, as you said. I could never get it to write the text string in the output.
If I create a new dataset with multiple observations, and each observation is a sentence, do you know how I can write the proc print code in order to format the observations the way I want? and only show the observations and not the variable name?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.