topic Re: Tranwrd : Replacing in all columns in SAS Programming

Tranwrd : Replacing in all columns

SASdevAnneMarie — Mon, 02 May 2022 08:22:30 GMT

Hello Experts,

Do you know please ho to replace all "." in all columns by the ",".

I run this code, but I have no columns in my data result :

array Var _character_;
            do over Var;
            Var=tranwrd(Var,'.',',');
            end;

Thank you for your help !

Re: Tranwrd : Replacing in all columns

andreas_lds — Mon, 02 May 2022 08:44:32 GMT

Please post the complete log of the step you used.

Re: Tranwrd : Replacing in all columns

Patrick — Mon, 02 May 2022 10:18:06 GMT

The code snippet you've posted is syntactically correct and should work ...as long as you run it AFTER the location in the data step where the character variables of interest get created during the compilation phase (i.e. after a set, merge, attrib etc. statement).

Re: Tranwrd : Replacing in all columns

Tom — Mon, 02 May 2022 14:33:05 GMT

@SASdevAnneMarie wrote:

Hello Experts,

Do you know please ho to replace all "." in all columns by the ",".

I run this code, but I have no columns in my data result :
array Var _character_;
            do over Var;
            Var=tranwrd(Var,'.',',');
            end;
Thank you for your help !

That will not create zero variables. It won't create ANYTHING at all.

You need to include that code in a DATA step.

data want;
  set have;
  array Var _character_;
  do over Var;
    Var=tranwrd(Var,'.',',');
  end;
run;