topic Re: Error: Library name is not assigned in New SAS User

Error: Library name is not assigned

cclm529 — Tue, 10 Nov 2020 19:53:59 GMT

Hi, I'm new to SAS and I'm trying to import local csv file to SAS Studio. But I got the following error.

Re: Error: Library name is not assigned

Reeza — Tue, 10 Nov 2020 20:11:39 GMT

You called your library LIBREF, a bad name overall as that should be a SAS keyword.
You refer to it in the IMPORT proc as CHO though.

Change them to be the same name. Note that your file path is also incorrect, files need to be in myfolders to be imported.

libname CHO '/folders/myfodlers/sasuser.v94';

proc import datafile = '/folders/myfolders/....path to file'
out=cho.data dbms=csv;run;

Re: Error: Library name is not assigned

PaigeMiller — Tue, 10 Nov 2020 20:07:03 GMT

You are trying to use library named CHO, but you have not assigned a libref (which can be done using a LIBNAME statement) for CHO.

Re: Error: Library name is not assigned

Kurt_Bremser — Tue, 10 Nov 2020 20:16:51 GMT

Also note that you should not clutter up the sasuser.v94 directory with data, as it is the directory for your SASUSER library.

Re: Error: Library name is not assigned

cclm529 — Tue, 10 Nov 2020 20:19:32 GMT

Thank you! I'm actually trying to import from my local file. I don't know if I'm doing it correctly.

Re: Error: Library name is not assigned

Reeza — Tue, 10 Nov 2020 20:31:00 GMT

You are not.
1. Place the file in the myfolders folder you created.
2. Create a library reference to that ~~file~~ folder
3. Import that file referring to it using the /folders/myfolders notation as the Virtual Machine

Your code should look like below with the correct path and folder name. Note that your file and folder names are case sensitive.

libname myFIles '/folders/myfolders/';

proc import datafile = '/folders/myfolders/demo.csv' out=myFiles.demo dbms=csv replace; run;

Re: Error: Library name is not assigned

Aziegbemi — Wed, 08 Feb 2023 11:34:41 GMT

This is what I did in the following steps:

1) using the import icon, import the file from your local drive to the "Server Files and Folders"

2) Under the "Server Files and Folders", click on NEW, click IMPORT DATA, click SELECT FILE

3) You will see a drop-down that contains the file you locally imported, select that file and click OPEN

4) Copy the file path

FILENAME REFFILE '/home/u63000000/newfile.xlsx';

from the import data output

5) Paste this file path to your

datafile = '/home/u63000000/newfile.xlsx'

-you should be all set!

Re: Error: Library name is not assigned

Reeza — Wed, 08 Feb 2023 15:52:02 GMT

The original question references SAS University Edition which no longer exists.

The answer posted is for SAS On Demand (cloud) which does not support direct access to your local files, where as SAS University Edition did.