Exactly on the server. Can you point me to one of the other interface choices? I did download and install the Oracle Virtual Machine but it turns out that runs Studio and I am using Enterprise Guide. ... View more

I found the location but it seems I can not access it directly. The location is G:\path\filename and that is not listed as a drive on my computer. ... View more

Got it. Only one thing. I had to add the engine XLSX to the LIBNAME line for it to work. Then it worked fine.  In the course, SAS Programming 1: Essentials, Lesson 2: Accessing Data in the Demo: Using a Library to Read Excel Files the speaker shows the actual Excel workbook file along with the sheets in the file. Those were the files I don't see anywhere. Are those Excel files accessible? ... View more

These are the instructions I used for Setup Instructions for your own SAS software. https://vle.sas.com/pluginfile.php/257520/mod_scorm/content/28/setup_eg.htm ... View more

Yes. I followed the instructions for setting up files for Enterprise Guide on my computer. All the steps including running 1egpg194 and 2egpg194 SAS programs. I don't have a library called PG194. I have one called PG1. ... View more

I am going through the: SAS Programming 1: Essential Lesson 2: Accessing Data Using a Library to read Excel Files (note: there are no Excel or csv files available to follow the example. Or I can't find them.) As for current version, I don't see that at the top but under SAS Enterprise Guide>Help>About it says Version 7.13 HF3 (7.100.3.5438) (32-bit) ... View more

Here is the program and the log. Also, this Excel file is the exported Excel version of the Storm_Summary.sas7bdat file. The STORM_SUMMARY is also the name of the sheet in the is workbook. The zip file, coursedata.wk.zip downloaded as part of this course EPG194 did not contain any Excel or csv files as referenced in the course.   OPTIONS VALIDVARNAME=V7; LIBNAME XLCLASS "Z:\My SAS Files\STORM_SUMMARY.xlsx"; PROC CONTENTS DATA=XLCLASS.STORM_SUMMARY; RUN; LIBNAME XLCLASS CLEAR;   LOG: NOTE: Libref XLCLASS was successfully assigned as follows: Engine: XLSX Physical Name: Z:\My SAS Files\STORM_SUMMARY.xlsx ERROR: File XLCLASS.STORM_SUMMARY.DATA does not exist. NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The SAS System stopped processing this step because of errors. NOTE: Libref XLCLASS has been deassigned. ... View more

This is what it appears I have installed. So, I am not sure that meets the requirements you mentioned.   ... View more

I have the exact same issue as the last contributor. It is the EPG194: Lesson 2: of the SAS Programming 1 Essentials. I even get the same Error message when trying to use the same syntax with any Excel local file I have. SAS will create the libname ok but when using the proc statement it does not recognize the sheets within the workbook. ... View more