BookmarkSubscribeRSS Feed
GuillermoPH
Obsidian | Level 7

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!

2 REPLIES 2
ballardw
Super User

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.

Kurt_Bremser
Super User

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 3242 views
  • 1 like
  • 3 in conversation