Program error running _2egpg194 on SAS EG

[weavern]

Hi there,

I am trying to set up the data files at the start of the training, _1egpg194 works with no problems, but _2egpg194 is giving me the below errors. I am using SAS EG in my workplace. I have tried re loading the program and re downloading the zip files, and I have removed spaces from my file pathways. 

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 option nonotes nosource;
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.

Any tips gratefully received!

[Panagiotis]

Hi,

Did you check out the creating data videos? Make sure to watch the Enterprise Guide one.

https://communities.sas.com/t5/SAS-Communities-Library/How-to-access-data-for-SAS-Programming-1-cour...

Also what version of SAS are you running?

Can you run the following:

proc setinit;
run;

Go to the log and find the current version:

Current version: 9.04.01M6P111518

Let us know what current version of SAS you have. That might be the issue.

- Peter

[weavern]

Hi,

I ran 

proc setinit;
run;

but it didn't give me the version number. Using the help/about menu it says Version 7.15 HF8 - so it must be too old. 

Thanks for your help

[Reeza]

You may not have one part of the license required, SAS Access to PC FILES. You can check by running the following:

proc product_status;run;

Check the log for your SAS version, which is more important than your EG version and your modules licensed.

[weavern]

Thanks Reeza, when I do that I get:

For Base SAS Software ...
Custom version information: 9.3_M1
Image version information: 9.03.01M1P110211
For SAS/STAT ...
Custom version information: 9.3_M1
Image version information: 9.03.01M1P110911
For SAS/GRAPH ...
Custom version information: 9.3_M1
For SAS/ETS ...
Custom version information: 9.3_M1
Image version information: 9.03.01M1P110911
For SAS/IML ...
Custom version information: 9.3
Image version information: 9.03.01M0P051111
For SAS/CONNECT ...
Custom version information: 9.3_M1
Image version information: 9.03.01M1P110911
For SAS Table Server ...
Custom version information: 9.3
Image version information: 9.03.01M0P051111
For SAS OLAP Server ...
Custom version information: 9.3
Image version information: 9.03.01M0P051111
For SAS Integration Technologies ...
Custom version information: 9.3_M1
For SAS/ACCESS Interface to Oracle ...
Custom version information: 9.3_M1
For SAS/ACCESS Interface to Sybase ...
Custom version information: 9.3

[Reeza · Accepted solution]

9.3M1 was released in 2011, so you're about a decade out of date. You're also missing SAS/Access to PC FILES, which makes it harder for you to work with Excel files and explain the code issues above. You do not a version new enough to do the course work for those sections. You could use SAS Academics on Demand for the course though.

[Panagiotis]

I agree with @Reeza about using SAS OnDemand for Academics. It is a cloud based version of SAS Studio. You will need internet access, but you can practice everything from the course on it. No installation required. Just an account.

Link: SAS® OnDemand for Academics

If you want SAS locally you can install SAS University Edition. You will need a virtual machine and it does take a few minutes to get it installed. But once it's installed you will not need internet access. Again this uses SAS Studio.

Link: SAS University Edition

While the interface will be different than Enterprise Guide, you will still learn programming which can be utilized on any SAS interface.

- Peter