Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 14

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

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:

 image.png

 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!

Super User
Posts: 13,023

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

[ Edited ]
Posted in reply to GuillermoPH

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.

Super User
Posts: 9,560

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

Posted in reply to GuillermoPH

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 131 views
  • 1 like
  • 3 in conversation