topic Re: translate without spacing in SAS Programming

translate without spacing

yonib — Sun, 14 Sep 2008 06:59:49 GMT

If I have this obs: yyy"y www qqq and i want to get yyyy without the space,
what should i do?

Re: translate without spacing

sbb — Sun, 14 Sep 2008 16:47:09 GMT

Use the COMPRESS function in a SAS DATA step.

Scott Barry
SBBWorks, Inc.

Re: translate without spacing

yonib — Sun, 14 Sep 2008 17:09:41 GMT

It will not solve my problem beacuse if i have yyy"y www qqq and
I will use compress(translate(var,' ' ,'"'));
The result will be this:yyyywwwqqq
And this is not what im looking for.....

Re: translate without spacing

deleted_user — Mon, 15 Sep 2008 02:15:54 GMT

use input them to indicate the line number
data temp;
input y 1-5 m ...;
then use compress to compress the variable y
them combine them in the way you like

Re: translate without spacing

Patrick — Mon, 15 Sep 2008 12:08:16 GMT

The following code does what you asked for.
data _null_;
have='yyy y www qqq ';
have=tranwrd(have,'y y','yy');
put have=;
want=scan(have,1);
put want=;
run;

More general solutions would be possible - especially with RegEx - but you would have to tell us a bit more in detail what the problem is about you want to solve.

Re: translate without spacing

sbb — Mon, 15 Sep 2008 12:59:45 GMT

Read the DOC on the COMPRESS function and you will see that you can supply the specific character(s) to be compressed.

Scott Barry
SBBWorks, Inc.

Re: translate without spacing

yonib — Tue, 16 Sep 2008 18:27:41 GMT

Patrick and Sbb ,
Thanks alot for your program ideas.
thay help me alot!!!