BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
weavern
Calcite | Level 5

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
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.

View solution in original post

6 REPLIES 6
Panagiotis
SAS Employee

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
Calcite | Level 5

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
Super User
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
Calcite | Level 5

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
Super User
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
SAS Employee

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

5 Steps to Your First Analytics Project Using SAS

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.

Discussion stats
  • 6 replies
  • 959 views
  • 0 likes
  • 3 in conversation