Date:         Thu, 6 Oct 2011 12:42:45 -0700
Reply-To:     Irin later <irinfigvam@yahoo.com>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Irin later <irinfigvam@YAHOO.COM>
Subject:      Proc Export     (from SAS 9.2 to Access 2007)
Content-Type: text/plain; charset=iso-8859-1

I need to export SAS 9.2 dataset members into ACCESS 2007 to table members. Below is what I tried to do:

PROC EXPORT DATA= g.members 
            OUTFILE= OUTFILE= "F:\HOME\Dir\sample.accdb"
            DBMS=ACCESS REPLACE;
     table=members; 
 RUN; 
 
 
40   PROC EXPORT DATA= g.members
41               OUTFILE= "F:\HOME\Dir\sample.accdb"
42               DBMS=ACCESS REPLACE;
NOTE: The previous statement has been deleted.
43        table=members_;
          -----
          180
ERROR 180-322: Statement is not valid or it is used out of proper order.
44    RUN;
 
 
I tried to swap db and table names, also I tried  table name in quatation marks but still get an error.  What I am doing wrong? 
 
Thank you in advance.
Irin