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: 19,775

Re: Fomatting

Posted in reply to aniketwagare0

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: 7,768

Re: Fomatting

Posted in reply to aniketwagare0

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: 11,343

Re: Fomatting

Posted in reply to aniketwagare0

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
  • 255 views
  • 2 likes
  • 4 in conversation