How to remove leading and trailing spaces from excel fine?
Yeah, that's not nearly enough information.
Are you reading in a file or creating a file? How are you doing this? Is it a variable or from a procedure...etc etc...
Please provide more details if you want an answer.
Post the offending code and the log that was created, so we can see the exact nature of the ERROR message.
Use the "little running man" and {i} buttons for posting code and log, respectively, as it is then nicely formatted.
If this is data that has been imported into SAS then in a data step:
data want;
set have;
var=strip(var);
run;
will work for one variable. If you have many variables then an array may be best:
data want;
set have;
array c _character_;
do i=1 to dim(c);
c[i]=strip(c[i]);
end;
run;
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.