topic Re: Replace space with comma in New SAS User

Replace space with comma

david27 — Thu, 27 Sep 2018 18:53:44 GMT

Team,

I have this and it works fine:

%let have = 1 2 3;
%let want = %sysfunc(tranwrd(%quote(%trim(&have)),%str( ),%str(,)));
%put want=&want.;

But if the user put more than one space between the numbers then it comes up as 1,2,,,3.

The above code will not work for:

%let have = 1 2     3;
%let want = %sysfunc(tranwrd(%quote(%trim(&have)),%str( ),%str(,)));
%put want=&want.;

Please advise.

Thanks

Re: Replace space with comma

novinosrin — Thu, 27 Sep 2018 19:02:13 GMT

Try

%let have =%sysfunc(compbl( 1 2     3));
%let want = %sysfunc(tranwrd(%quote(%trim(&have)),%str( ),%str(,)));
%put want=&want.;

Re: Replace space with comma

data_null__ — Fri, 28 Sep 2018 13:44:59 GMT

Why do you need to add commas?

Re: Replace space with comma

david27 — Fri, 28 Sep 2018 14:36:50 GMT

These numbers go inside an in statement. if number in (1,2,3). User may also not pass any value to the macro.

Re: Replace space with comma

ballardw — Fri, 28 Sep 2018 17:52:51 GMT

@david27 wrote:

These numbers go inside an in statement. if number in (1,2,3). User may also not pass any value to the macro.

The SAS IN operator does not require commas any more though it used to.

Also for INTEGER values a SAS IN comparison can use a range indicated with a colon: Number in (1:3); is the same as Number in (1 2 3) or Number in (1,2,3).

Re: Replace space with comma

david27 — Fri, 28 Sep 2018 19:36:45 GMT

Thank You team for the responses.

I just learnt about the in operator not requiring comma(,) within parenthesis ACCIDENTALLY just today(because of a programming mistake i did).

By the way---From when did it change?

Re: Replace space with comma

Tom — Sat, 29 Sep 2018 03:26:55 GMT

I have never had to use commas with the IN operator.