similar problem with data imported from Access.
FORMAT fname $HEX20.;
PROC PRINT;
VAR fname;
RUN;
I get this: 20444F55474C41532020
20 is ascii for a space.
but TRIM(fname) does not remove the leading space.
ANYALPHA(fname) still returns 2.
Thanks. The joys of regularly programming in 4 different langauges.
in MS:
Returns a string that contains a copy of a specified string
without leading spaces (LTrim),
without trailing spaces (RTrim), or
without leading or trailing spaces (Trim).
IN SAS
Removes trailing blanks from a character string, and returns one blank if the string is missing.
BTRIM Function
is one of the following:
removes the blanks or specified characters from the beginning of the character string.
removes the blanks or specified characters from the end of the character string.
removes the blanks or specified characters from both the beginning and the end of the character string.
Default | BOTH |
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.
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.