BookmarkSubscribeRSS Feed
Shrutibhatnagar
Obsidian | Level 7

libname class1 '/folders/myfolders/mysas';
proc import datafile='/folders/myfolders/mysas/smb.csv'
dbms=csv out=smb replace;
libname class2 '/folders/myfolders/mysas';
proc import datafile='/folders/myfolders/mysas/churners_and_labels.xls'
dbms=xls out=churners replace;sheet=labels;
DATA labels;
SET class1.smb(keep=PRODUCT_ID Year AON);
LABEL PRODUCT_ID="Line number";
Year="Year";
AON="Age on network";

RUN;

 

gives error :- ERROR: File CLASS1.SMB.DATA does not exist.

3 REPLIES 3
PGStats
Opal | Level 21

You have to say out=class1.smb in your proc import statement.

PG
Shmuel
Garnet | Level 18

When you write out=smb your output is work.smb, that is in work library.

To create the output in class1 library you should use @PGStats  answer:  out=class1.smb

Develop Code with SAS Studio

Get started using SAS Studio to write, run and debug your SAS programs.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1290 views
  • 0 likes
  • 4 in conversation