topic Re: ERROR - file does not exist when it does in SAS Programming

ERROR - file does not exist when it does

claremc — Thu, 07 Jan 2021 14:52:50 GMT

Hello,

I am attempting to transpose a dataset in my work library that I just created. The dataset sorts, and then it does not allow me to transpose and gives me the error message:

ERROR: File WORK.PCRDUP_CHECK_MINUSDUPS.DATA does not exist.

However, it does exist! Do you know what could be happening?

Thanks,

Clare

Re: ERROR - file does not exist when it does

PaigeMiller — Thu, 07 Jan 2021 14:58:44 GMT

First, when SAS says the dataset does not exist and the user says it does exist, I believe SAS. So please check for spelling errors. Also check to make sure this data set exists in your WORK library and not in some other library.

If that doesn't solve the problem, please show us the code (as text) you are using and also a screen capture of the Library panel in your SAS.

Re: ERROR - file does not exist when it does

Tom — Thu, 07 Jan 2021 19:01:02 GMT

Most likely a typo in your code. This is what you described you ran:

proc sort .... out=PCRDUP_CHECK_MINUSDUPS ;
  ...
run;
proc transpose data=PCRDUP_CHECK_MINUSDUPS ... ;
  ...
run;

So make sure the dataset written by PROC SORT is the same one you are trying to reference in PROC TRANSPOSE.

Re: ERROR - file does not exist when it does

claremc — Thu, 07 Jan 2021 20:14:48 GMT

It ended up being an error in my spelling! Thank you!