topic Re: Error in reading the data in Programming 1 and 2

Error in reading the data

najiya12 — Thu, 24 Jun 2021 03:08:36 GMT

I am using SAS OnDemand for Academics and my code is generating these errors as attached in the photos. The code is working perfectly with SAS university edition. Any suggestions! Thanks

Re: Error in reading the data

ballardw — Thu, 24 Jun 2021 03:34:55 GMT

Pretty clear, the data sets are not present in the work library that On demand uses. Did you upload the data sets to the server or read a file to create them? On Demand is cloud based and all the data must reside on the server.

Re: Error in reading the data

mkeintz — Thu, 24 Jun 2021 04:40:30 GMT

You have two datasets absent from the work library on the SODA server, as @ballardw noted.

But the second dataset (work.spearman) is missing because the first (work.hale) is missing, therefore preventing proc corr from creating work.spearman from work.hale. You appear to have two symptoms from one problem.

Re: Error in reading the data

Kurt_Bremser — Thu, 24 Jun 2021 04:59:30 GMT

The WORK library is initialized with the start of each SAS session and removed when the session terminates; since the name of the directory is tied to the process number of the SAS process, you cannot re-use it (not with simple means).

You may have run the code that creates WORK.HALE earlier and were then logged out of ODA because of inactivity. You need to rerun that code.

Re: Error in reading the data

najiya12 — Fri, 25 Jun 2021 18:56:07 GMT

How could I reside the data on the server? This is screenshot shows that data in the work library

Re: Error in reading the data

najiya12 — Fri, 25 Jun 2021 18:57:42 GMT

yes agreed. How to solve the first issue

Re: Error in reading the data

Kurt_Bremser — Sat, 26 Jun 2021 05:48:36 GMT

The dataset you inspect in your WORK is named IMPORT, not HALE.

The right side of the screen shows a task definition for importing a file to a dataset, not the dataset itself. You need to execute that task to create the dataset in your current session.

Re: Error in reading the data

najiya12 — Sat, 26 Jun 2021 17:39:29 GMT

Thank you very much @KurtBremser. I was able to create hale in the work library. but then I got different errors as shown in the screenshot attached

Re: Error in reading the data

Kurt_Bremser — Sat, 26 Jun 2021 17:50:18 GMT

Please post logs by copy/pasting the text into a window opened with the </> button. It is much easier for you to do and easier for us to read.

Your dataset was imported with

options validvarname=any;

so the blanks in the variable names were kept.

Either use name literals like

'Clearsky GHI'n

or reimport the data with

options validvarname=v7;

so that blanks in variable names are replaced with underlines during the import.

Re: Error in reading the data

najiya12 — Sat, 26 Jun 2021 19:05:03 GMT

Very Very appreciated! It works great now. thank you very much for the help