topic Re: ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/ in SAS Enterprise Guide

ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

GuillermoPH — Wed, 27 Sep 2017 17:31:57 GMT

Hello everyone!

I'm trying to use the EXPORT Procedure, my coding looks like this:

%let fecha = %sysfunc(date(),date9.);

PROC SQL;
   CREATE TABLE WORK.Resumen_&fecha(label="RESUMEN") AS 
   SELECT t1.CLAVECDR, 
          /* Calificación */
            (SUM(t1.RESULTADO)) FORMAT=PERCENT9.1 LABEL="Calificación" AS 'Calificación'n
      FROM WORK.RESULTADOS t1
      GROUP BY t1.CLAVECDR;
QUIT;

proc export data=work.resumen_&fecha outfile="C:\Users\guiperez\Desktop\CEREBRO\Proveedores\Proyectos Especiales\Calificación CDRs" dbms=xls;
quit;

But everytime Irun it I get the exact same error:

It's driving me nuts! I've been surfing the web for an answer but so far nothing seems to work... 😕

Any help will be much appreciated!

Re: ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

ballardw — Wed, 27 Sep 2017 18:18:29 GMT

The change from / to \ in the error message tells me that your SERVER (the / path part) cannot see your local hard drive.

You must specify a path that the server can see and you have write permissions to, perhaps a shared drive or such, or use the export tasks and not direct code.

Re: ERROR: Physical file does not exist, /sas/Config/Lev1/SASApp/

Kurt_Bremser — Wed, 27 Sep 2017 18:54:59 GMT

Your workspace server process runs on a UNIX server, so you need to use UNIX style file/pathname syntax to point to a location where you have write permission. After that, you can use a file transfer utility or the file copy task in Enterprise Guide to retrieve the file to your desktop.