Date: Thu, 6 Oct 2011 12:42:45 -0700
Reply-To: Irin later <firstname.lastname@example.org>
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"
40 PROC EXPORT DATA= g.members
41 OUTFILE= "F:\HOME\Dir\sample.accdb"
42 DBMS=ACCESS REPLACE;
NOTE: The previous statement has been deleted.
ERROR 180-322: Statement is not valid or it is used out of proper order.
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.