Revision history [back]

The problem with your SAS query is that SAS does not allow spaces in column names when accessing external DBMS tables. To access a column that contains space in an external DBMS table, you can use double quotes to enclose the column name. For example, if you have a table with a column named "First Name", you can access it in SAS with the following query:

SELECT "First Name" FROM external_table;

Alternatively, you can create a view in the external DBMS that renames the column without spaces, and then access the view in SAS.