Desktop productivity for business analysts and programmers

ERROR: File does not exist?? But it does....

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

ERROR: File does not exist?? But it does....

544        DATA HEDIS.PSYCH;
545        	SET HEDIS.ANTIPSYCH HEDIS.RXPSYCH;
546        RUN;

NOTE: There were 15 observations read from the data set HEDIS.ANTIPSYCH.
NOTE: There were 2223 observations read from the data set HEDIS.RXPSYCH.
NOTE: The data set HEDIS.PSYCH has 2238 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

547        
548        PROC SORT NODUPKEY DATA=HEDIS.PSCYH;
ERROR: File HEDIS.PSCYH.DATA does not exist.
549            BY EDIPN;
550        RUN;

Accepted Solutions
Solution
3 weeks ago
Super Contributor
Posts: 315

Re: ERROR: File does not exist?? But it does....

[ Edited ]

Hi,

 

Your first step creates a data set ending in the letters Y-C-H, but the next step tries to use a data set ending in C-Y-H, which is why the error occurs.

 

Perhaps copy and paste the data set name you want to use.

 

 

Regards,

Amir.

 

Edited to change 'step' to 'set'.

View solution in original post


All Replies
Solution
3 weeks ago
Super Contributor
Posts: 315

Re: ERROR: File does not exist?? But it does....

[ Edited ]

Hi,

 

Your first step creates a data set ending in the letters Y-C-H, but the next step tries to use a data set ending in C-Y-H, which is why the error occurs.

 

Perhaps copy and paste the data set name you want to use.

 

 

Regards,

Amir.

 

Edited to change 'step' to 'set'.

Super User
Posts: 9,866

Re: ERROR: File does not exist?? But it does....

It's a good strategy to use copy-paste when propagating dataset or other names (macros, variables, ...) throughout code.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 83 views
  • 2 likes
  • 3 in conversation