topic Avoid save dialog in ODS in ODS and Base Reporting

Avoid save dialog in ODS

JGuillen — Wed, 08 Feb 2017 16:33:59 GMT

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.

Re: Avoid save dialog in ODS

ballardw — Wed, 08 Feb 2017 21:17:45 GMT

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;

Re: Avoid save dialog in ODS

JGuillen — Wed, 08 Feb 2017 23:44:39 GMT

Thanks! It works for what i need.