The SAS Output Delivery System and reporting techniques

Avoid save dialog in ODS

Reply
New Contributor
Posts: 2

Avoid save dialog in ODS

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.

 

 

Grand Advisor
Posts: 9,748

Re: Avoid save dialog in ODS

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;

New Contributor
Posts: 2

Re: Avoid save dialog in ODS

Thanks! It works for what i need.
Post a Question
Discussion Stats
  • 2 replies
  • 81 views
  • 0 likes
  • 2 in conversation