Fomatting

[aniketwagare0]

How to remove leading and trailing spaces from excel fine?

[Reeza]

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.

[aniketwagare0]

I have one excel file with me. I want to proceed with it by applying few Base SAS operation. Because of space it shows error. I want to remove each cell leading and trailing spaces.

[Kurt_Bremser]

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.

[ballardw]

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;