DATA Step, Macro, Functions and more

Access accdb library with space in table name

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Access accdb library with space in table name

I got Access DB file that I want mapped to SAS as a library using libname.  However, the table inside got a new with space.  How can I write data steps to refer to that table?

 

I did:

libname ac Access "C:\xyz.accdb" ;

Table named "AB CD" inside the library ac. 

 


Accepted Solutions
Solution
‎05-04-2017 10:25 AM
Super User
Posts: 6,936

Re: Access accdb library with space in table name

Try using

"AB CD"n

as the dataset name.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎05-04-2017 10:25 AM
Super User
Posts: 6,936

Re: Access accdb library with space in table name

Try using

"AB CD"n

as the dataset name.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 81 views
  • 0 likes
  • 2 in conversation