I have a dataset with about 500,000 records in it and every one of my character variables has a length of 255. I would like to shorten them without truncating any values. I can make a guess, but I don't want to do that. I haven't been able to figure out a way to see what the longest value is. Let's say the longest piece of text only uses 25 of the 255 spaces available. How do I figure that out? This is a static dataset so once I find what the true length of the longest value for a variable is, I do not need to worry about any future values going any longer than that. Any help would be most appreciated.
... View more