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!
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.