String Column not showing full value

[JF_Gonzalez]

Hi all,

My company's going through a process of changing SAS Servers, and as SAS User Admin I've been pointed out how some String Columns are not showing their full values when opening the tables in the new server. Software used is SAS EG.

Desired values shown (image of the old server):

Actual values shown:

For what it's worth, the next image shows the table in the new server while in Update Mode. I can see the full String, so the value is not lost.

Has anyone ever solved such issue? It doesn't affect any joins we do because SAS detects the full value, which is nice, but this will confuse more users in the future.

Thank you,

José-Francisco González Bofill

[RW9]

Its just a column sizing issue in the table viewer, we have it in my system (different software) as well. Expand the column by dragging the right anchor of the variable name box to the right to see full value.  I know its annoying that it doesn't automatically size to variable width.

[JF_Gonzalez]

I think we have a slightly different issue. Adjusting the width of the column is not making it show the full value either, but thanks for the swift reply!

[RW9 · Accepted solution]

If your sure the length of the column is sufficient for the variable - i.e. look at variable properties, length should be >= longest string value, format and informat should either be missing, or length long enough to show full text (i.e. format yourstring $3. - will only show 3 characters even though the full one is stored), and resizing the column doesn't work, then I would suggest you contact SAS support as there is something wrong there.

[JF_Gonzalez]

This was it! The Length is showing as 75, while the Format is only $7., which is causing the issue.

Thank you!

[Kurt_Bremser]

Concur with @RW9. Inspect the formats, and if that is not the reason, contact SAS TS. And let us know afterwards what was going on.