Date:         Fri, 29 Oct 1999 16:56:31 -0400
Reply-To:     "Fan, Bin" <FANB@CHILD.CPMC.COLUMBIA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Fan, Bin" <FANB@CHILD.CPMC.COLUMBIA.EDU>
Subject:      Re: CODE TO EXPORT TO EXCEL 97.
Content-Type: text/plain

        -----Original Message-----
        From:   Fan, Bin
        Sent:   Friday, October 29, 1999 4:55 PM
        To:     'Stuart Louw'
        Subject:        RE: CODE TO EXPORT TO EXCEL 97.


        Dear Stuart Louw:

        You can try this:

        DATA TEMP;
              SET  SD2.TEMP;
        RUN;

        **** OUTPUT DATA TO EXCEL 97 ****;
        PROC DBLOAD DBMS=EXCEL DATA=TEMP;
        PATH="C:\SAS\TEMP\TEMP.XLS";
        PUTNAMES YES;
        LIMIT=0;
        LOAD;
        RUN;

        I did this one before, it worked very well.

        Best wishes.



        Bin Fan
        Columbia University
        New York City



                -----Original Message-----
                From:   Stuart Louw [SMTP:XY17563@EXCHANGE.OLDMUTUAL.COM]
                Sent:   Friday, October 29, 1999 8:42 AM
                To:     SAS-L@LISTSERV.UGA.EDU
                Subject:        CODE TO EXPORT TO EXCEL 97.

                I urgently need to automate an export to 97. Is there code
that can do this
                or will I have to keep on clicking till the end of days
!!!!.

                LD.