topic Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray in SAS Studio

Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

michaelkindo — Sun, 28 May 2017 05:02:53 GMT

Hi,

I am not able to copy & paste the code.

Even though I am typing manually to create orion library I am getting error OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

%let path=FILEPATH\ecprg193;

libname orion "&path";

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Reeza — Sun, 28 May 2017 05:54:40 GMT

What browser are you using?

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

michaelkindo — Sun, 28 May 2017 05:59:42 GMT

internet explorer##- Please type your reply above this line. Simple formatting, no
attachments. ##

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Reeza — Sun, 28 May 2017 06:06:39 GMT

Yeah, try a different browser. Copy and paste issues are common in IE.

Try Chrome or Firefox.

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

michaelkindo — Sun, 28 May 2017 06:39:51 GMT

I tried doing in Chrome, but it's the same.

How about creating orion folder in Library ? I am getting error for the same.

There are four excel files uploaded in files(home) folder.

But when I am trying run the below code

%let path=/home/michael.kindo0/ecprg193;

libname orion "&path";

Getting Notes

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

60 %let path=/home/michael.kindo0/ecprg193;

61 libname orion "&path";

NOTE: Libref ORION was successfully assigned as follows:

Engine: V9

Physical Name: /home/michael.kindo0/ecprg193

63 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Looks like orion is assigned sucessfully.

proc contents data=orion.sales;
run;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

60 proc contents data=orion.sales;

ERROR: File ORION.SALES.DATA does not exist.

61 run;

Please help how to fix this.

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Kurt_Bremser — Sun, 28 May 2017 07:04:48 GMT

@michaelkindo wrote:

I tried doing in Chrome, but it's the same.

How about creating orion folder in Library ? I am getting error for the same.

There are four excel files uploaded in files(home) folder.

But when I am trying run the below code

%let path=/home/michael.kindo0/ecprg193;

libname orion "&path";

Getting Notes

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

59

60         %let path=/home/michael.kindo0/ecprg193;

61         libname orion "&path";

NOTE: Libref ORION was successfully assigned as follows:

       Engine:        V9

       Physical Name: /home/michael.kindo0/ecprg193

62

63         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

75

Looks like orion is assigned sucessfully.

proc contents data=orion.sales;
run;

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

59

60         proc contents data=orion.sales;

ERROR: File ORION.SALES.DATA does not exist.

61         run;

Please help how to fix this.

How did you import the Excel files into SAS?

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

michaelkindo — Sun, 28 May 2017 07:11:57 GMT

Server Files and Folders there is an option called Upload.

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Kurt_Bremser — Sun, 28 May 2017 07:23:40 GMT

SAS works with dataset files that have a format specific to SAS. Dataset files have the extension .sas7bdat and reside in directories that need to have a libname assigned.

Excel files can only be used for import, or you can assign a libname to the Excel file, which allows you to address sheets in the workbook as individual datasets.

So your next step after uploading the Excel files needs to be a import into SAS.

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Reeza — Sun, 28 May 2017 07:38:42 GMT

The course should have instructions on how to set up,datasets.

Re: Demand on Accademics SAS I am unable to copy and paste the code/ getting error for orion libaray

Cynthia_sas — Sun, 28 May 2017 18:47:05 GMT

Hi, when you are using the OnDemand server, you have to follow ALL the directions inside the Course Overview and Data Setup section of the course.

Running the %LET statement and LIBNAME statement is what you do in TASK 1 of the SAS OnDemand instructions. For TASK2, there are instructions for how to create the files used in the course. ORION.SALES is created when you run the program that is found in TASK2 -- if you issue a LIBNAME statement, but do NOT run the program in TASK2, then you will NOT have ORION.SALES.

As for how to import Excel files into SAS. When you get to the lesson on reading Excel files, you are instructed to write the code ,but NOT to run the code because we already know that the PC File Server (which is the method used in the Programming 1 class) is NOT available on the OnDemand server.

cynthia

Please refer to these screen shots.

Here's the warning about NOT running the code to read Excel files when using SAS OnDemand or SAS Enterprise Guide or SAS University Edition:

If you want to read Excel files with the OnDemand server, you'll have to upload the files to the server and then use the XLSX engine to read XLSX files. There have been previous postings about how to do this. Please note, this method is different from what is shown in the Programming 1 lecture.

How to make the data for Programming 1:

Then copy program from Task 2:

Run the program after copying to SAS Studio editor window:

After running see the log:

Results should show PROC CONTENTS: