About SAS Libraries

[赵家钧]

I'm learing how to master sas enterprise guide with the help of the sas official course SAS® Programming 1: Essentials. But, in one course activity, I find the temporary library created by me can be conducted but can't be opened and read directly (using proc print and contents is available still) . I'm feeeeeeeel very puzzled, coming here for professional help. I'm wondering if there is a mistake with my software or my software settings?

[Kurt_Bremser]

Please show us the code (and the corresponding log) that does not work as intended. See my footnotes for hinst on posting code, logs and data.

[赵家钧]

libname NP xlsx "D:\SAS Learning Windowing\EPG194\data\np_info.xlsx";
options validvarname=v7;

Above is my code. I run it. And the 'NP' Library is created successfully and can be used in further programs, but I can't open and read the contents directly by simply doulbe-click.

[Cynthia_sas · Accepted solution]

Hi:
In that example in Programing 1, you are using the LIBNAME engine for Excel files to explore the Excel workbook. If you are using the Enterprise Guide instructions, you should have used &PATH.

If you followed the directions for making the data for class, you should have created an EG project with an AUTOEXEC Process Flow. The way the Enterprise Guide instructions work in Programming 1 is that you run the AUTOEXEC to make the data files EVERY time you open the project.

We make the files for Programming 1, by default, in your WORK folder, every time you open the project. And we make a helper macro variable, &PATH, that stores the location of your WORK library. In the solution to that Activity, you are instructed to use &PATH.

Did you follow the directions to make an AUTOEXEC folder in your EG project? Or did you change the data creation program? Frequently, EG users cannot read from files stored on their local computer. This is why the Course Overview instructions for EG make the data in WORK every time you open the project that you set up in the data creation step.

Cynthia

[赵家钧]

Thank you very much！It occurred to me that I just forgot that Excel files cannot be opened in SAS when I review the whole videos. Still thanks a lot!

[赵家钧]

After I double click,the software goes out of control and a circle keep going. I just lose control of the software except shuting it down violently.