BookmarkSubscribeRSS Feed
bhanl004
Fluorite | Level 6
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 libname mydata '/folders/myfolders/';
NOTE: Libref MYDATA refers to the same physical library as MYFOLDER.
NOTE: Libref MYDATA was successfully assigned as follows:
Engine: V9
Physical Name: /folders/myfolders
74
75
76 proc export data=mydata.donor outfile = "/folders/myfolders/data1.csv" dbms=csv replace;
77 run;
 
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
ERROR: File MYDATA.DONOR.DATA does not exist.
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
 
78
79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
91
Tom
Super User Tom
Super User

That is the same error as before. There is no data to export.

Reeza
Super User
Show a screenshot of myfolders from the Server Files and Folder pane and one of the library, MYdata created.
Tom
Super User Tom
Super User

Make sure you don't have the same issue with locating the output file as you had with finding the input dataset. Perhaps you are looking at some older version instead of the one made the last time.  Also make sure you are not overwriting it with some other code that runs later.

 

Note that the code you posted was using a filename without any path. That is probably not going to work in SAS UE as the normal current working directory will be pointing to a location where you will not have write access.  But you should get an error in that case.

Reeza
Super User
You can also just use the export task and it will generate the code for you, assuming you've assigned a libname correctly and can see your data sets. You can also just right click the file and select export and it will export the file.
Reeza
Super User
Just a heads up, most of the issues you're running into here have to do with using SAS UE, not with SAS per se. It has to do with using a Unix system with a Windows file and a locked down environment.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 21 replies
  • 2547 views
  • 0 likes
  • 4 in conversation