topic Re: uploading sas7bdat files to SAS Studio -- file does not exist in SAS Programming

uploading sas7bdat files to SAS Studio -- file does not exist

KarenKeating — Wed, 11 Sep 2019 22:00:28 GMT

I have created two sas7bdat files for my class. Students download them from the course website (Canvas) and upload them to SAS Studio. We are not using Enterprise Guide and we do not have SAS installed on our machines. The files appear to upload properly, but when I double click on the file name, I get an error message that the file does not exist. There is absolutely no coding involved in this process, so the earlier solutions regarding library names, etc., should not be the problem. I am running Windows 10, but some students running a Mac have had the same problem. See the screen shot below.

Any guidance would be appreciated.

Thanks in advance.

Karen Keating

Re: uploading sas7bdat files to SAS Studio -- file does not exist

ChrisNZ — Thu, 12 Sep 2019 04:19:22 GMT

> I have created two sas7bdat files for my class. 8>< There is absolutely no coding involved in this process, so the earlier solutions regarding library names, etc., should not be the problem.

That's not true. These files are SAS data sets need to be accessed via a library.

Because you did not define one, SAS created one for you (called _TEMP6) but something is not quite as expected.

Define a library and see what happens when you access the file from the library,

Re: uploading sas7bdat files to SAS Studio -- file does not exist

KarenKeating — Thu, 12 Sep 2019 04:43:21 GMT

I can view the contents of other sas7bdat files without creating a library. I just double-click the file name and the table appears in the programming window. Something is different with these two files. Even when I define a library (using copy-and-paste to avoid typos), I still cannot access these two files.

I am truly perplexed about this. I can create the files, download them to my PC and then upload them to the SAS server, and everything works fine. When I download the same files from Canvas and upload them to SAS, the error occurs.

Here is my code:

libname myfiles '/home/keatingk/STAT 725/2019 Fall Homework';
proc contents data=myfiles.MINUTE1; run;
data temp1;
 set myfiles.MINUTE1;
 run;

Here are the messages in the log file:

 71         libname myfiles '/home/keatingk/STAT 725/2019 Fall Homework';
 NOTE: Libref MYFILES was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /home/keatingk/STAT 725/2019 Fall Homework
 72         
 73         proc contents data=myfiles.MINUTE1; run;
 ERROR: File MYFILES.MINUTE1.DATA does not exist.
 
 NOTE: Statements not processed because of errors noted above.
 NOTE: PROCEDURE CONTENTS used (Total process time):
              (. . . some lines are removed . . .)       
 NOTE: The SAS System stopped processing this step because of errors.
 74         
 75         
 76         data temp1;
 77          set myfiles.MINUTE1;
 ERROR: File MYFILES.MINUTE1.DATA does not exist.
 78          run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set WORK.TEMP1 may be incomplete.  When this step was stopped there were 0 observations and 0 variables.

Re: uploading sas7bdat files to SAS Studio -- file does not exist

ChrisNZ — Thu, 12 Sep 2019 04:52:44 GMT

The issue seems to be with the file getting corrupted during the transfer from what you describe.

Re: uploading sas7bdat files to SAS Studio -- file does not exist

Kurt_Bremser — Thu, 12 Sep 2019 05:24:08 GMT

Filenames of dataset files MUST be lowercase only. While datasets are always displayed in uppercase within SAS, the files themselves need to be lowercase.

So you need to rename your files

minute1.sas7bdat
minute5.sas7bdat