I would like to find rows where the variable NAME has 2 or 3 consecutive spaces in the string. I used
find(name,' ');
but it returns all rows. What am I doing wrong?
I suggest you try:
if name ne compbl(name);
Using FIND will locate trailing blanks on strings. SAS character variables are padded with trailing blanks if the text doesn't take up the full variable lengths.
I suggest you try:
if name ne compbl(name);
Using FIND will locate trailing blanks on strings. SAS character variables are padded with trailing blanks if the text doesn't take up the full variable lengths.
find( strip(name) ,' ');
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.
Ready to level-up your skills? Choose your own adventure.