Hi,
I just started the Programming Essential 1 class. I am doing the first practice where we learn to select different output types for our SAS Report. Under Program --> Properties I don't see the option to select "Excel". I wanted to know is there program code we can run to know if the license covers Excel outputs.
Screenshot included in attachment.
Thank you.
Hi:
When I use Enterprise Guide, version 7.15, as shown below, I do see an option for Excel in the Properties window:
This option is generating code for ODS EXCEL, which needs to have SAS 9.4 M2 or higher. I wonder what version of EG and what version of SAS you're using?
You'll need to have 9.4M2 or higher to run the programs in the Programming 1 course, so you might want to check that before you proceed.
There's actually more than one way to send your output from SAS to Excel. Ever since Excel 97, Excel could open an HTML file, so even if you are running an older version of SAS, you can always make an HTML file and then do a File --> Open from inside Excel to open the HTML file. There are other ODS destinations that can create output for Excel. Whether there's a choice inside your Enterprise Guide really depends on your EG version.
Cynthia
PROC setinit;
run;
---SAS Add-in for Microsoft Excel
After you run:
proc setinit;
run;
Check the log and let us know your current version:
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.
For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.
Find more tutorials on the SAS Users YouTube channel.