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;   ... View more

sory i am writing late   that code dont work <span class="token statement">FILENAME</span> REFFILE <span class="token string">'/home/cetinkaygaldurak1/sasuser.v94/ULKE2_S.xlsx'</span><span class="token punctuation">;</span> <span class="token procnames">proc</span> <span class="token procnames">import</span> datafile<span class="token operator">=</span>REFFILE dbms<span class="token operator">=</span>xlsx out<span class="token operator">=</span>pg3<span class="token punctuation">.</span>deneme<span class="token punctuation">;</span> sheet<span class="token operator">=</span>ulke2_s<span class="token punctuation">;</span> <span class="token procnames">run</span><span class="token punctuation">;</span>   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;     ... View more

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; ... View more

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       ... View more