LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


Back to: Top of message | Previous page | Main SAS-L page