topic Re: SAS EG License and Excel in Programming 1 and 2

SAS EG License and Excel

nrodrig — Sun, 24 Feb 2019 23:45:54 GMT

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.

Re: SAS EG License and Excel

Cynthia_sas — Mon, 25 Feb 2019 00:29:33 GMT

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

Re: SAS EG License and Excel

VDD — Mon, 25 Feb 2019 00:34:17 GMT

PROC setinit;

run;

Operating System:   LIN X64 .

Product expiration dates:

---SAS Add-in for Microsoft Excel

Re: SAS EG License and Excel

Cynthia_sas — Mon, 25 Feb 2019 15:44:28 GMT

Hi:
Are you trying to ask whether you can take Programming 1 if you have the SAS Add-in for Microsoft Office? Or were you trying to show an example of PROC SETINIT?

If the original poster can explain what version of SAS and/or EG they are running, we may be able to give better advice.

Cynthia

Re: SAS EG License and Excel

Panagiotis — Mon, 25 Feb 2019 15:49:35 GMT

After you run:

proc setinit;
run;

Check the log and let us know your current version: