I have a field named Product with some fields having trailing and leading spaces. What code should I use to spot all the products with leading and trailing space out of million observations?
The spaces below are denoted as ...
Product
Milk..
..Banana
Orange..
Pear..
SAS stores character strings as fixed length fields so any short string is padded with spaces to the length of the field. Hence there is no such things as "trailing" spaces. To find character strings with leading spaces just test if it starts with a space.
if product =: ' ' then do;
....
end;
SAS stores character strings as fixed length fields so any short string is padded with spaces to the length of the field. Hence there is no such things as "trailing" spaces. To find character strings with leading spaces just test if it starts with a space.
if product =: ' ' then do;
....
end;
Trailing spaces are inconsequential in SAS as it only handles fixed length character strings; i.e. all character strings are padded with spaces. The number of leading spaces is given by LENGTH(Product) - STRIP(Product).
PG
If what you mean "trailing" is to find how many blanks are padded, you could try:
lengthc(product)-length(product);
Haikuo
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.