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.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2022-05-03 11:00:00 +0000
Seen: 7 times
Last updated: Apr 15 '22
What is the process for installing SASS/Compass in the DDEV web container?
What is the best way to arrange the file structure for both the backend and frontend in MERN?
What is the method of merging several inline style objects?
Is it possible to utilize a SAS Server for storing network files? If so, what is the process?
What is the method of including a list of macro variables as a column in a SAS dataset?
What is a data storage solution for backing up data?
What is the process of creating critical notifications in iOS using Expo SDK 42 managed?