You assign library "USER" by a libname the same way as any other your permanent library. Assign it to a path you are permitted to read/write and can save.   Unlike WORK it is not initiated at each session and not cleared at the end of session.  ... View more

@james12 wrote: Hello SAS Community,  Frist step; Import a Excel file using a snippet. Second step: Convert Excel file to a WORK library file. Third step: PROC IMPORT and PROC PRINT the file in the WORK library. Forth step: Try (not successful) to do ANOVA using the One-Way ANOVA from Tasks. Tasks will not allow entry WORK library files.   Step 1+2 seem the same as Step 3 unless you're referencing different files? If you did this, it's possible you accidentally destroyed your SAS data set and it doesn't exist anymore or something. The steps above all completed successfully and without errors?   Once a SAS data set is imported, via a Snippet or PROC IMPORT it's either in a WORK or permanent library (depending on the code) and you shouldn't need to import it again.  ... View more