Programming 1: Data Setup Errors using Enterprise Guide 7.1

[cknepp]

Hi there!

I have followed the EG Setup instructions and I am receiving error messages when I run the second program, _2epg194.sas.  The log shows the following:

ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
WARNING: Libname XL is not assigned.
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
WARNING: Libname XL is not assigned.
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libname XL is not assigned.
WARNING: Libname XL is not assigned.
ERROR: The XLSX engine cannot be found.
ERROR: Error in the LIBNAME statement.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
ERROR: Libname XL is not assigned.
WARNING: Libname XL is not assigned.
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST.
Number of names found is less than number of variables found. 
Number of names found is less than number of variables found. 

What am I doing wrong?

Thanks!

Cass

[Reeza]

You probably do not have the appropriate license to do that portion of the course. This unfortunately means you'll be skipping it. Any company that doesn't buy that component though doesn't really know what they're doing with SAS because it's core to working with data.

[Panagiotis]

I recommend completing the course using SAS On Demand for Academics (cloud based, only need to sign up) or SAS University Edition (requires an install). You will still learn to program, but will be using SAS Studio instead of Enterprise Guide. The code will be identical.

SAS On Demand for Academics

- Select Independent Learners and sign up

SAS University Edition

Here are some videos on how to create the data: How to access data for SAS Programming 1 course.

- Peter