BookmarkSubscribeRSS Feed
Calcite | Level 5


We try to use the JDBC Driver to view tables in a database viewer from Jetbrains (Data Grip, Pycharm, Intellij). 

Driver: SAS Drivers for JDBC | SAS Support



  1. We connected a SAS Dataservice with PyCharm (and other IDEs Intellij, DataGrip from Jetbrains) succesfully.
  2. All tables and column information in the database tool tab looks fine….
  3. But, if we open a table, the column name on all culomns is "<anonymous>"
  4. Only Columns with a given comment/label will show the comment text.
  5. Checking the DDL we found out, that each column without a comment has a plenty of blanks as a comment 😥

Anyone have seen this behaviour? Ideas to fix it?

We realy not want to copy the column name in all columns mandatory.😂


2021-09-16 14_40_20-test__st_05 – CARS.png

Column defintions of 

2021-09-16 14_40_03-test__st_05 – CARS.png

Table View with column names shows as "anonymous" 


2021-09-17 09_08_28-Modify Table.png

Responding Metadata vom SAS JDBC, see the many blanks as comment (sas called 'label')


2021-09-16 14_41_42-test__st_05 – CARS.png

DDL Created based on responding Metadata 


Parallel Jetbains Issue

Database Table Colum Name "<anonymous>" instead Colum Name : DBE-14103 (


Super User

It would likely be helpful to include the LOG from running the code reading the data source. Copy the text of the code and all messages from the code generating the data set from the LOG and paste the text into a text box opened on the forum with the </> icon appearing above the message window on the forum.

The text box is important as it will preserve the formatting of the text which often includes diagnostic information that gets reformatted when pasting into a code box.


If you are going to post pictures you need to explain why each image is posted and what we should be looking for and likely what program you are using to examine this. How are you "opening the table"? Also which SAS environment are you working in? On Demand, Enterprise Guide, or something else.

Calcite | Level 5

Hi! I am using the linked SAS JDBC driver in PyCharm, so there is no SAS Log.

Super User Tom
Super User

No idea what a "comment" is. 


But it is perfectly normal to not attach a LABEL to a variable.  For example that last photographs looks like it might be the SASHELP.CARS sample dataset that ships with SAS.  Only some the variables have labels or formats attached to them.


What most SAS procedures that use the LABEL in the output instead of the NAME will do is use the NAME when the LABEL is empty.


As to the blanks remember that SAS has only two types of variables. Fixed length character strings and floating point numbers.  It appears that whatever is populating the "comment" is taking the value of the LABEL field and including the trailing blanks that are included to pad it out to its full storage length.

Calcite | Level 5

Many true words, but:

Issue descripes responding data with SAS JDBC driver 

Calcite | Level 5

@Kitara @kitara may you can help me? Are you using SAS JDBC on intellij?



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 3 in conversation