topic Re: Problem in Creating Libname ECST142 in SAS Studio

Problem in Creating Libname ECST142

sascoin — Tue, 29 Dec 2020 23:09:12 GMT

Hi Friends

I am using SAS Studio and having problem in creating Library for ECST142. Files are attached.

I have already gone through all the ECST142 related queries in this forum but still struggling. I have also completed step by step instruction by SAS manual but still in vain.

I believe the issue must be in "format" of ECST142 and I have tried dozens of combination for FILEPATH like.....

I lost the whole day banging my head in this stuff.........no clue. Please someone can help?

Thanks

homefolder=\ECST142\data;

C:\Users\RAO\Desktop\ECST142;


C:\Users\RAO\Desktop\ECST142\data;

Desktop\ECST142\data;

Re: Problem in Creating Libname ECST142

ballardw — Tue, 29 Dec 2020 23:39:07 GMT

SAS for some reason does not see that folder.

Reasons in order of frequency of people asking similar questions:

Spelling: one or more components of the path in the Homefolder macro variable are misspelled.

One or more components of the path specified do not exist. (variation on spelling in effect)

The installation you are using does not see that location because of operating system limits such as you are connecting to a server that cannot see your local hard drive or using a system such as SAS University edition which runs in a virtual machine, using Linux path syntax, and has a different mount point such as :/folders/myfolders/ for the start of the path if set up correctly.

You may also find that you desktop is actually on a D:\users\ path depending on installation.

BTW, desktops are lousy places to put data files. Better to learn to use a file manager like Windows Explorer and create and manage your own storage locations. For one thing you can create shorter paths than : users\name\desktop\whatever

Re: Problem in Creating Libname ECST142

sascoin — Tue, 29 Dec 2020 23:53:37 GMT

Hi ballardw

Thanks for your reply and response, but I am sorry that doesnt helped me. I have also used 😧 drive. Maybe this ECST142 thing is far above my IQ. I completed SAS programming Essential without any issue but this thing really stuck. Maybe a video can help.

Thanks again

Re: Problem in Creating Libname ECST142

ballardw — Tue, 29 Dec 2020 23:58:02 GMT

Have you ever used Windows Explorer to find files on your hard drive?

Time to learn.

Show a screen capture of Windows Explorer where it show that folder. NOT the desktop, from Windows Explorer.

Then we may have some additional comments.

Re: Problem in Creating Libname ECST142

sascoin — Wed, 30 Dec 2020 00:06:29 GMT

Thanks for your help. Are you refering to this attached pics.?

Re: Problem in Creating Libname ECST142

SASKiwi — Wed, 30 Dec 2020 01:03:26 GMT

Your screenshot suggests your data is stored on your D drive, not C. Try this home folder:

%let homefolder = D:\SAS STUDIO\ECST142\data;

Re: Problem in Creating Libname ECST142

sascoin — Wed, 30 Dec 2020 02:53:05 GMT

What am I doing wrong ? must be some childish mistake ............need help to figure out . Thanks

Re: Problem in Creating Libname ECST142

SASKiwi — Wed, 30 Dec 2020 03:04:16 GMT

You need to show us the SAS log not the code. You missed the data folder on the end. If you don't trust your typing, copy and paste from what I posted.

Re: Problem in Creating Libname ECST142

sascoin — Wed, 30 Dec 2020 03:13:01 GMT

Sir, here is the log with thanks

Re: Problem in Creating Libname ECST142

SASKiwi — Wed, 30 Dec 2020 03:34:23 GMT

Look at your Server Files and Folders pane. It is telling you that your SAS code is running on a remote SAS server called odaws04-usw2 - not on your PC. The remote SAS server knows nothing about your PC hard drives. To get the program working you are going to have to copy your data onto your remote SAS server. Do you have local SAS help to call on? It would be a lot easier than us trying to guess how your SAS is configured.

Re: Problem in Creating Libname ECST142

sascoin — Wed, 30 Dec 2020 04:59:46 GMT

Not sure what is the issue then.....as I used the same server for EPG1V2 and it went smooth without an inch of problem. anyway thanks for your help.

Re: Problem in Creating Libname ECST142

Tom — Wed, 30 Dec 2020 05:06:40 GMT

Look for the folder on the SAS server using the SAS/Studio interface. When you find it ask for the properties of the folder and copy the path it has on the server into your code.

If you cannot find it and you are trying to follow instructions from a course then make sure you do all of the setup steps before beginning the first lesson.

Re: Problem in Creating Libname ECST142

ballardw — Wed, 30 Dec 2020 15:50:38 GMT

@sascoin wrote:

Not sure what is the issue then.....as I used the same server for EPG1V2 and it went smooth without an inch of problem. anyway thanks for your help.

A secondary issue beside the location of the folder could be folder properties. See the box in the picture with the file details marked "read only"? That

Re: Problem in Creating Libname ECST142

Cynthia_sas — Wed, 30 Dec 2020 17:29:25 GMT

HI:
You cannot use a local drive location with SAS OnDemand for Academics. Please create an ECST142 folder under your main Files (Home) location. Then upload all the files from your D drive location to the corresponding locations up on the OnDemand server. If you used SAS OnDemand for Programming 1, I can assure you that a D drive location would NOT work on the OnDemand server.
Once you have an ECST142 folder on the server, with a data subfolder, then your %LET statement would be something like THIS:
%LET homefolder=/home/<yourUserID>/ECST142/data;

You can verify this by right clicking on the data subfolder up on the server (NOT on your D drive) and then choosing Properties. There is a Location field in the Properties window that will show you the EXACT full server location path you need to use in the %LET statement.
BTW, I believe that you will need to have setup.sas UNDER the ECST142 folder - actually, you should go back and follow the exact setup directions for the SAS OnDemand for Academics server. i am worried that you may have picked another set of instructions to follow.
Cynthia