topic Re: Fomatting in SAS Programming

Fomatting

aniketwagare0 — Mon, 19 Sep 2016 19:23:53 GMT

How to remove leading and trailing spaces from excel fine?

Re: Fomatting

Reeza — Mon, 19 Sep 2016 19:48:25 GMT

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.

Re: Fomatting

ballardw — Mon, 19 Sep 2016 19:48:41 GMT

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;

Re: Fomatting

aniketwagare0 — Mon, 19 Sep 2016 19:53:10 GMT

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.

Re: Fomatting

Kurt_Bremser — Tue, 20 Sep 2016 07:01:54 GMT

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.