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.
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!
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.
Ready to level-up your skills? Choose your own adventure.