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
In-Reply-To:  <83F5497995A8D511965F00508BB929700271ED94@ddsexmb01.cahwnet.gov>
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()]';
> run;

Paul,

    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 */
568       run;

NOTE: The file XL_SYS is:
      DDE Session,
      SESSION=Excel|system,RECFM=V,LRECL=256

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

Thanks,

Kevin

Kevin Viel
Department of Epidemiology
Rollins School of Public Health
Emory University
Atlanta, GA 30322