Date: Thu, 11 Sep 2003 17:10:46 -0400
Reply-To: Kevin Roland Viel <kviel@EMORY.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Kevin Roland Viel <kviel@EMORY.EDU>
Subject: Re: DDE and PAGE.SETUP
Content-Type: text/plain; charset=ISO-8859-1
Quoting "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>:
> data _null_;
> file cmds;
> put '[PAGE.SETUP( , , 3, , 3)]';
> put '[SAVE()]';
> put '[QUIT()]';
Thanks. Seems you have been covering me lately :)
I get an I/O message. However, with Excel, I cannot view Print Preview or
Page Setup manually. Perhaps my problem lies there. A partial log follows.
535 data _null_;
536 file xl_sys;
537 put %unquote(%str(%'[workbook.activate%(%"%trim(&i.)%"%)]%'));
538 put '[zoom(65)]';
539 put '[PAGE.SETUP( , , 3, , 3)]';
/* Clipped */
NOTE: The file XL_SYS is:
ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step
program. Aborted during the EXECUTION phase.
NOTE: 2 records were written to the file XL_SYS.
The minimum record length was 10.
The maximum record length was 25.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used:
real time 0.01 seconds
cpu time 0.00 seconds
Department of Epidemiology
Rollins School of Public Health
Atlanta, GA 30322