02-08-2017 11:33 AM
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;
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.
02-08-2017 04:17 PM
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
replace /*<= this overwrites an existing file if present*/