BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
rdevoss
Fluorite | Level 6

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Kurt_Bremser
Super User

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.

View solution in original post

6 REPLIES 6
ballardw
Super User

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.

rdevoss
Fluorite | Level 6

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. 

rdevoss
Fluorite | Level 6
I've definitely noticed the curly version of " creating issues. Thanks!
DavidHD
SAS Employee

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

rdevoss
Fluorite | Level 6

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     

 

Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 16527 views
  • 7 likes
  • 4 in conversation