topic LIBNAME in New SAS User

LIBNAME

cetin — Sat, 16 Nov 2019 15:55:11 GMT

i created pg3 library then i want to import datafile for this library but i take this note

NOTE: Import cancelled. Output dataset WORK.DENEME already exists. Specify REPLACE option to overwrite it.

can u explain this

thanks for a lot

LIBNAME pg3 XLSX "/home/cetinkaygaldurak1/sasuser.v94/ULKE3.xlsx";

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';

proc import datafile=REFFILE

dbms=xlsx

out=pg3.deneme;

sheet=ulke2_s;

run;

Re: LIBNAME

Tom — Sat, 16 Nov 2019 16:03:35 GMT

This seems to be a question about PROC IMPORT. Why did you use LIBNAME as the topic for the question?

From the error message you told PROC IMPORT to create a NEW data set named WORK.DENEME but and it already existed. If you want PROC IMPORT to remove the existing dataset then add the REPLACE option to the PROC IMPORT statement.

The same thing will apply to the SAS code you included if the dataset pg3.deneme (actually worksheet since you are pointing to an XLSX file) already exists.

Re: LIBNAME

cetin — Sat, 16 Nov 2019 16:14:43 GMT

hi tom;

you are right about subject;

you said that "NEW data set named WORK.DENEME" but i didnt use work i used pg3 library pg3.deneme

so pg3 library dont have any data set named deneme

thanks

Re: LIBNAME

Tom — Sat, 16 Nov 2019 16:29:59 GMT

@cetin wrote:

hi tom;

you are right about subject;

you said that "NEW data set named WORK.DENEME" but i didnt use work i used pg3 library pg3.deneme

so pg3 library dont have any data set named deneme

thanks

I have never seen the SAS log report that it is using a different dataset than the code requested. Remember that if you use a one level name, like DENEME, then it is assumed to be in the WORK library.

Please post the lines from the log (make sure to use the Insert Code icon in the editor menu so that lines don't get reflowed).

Re: LIBNAME

cetin — Sat, 16 Nov 2019 16:36:36 GMT

LIBNAME pg3 XLSX "/home/cetinkaygaldurak1/sasuser.v94/ULKE3.xlsx";

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';
proc import datafile=REFFILE
            dbms=xlsx    
            out=pg3.deneme;
    sheet=ulke2_s;
run;

Re: LIBNAME

Tom — Sat, 16 Nov 2019 16:51:18 GMT

The lines in the SAS log will show line numbers before the lines of code and have messages from SAS like in your original post. That is just the same lines of code that you posted before. To tell PROC IMPORT it is ok to replace an existing dataset add the word REPLACE to the PROC IMPORT statement.

Re: LIBNAME

cetin — Sat, 16 Nov 2019 20:31:41 GMT

sory i am writing late

that code dont work

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx'; proc import datafile=REFFILE dbms=xlsx out=pg3.deneme; sheet=ulke2_s; run;

this one is working why i dont add my dataset name is deneme at pg3 library and

I can add deneme2 data to the work library what is the difference i dont understand sory long question

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';
proc import datafile=REFFILE
            dbms=xlsx    
            out=work.deneme;
    sheet=ulke2_s;
run;

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';
proc import datafile=REFFILE
            dbms=xlsx    
            out=work.deneme2;
    sheet=ulke2_s;
run;

Re: LIBNAME

cetin — Sat, 16 Nov 2019 21:14:28 GMT

i think first code is working with xlsx engine so i dont add any dataset this library ---------------------(libname=pg3)

LIBNAME pg3 XLSX "/home/cetinkaygaldurak1/sasuser.v94/ULKE3.xlsx";

FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';
proc import datafile=REFFILE
            dbms=xlsx    
            out=pg3.deneme
            replace;
    sheet=ulke2_s;
run;

Re: LIBNAME

PaigeMiller — Sat, 16 Nov 2019 23:44:53 GMT

LIBNAME pg3 XLSX "/home/cetinkaygaldurak1/sasuser.v94/ULKE3.xlsx";
FILENAME REFFILE '/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx';
proc import datafile=REFFILE
            dbms=xlsx    
            out=pg3.deneme
            replace;
    sheet=ulke2_s;
run;

The error is in the first line. You have established the libname PG3 to point to an Excel file. But you don't want that, as the OUT= creates a SAS data set and not an excel file. Thus, libname PG3 must be a folder, and not an Excel file (and not a file of any type), for example:

libname pg3 "/home/cetinkaygaldurak1/sasuser.v9";

Re: LIBNAME

Tom — Sat, 16 Nov 2019 23:44:40 GMT

Why do you want to convert an Excel sheet into a dataset and then immediately convert it back into another excel sheet?

What is the overall goal?