topic Re: Create macro var with values separated by space in SAS Programming

Create macro var with values separated by space

Ronein — Mon, 13 Jun 2022 10:12:00 GMT

Hello

Let's say that user define a macro var called vector1 that contain values separated by comma.

The task is to create another macro variable called vector2 that contain same values as vector 1 but values separated by space

What is the way to do it please?

%let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
/*Task-Create macro variable Vector2 that will be equal to
 'RFA07'   'RFA02'   'RFA04'   'BRG92'   'PER1903'*/

Re: Create macro var with values separated by space

PaigeMiller — Mon, 13 Jun 2022 10:14:38 GMT

Use the TRANSLATE function

%let Vector2=%sysfunc(translate,&vector1,%str( ),%str(,));

Re: Create macro var with values separated by space

Ronein — Mon, 13 Jun 2022 10:17:32 GMT

Thanks,get error

26         %let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
27         %let Vector2=%sysfunc(translate,&vector1,%str( ),%str(,));
ERROR: Expected open parenthesis after macro function name not found.

Re: Create macro var with values separated by space

PaigeMiller — Mon, 13 Jun 2022 10:22:16 GMT

I messed up the parentheses. Why don't you try to fix them?

Re: Create macro var with values separated by space

Ronein — Mon, 13 Jun 2022 10:24:07 GMT

%let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
%let Vector2 = %sysfunc(translate(%quote(&Vector1),' ',','));
%put &Vector1;
%put &Vector2;

Re: Create macro var with values separated by space

tarheel13 — Mon, 13 Jun 2022 10:33:40 GMT

Try this.

%let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
%let Vector2=%sysfunc(tranwrd(%quote(&vector1),%str(,),%str( )));
%put &=vector1 &=vector2;

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         %let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
 70         %let Vector2=%sysfunc(tranwrd(%quote(&vector1),%str(,),%str( )));
 71         %put &=vector1 &=vector2;
 VECTOR1='RFA07','RFA02','RFA04','BRG92','PER1903' VECTOR2='RFA07' 'RFA02' 'RFA04' 'BRG92' 'PER1903'
 72         
 73         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: Create macro var with values separated by space

PaigeMiller — Mon, 13 Jun 2022 11:33:09 GMT

@Ronein wrote:

%let Vector1='RFA07','RFA02','RFA04','BRG92','PER1903';
%let Vector2 = %sysfunc(translate(%quote(&Vector1),' ',','));
%put &Vector1;
%put &Vector2;

You want the last two arguments of the TRANSLATE function to be enclosed in %str( ) and not single-quotes. While it works in this case, it may not work in other cases.

%let Vector2 = %sysfunc(translate(%quote(&Vector1),%str( ),%str(,)));