Proc Export

[JM3482]

What am i missing in the following statement if I am trying to export a SAS table in excel format and then replace it the next time the program is run. It keeps stopping the replace process.

PROC EXPORT DATA=OPR9100.discharged
OUTFILE="C:\Data\OPR9100\Discharged Stage Pended LOS.xls";
REPLACE;
run;

 

[karlomutschler]

hi,
this works for me:

PROC EXPORT DATA= WORK.tablename
OUTFILE= "Path\filename.xls"
DBMS=EXCEL2000;
RUN;

If you add the "REPLACE" to the statement the existing file
will be automatically replaced; by omitting "REPLACE" a Yes/No
MessageBox will be displayed.

HTH
Kind regards
Karlo Mutschler



meistertools@gmx.net

 

[JM3482]

Thanks. I have tried it both ways and I can't get it to replace the file. I will try again.

 

[karlomutschler]

hi,

PROC EXPORT DATA= WORK.tablename
OUTFILE= "Path\filename.xls"
DBMS=EXCEL2000 REPLACE;
RUN;

HTH
Karlo

meistertools@gmx.net

 

[jymm]

note ---- in the solutions you have an extra ; on one line -- should make a difference