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;
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.