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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.