ODS CSV CLOSE without File Download Dialog 1

[jdrb]

Hi. I'm controlling SAS using OLE Automation (from VB) and need to write ODS output to a csv file. This is working fine, but when I finally submit "ODS CSV CLOSE;", a File Download dialog appears asking if I want to open or save the file. Can I suppress this dialog? It appears even though I'm running a hidden instance of SAS. Thanks in advance for any thoughts. JDRB.

 

[klaz2002]

Try turn the 'view results as generated' setting off on the machine that your automatic script runs SAS.

in SAS v8
got to Tools-->Options-->Preferences and select the 'Results' tab.

Then uncheck the 'view results as generated' box in the view results section.

Hope this helps you.
Klaz

 

[shenniko]

Hi,

Is there a way of doing this in the code?

I have a report that outputs about 1000+ HTML pages, which i want to dissable the "view output as generated".

But when im writing new scripts, i want to view the output. So would be easier to just put some code at top of report to dissable the view as generated, and then some code to turn it back on at the end of the script..

Any Ideas?

Thanks

Robbie

 

[klaz2002]

Yes there is a way. You need to modify the SAS registry. I did this a while back and will have to find the code. The basic idea, if I recall correctly, is to use the PROC REGISTRY routine and update the section titled ODS\GUI\RESULTS.
EX

[ODS\GUI\RESULTS]
"Auto Navigate"="On"
"Internal Browser"="On"

The default is

"Auto Navigate"="On"

You need to set this to "Off" like this

[ODS\GUI\RESULTS]
"Auto Navigate"="Off"

Also, I saved the original registry file (programmatically) before I modified it and was able to quickly reset it back to its original state.

You will have to look up the exact code as I can't seem to find the source right now.

Hope this sends you in the right direction.

Klaz

 

[klaz2002]

OK I just tried this and it works.

First you should save the current registry file. (I output the whole thing to a text file.)

filename t 'c:\regist.txt';
filename z 'c:\reg2.txt';

*** OUTPUT THE REGISTRY TO TEXT FILE ***;
proc registry export=t;
run;

*** WRITE NEW PREF DATA ***;
data _null_;
file z;
put "[ODS\GUI\RESULTS]";
put '"Auto Navigate"="Off"';
run;

*** IMPORT NEW OPTION ***;
*** SAS WILL ONLY UPDATE THE TAG IT FINDS ***;
proc registry import=z;
run;

*** FORCE SAS TO 'SEE' THE NEW PREFS ***;
ods preferences;

When your program is done it could reset the registry like this.

proc registry import=t;
run;

ods preferences;

I hope that this helps you.
Klaz