The SAS Studio autocomplete function might not add data sources to your program code using the correct letter casing. This problem can occur when you are connecting to a case-sensitive database.

For example, suppose that you are creating a library with the OLEDB engine. The database that you are connecting to is configured to be case sensitive. In this case, the names of data sources in the library use both lowercase and uppercase letters.

Now, suppose that you need to sort a data source named THISisCLASSdatasource, which contains some characters in uppercase and others in lowercase. In new program code, you add the SORT procedure. If you use the autocomplete function when entering the SORT procedure, then a pop-up window displays all available data sources in the library, as shown in the following display. As you can see, lowercase and uppercase letters are displayed correctly in the window.

However, if you use the arrow keys to select and add THISisCLASSdatasource to the program code, then the data source name is added in lowercase letters, as shown in the following display: 

As a result, when executing the program code, the following error is returned:

To avoid this issue, do not use the arrow keys to select the data source name in the autocomplete window. Instead, enter the first character of the data source in the correct case (uppercase "T" in this example). The data source name is then added to the code with the correct letter casing, as shown in the following display:

Operating System and Release Information