We try to use the JDBC Driver to view tables in a database viewer from Jetbrains (Data Grip, Pycharm, Intellij).
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.😂
Column defintions of sashelp.cars
Table View with column names shows as "anonymous"
Responding Metadata vom SAS JDBC, see the many blanks as comment (sas called 'label')
DDL Created based on responding Metadata
Parallel Jetbains Issue
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.
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.
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.
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.