topic Re: File does not exist in SAS Programming

File does not exist

rdevoss — Thu, 10 Dec 2020 15:12:33 GMT

Hello,

I'm trying to complete an assignment for my SAS course. I'm having difficulty using a dataset after uploading to the correct folder in sas studio. I'm receiving the error: ERROR: File data does not exist.

I tried renaming the uploaded file to hypanalysis11 to see what the error is:

%LET CourseRoot = /home/u49699746/BIOS 6680;
LIBNAME name "&dataset";

Data name.data11;
Set name.data1;
run;

Log is attached to this post along with screenshot of folder tree.

Re: File does not exist

ballardw — Mon, 23 Nov 2020 15:37:24 GMT

Please post logs by copying the text of the entire data step or procedure or code in question, then open a code box on the forum using the </> icon and then paste the text.

Many of us do not want to, or by organization policy cannot, open attachments such as word documents from unknown sources.

Plus the copy/paste should be less work on your part.

Additionally when you create DOCX files you may get character changes that means what you see is not what was really submitted. Smart quotes are one common problem changing straight programming quote characters like " to curly versions, which do not work with code.

Re: File does not exist

DavidHD — Mon, 23 Nov 2020 15:48:54 GMT

Did you check that your lib was assigned successfully and maybe if your dataset shows up there?

proc contents data=hypanl.hypanalysis1;
quit;

Kind Regards

David

Re: File does not exist

rdevoss — Mon, 23 Nov 2020 16:05:46 GMT

Thank you for clarifying that. It makes total sense to not put a .docx in there.

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         Data hypanl.hypanalysis11;
 74         Set hypanl.hypanalysis1;
 ERROR: File HYPANL.HYPANALYSIS1.DATA does not exist.
 75         run;
 
 NOTE: The SAS System stopped processing this step because of errors.
 WARNING: The data set HYPANL.HYPANALYSIS11 may be incomplete.  When this step was stopped there were 0 observations and 0 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.01 seconds
       user cpu time       0.01 seconds
       system cpu time     0.00 seconds
       memory              532.59k
       OS Memory           29604.00k
       Timestamp           11/23/2020 03:06:26 PM
       Step Count                        41  Switch Count  2
       Page Faults                       0
       Page Reclaims                     84
       Page Swaps                        0
       Voluntary Context Switches        28
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           160
       
 
 76         
 77         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 89

I think the error is reading in the data with the Options Fmtsearch since the error is saying there are no columns in the data set.

Re: File does not exist

rdevoss — Mon, 23 Nov 2020 16:07:38 GMT

Libref is assigned successfully. It's somewhere with reading in the data set.

%LET	CourseRoot = /home/u49699746/BIOS 6680;
LIBNAME HypAnl    "&CourseRoot/Hypertension Study/Data/4_Analysis";
OPTIONS	FMTSEARCH = (HypTabs.HypFormats WORK LIBRARY)
		NOFMTERR;
Data hypanl.hypanalysis1;
Set hypanl.hypanalysis1;
run;

1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         %LETCourseRoot = /home/u49699746/BIOS 6680;
 74         LIBNAME HypAnl    "&CourseRoot/Hypertension Study/Data/4_Analysis";
 NOTE: Libref HYPANL was successfully assigned as follows: 
       Engine:        V9 
       Physical Name: /home/u49699746/BIOS 6680/Hypertension Study/Data/4_Analysis
 75         OPTIONSFMTSEARCH = (HypTabs.HypFormats WORK LIBRARY)
 76         NOFMTERR;
 77         
 78         Data hypanl.hypanalysis1;
 79         Set hypanl.hypanalysis1;
 80         run;
 
 NOTE: There were 0 observations read from the data set HYPANL.HYPANALYSIS1.
 NOTE: The data set HYPANL.HYPANALYSIS1 has 0 observations and 0 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.01 seconds
       user cpu time       0.00 seconds
       system cpu time     0.01 seconds
       memory              736.31k
       OS Memory           30116.00k
       Timestamp           11/23/2020 04:07:00 PM
       Step Count                        82  Switch Count  1
       Page Faults                       0
       Page Reclaims                     91
       Page Swaps                        0
       Voluntary Context Switches        37
       Involuntary Context Switches      0
       Block Input Operations            0
       Block Output Operations           160
       
 
 81         
 82         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 94

Re: File does not exist

rdevoss — Mon, 23 Nov 2020 16:09:04 GMT

I've definitely noticed the curly version of " creating issues. Thanks!

Re: File does not exist

Kurt_Bremser — Mon, 23 Nov 2020 16:09:38 GMT

Your file is called

HypAnalysis1.sas7bdat

A filename like that will prevent SAS from finding the dataset. The physical filenames of SAS datasets on UNIX (a case-sensitive operating system) MUST be lowercase. MUST.