We are running into issues with Dictionalry.Columns data for a file what we read in when the headings/labels on that file are over 64 characters long. When we read the file in SAS process and then run
proc sql;
select name, label
from DICTIONARY.COLUMNS A
"label" colummn data is truncated to 64 characters so we don't see the entire value in this column.
Anybody ran into this issue before, what can be done to resolve it? Is there a setting or anything we can do to fix it?
We are on 9.4 M5.
Thank you!
What’s the format, informat and length of the variable?
You can get that from PROC CONTENTS on the output data set.
Format and Informat is $1
Lenght is 1
Lenght for this label column is 256
LINESIZE=132
This is another message we get in Test
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Name has been converted to CHAR data type.
We believe this is all related but don't understand how to code around it OR why we get this error in Test but not Prod system. Both systems are V9 engine.
Sounds like it's an issue for Tech Support then.
V9 is a bit vague though, but the SASHELP libraries have been around a long time and there shouldn't be these types of issues.
@Elena_ziemke_capblurcross_com wrote:
We believe this is all related but don't understand how to code around it OR why we get this error in Test but not Prod system. Both systems are V9 engine.
Where are you displaying the results? If you are using the listing destination (output window not Resuts) your line length may be too short to display everything on one line. Names may be 32 characters and if you are only seeing 64 characters in a label that may mean your linesize is 100 or less.
Create a table and examine the table properties. The label should have a length of 256.
I have no troubling labels from my data sets longer than 64 characters if sent to a table.
D’oh, @ballardw answer is correct. I missed the fact that you’re not creating a table.
Create a table and use PROC PRINT on it after and use ODS HTML it should be fine.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.