Hi all - I googled and only found 1 reference to this specific warning message, which in that case is about SAS "Scalable Performance Data Server" and says that the character string would be truncated to 200 characters and there's a Hotfix.
But I am using regular SAS 9.4, and am using the following within proc sql to create an MD5 hash of many fields in my table:
md5(compress(
FormDescription||ACRFHDUStateNo||ACRFPIDLName||ACRFPIDMName||ACRFPIDFName||ACRFDemDOB||ACRFHDUFrmCmplDt||
ACRFHDUPerson||ACRFHDUPersonPhone||ACRFHDUReptHD||ACRFHDURepStatus||ACRFDateSaved||ACRFLockSubmit||ACRFLockSubmitted
)) as md5_Small format $hex32.
In the log, this message is shown in green:
WARNING: Concatenated strings can be at most 32767 characters.
To check, I created a new variable of all those fields concatenated together, and the longest string wasn't more than 115 characters, and nothing was truncated. When I added that new long concatenated string variable to the proc sql command, the referenced warning message was shown twice in the log.
I haven't seen this particular warning before, and would just like to make sure it won't bite me if I ignore it as it doesn't seem to apply and the data I'm working with would never seem to exceed even 200 characters, getting nowhere near 32k. Thank you.
To verify this you would need to look at the variable assigned lengths (not after the compress) to see what SAS is expecting. Using || will concatenate with all trailing spaces and such so it can produce a large string if the lengths of the string are set to a large number. You may have had a string that was larger than expected.
That's just a guess though, not really sure.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.