About vkievsky

Cynthia_sas · ‎03-21-2014

Hi: I suspect that you tried to WRITE to the LEARN library. So the problem isn't your LIBNAME statement. The problem is how you are USING the LIBNAME. See example #2 in the screen shot. As long as you READ from the LEARN location (example #1, #3), you will be OK. But you do not have WRITE access to any of the data locations on the server. So if there is an example in the book that shows something like: DATA LEARN.NEW; ** some code; RUN; Then you will have to change it to your user library or to the WORK library to test file creation: DATA WORK.NEW; ** some code; RUN; Here is some example code that I used for the attached screen shot. I can replicate your ERROR message just by trying to write to the LEARN library -- which fails because NOBODY has WRITE access to the OnDemand server except to your user folder. You will have to write to your user folder/directory (see Example #4). The tutorial on this web page explains how to use the OnDemand server with Book data. (SAS OnDemand for Professionals Customer Support tab -- see videos) Cynthia libname learn '/tutorials/bookdata/learning_sas_by_example'; **1) reading FROM the LEARN library; data test; set learn.bicycles; run; ** 2) trying to write to the LEARN library; ** will generate an error; data learn.new; set sashelp.class; run; ** 3) again, reading FROM the LEARN library; proc contents data=learn._all_; run; **4) write to user directory, called MYPLACE; libname myplace '~/user'; data myplace.new; set learn.bicycles; run;

Cynthia_sas · ‎03-16-2014

Hi: You can read Excel files, if you use the "internal EG method" of FILE --> IMPORT DATA choice on the EG File menu. There are a limited number of Excel files on the server that can be used with the EG classes. However, when you use FILE --> IMPORT DATA, you are *NOT* using the LIBNAME engine or PROC IMPORT (which need SAS/ACCESS pieces that you do not have) when you are on the UNIX server. The IMPORT DATA item uses the Microsoft ACE engine to allow EG to build a DATA step program, which reads the embedded data that the ACE engine takes out of the workbook and embeds in the program. As it shows on the screen shot of Step 4, since the SAS OnDemand server is a UNIX server, you do not have the pieces of SAS/ACCESS for PC Files that are needed to read Excel files directly with the LIBNAME engine or PROC IMPORT. I don't understand what you mean by "ch.5, p.181 of EG 6.1" -- what is name of the book or course you are using with SAS OnDemand for Professionals?? Is it the course Enterprise Guide 1: Querying and Reporting or the SAS Press book Little SAS Book or ??? In our e-learning courses, for the programming classes, we generally recommend that you skip over any of the exercises that involve using the LIBNAME engine or PROC IMPORT, since those will not work on the SAS OnDemand for Professionals server. There is an XLSX file called employee_info.xlsx in the ECEG151 folder on the SAS OnDemand for Professionals server. You can find it by following this path (clicking each folder to expand): SASApp server, then FILES, then BOOKDATA, then ECOURSES, then ECEG151. You can use the FILE-->IMPORT DATA technique to import employee_info.xlsx file. See the 4 steps attached. cynthia

Cynthia_sas · ‎03-16-2014

Hi: When you use the SAS OnDemand for Professionals license to access SAS on the "cloud" server, you CANNOT read from your local C: drive. That "extra" information appended to the FILENAME is the UNIX directory on the OnDemand server that is your "default" location. Anytime SAS OnDemand for Professionals reads a data file, it looks in the server default location, which is /sso/biconfig/930/Lev1/SASApp -- note how the name of the server in the screen shot is SASApp. Depending on which book you are using or which course you are taking, the FILENAME statement or INFILE statement would be different. I do not recognize the name filename ch5_154 'C:\SAS_OnDemand_for_Professionals\Raw_files\ch5_154.txt'; as belonging to one of the books that is currently loaded on the server, which could be problematic for you if your data is *NOT* loaded on the OnDemand server. What book are you using? As you can see in the second screen shot, there are a limited number of books loaded on the server. But, I wanted to show that data could be read from the server, given the right location. So, instead, my code below reads the CITYDATA.DAT file that is in the Certification Prep Guide directory, as shown in the screen shot: data work.citypop; length city $25; infile '~/bookdata/sas_cert_prep_guides/citydata.dat'; input city $ pop70 pop80; run; proc print data=work.citypop; run; OR filename cpop '~/bookdata/sas_cert_prep_guides/citydata.dat'; data work.citypop2; length city $25; infile cpop; input city $ pop70 pop80; run; proc print data=work.citypop2; run; According to the guidelines for SAS OnDemand for Professionals, you CANNOT read your personal C:\ drive files. See these links: SAS OnDemand for Professionals (sentence that starts: Note: SAS OnDemand for Professionals: Enterprise Guide does not have the capability for uploading of personal data.) or SAS OnDemand for Professionals (FAQ about the data) The only courses and books that work with the SAS OnDemand for Professionals server are the ones listed here (SAS OnDemand for Professionals [Learning Options tab]). The only exception to this is if you are using a similar license called SAS OnDemand for Academics, where your professor can load data for his/her course onto the server. If this is your usage scenario, then your instructor should give you the correct *server* location (not C: drive location) for the uploaded data. cynthia

Online Status	Offline
Date Last Visited	‎03-20-2018 08:25 PM

Error running LIBNAME statement

reading Excel file into SAS OnDemand for Professinals

problem with reading external file

Re: Error running LIBNAME statement

Re: reading Excel file into SAS OnDemand for Professinals

Re: problem with reading external file