ERROR - file does not exist when it does

[claremc]

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 

[PaigeMiller · Accepted solution]

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.

[claremc]

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

[Tom]

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.