Avoid save dialog in ODS

[JGuillen]

I want to create a simple dictionary of a dataset to a CSV file using  ODS , below is the syntax

ODS CSV file= "C:\tmp\test.csv";
proc print data=datadictionary noobs label;
RUN;
ODS CSV CLOSE;

after submitting the code, a dialog window to 'open or save' the file appears, then another for 'Save as'...

How can save it directly to the directory and overwrite?

Thanks in advance.

[ballardw]

If you don't need "pretty" formatting such as Proc Print provides then you might consider using proc export which will by-pass the ODS output and does not ask about opening files.

Proc export data=datadictionary

        label

        outfile="C:\tmp\test.csv"

        replace  /*<= this overwrites an existing file if present*/

run;

[JGuillen]

Thanks! It works for what i need.