DATA Step, Macro, Functions and more

Fomatting

Reply
Occasional Contributor
Posts: 13

Fomatting

How to remove leading and trailing spaces from excel fine?

Super User
Posts: 17,869

Re: Fomatting

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.

Occasional Contributor
Posts: 13

Re: Fomatting

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.

Super User
Posts: 6,962

Re: Fomatting

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 10,521

Re: Fomatting

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;

 

Ask a Question
Discussion stats
  • 4 replies
  • 232 views
  • 2 likes
  • 4 in conversation