Hello
I have a number of tables residing in an MS ACCESS db which I would like to import into SAS without using the PROC IMPORT option.
My code is as follows:
Proc SQL;
Connect to access (path='S:\LAB STATS 09_10.mdb');
Create table ed.test as
select * from connection to access
(select * from E_Q Data CNTs);
disconnect from access;
quit;
NOTE: E_Q Data CNTs is the table of interest in MS ACCESS.
I keep getting the following error:
ERROR: Prepare: Syntax error in FROM clause.
SQL statement: select * from E_Q Data CNTs
Can someone please review my code? I do not understand the ERROR message.
Thanks
I have a number of tables residing in an MS ACCESS db which I would like to import into SAS without using the PROC IMPORT option.
My code is as follows:
Proc SQL;
Connect to access (path='S:\LAB STATS 09_10.mdb');
Create table ed.test as
select * from connection to access
(select * from E_Q Data CNTs);
disconnect from access;
quit;
NOTE: E_Q Data CNTs is the table of interest in MS ACCESS.
I keep getting the following error:
ERROR: Prepare: Syntax error in FROM clause.
SQL statement: select * from E_Q Data CNTs
Can someone please review my code? I do not understand the ERROR message.
Thanks