topic Re: Call Execute in SAS Programming

Call Execute

Amanda_Lemon — Fri, 29 Jun 2018 17:45:40 GMT

Hello,

I am trying create a variable that would list names for my interaction variable. Specifically, I have a list of names of my IVs, and I want to create a list of names of my IVs by Gender.

The table I have with IVs' names looks like this:

IV_name

Race

Age

SES

Education

The table I want should look like this:

IV_name Interaction_name

Race Race_BY_Gender

Age Age_BY_Gender

SES SES_BY_Gender

Education Education_BY_Gender

Here is what I tried but it doesn't work...

data set2;
set set1;
call execute('Interaction_name = '||strip(IV_name)||'_BY_Gender;');
run;

What am I doing wrong?

Thank you in advance.

Re: Call Execute

Rick_SAS — Fri, 29 Jun 2018 18:27:36 GMT

Just use straight concatenation. No need for CALL EXECUTE.

data set1;
length IV_name $10;
input IV_name $;
datalines;
Race
Age
SES
Education
;

data set2;
set set1;
Interaction_name = catt(IV_name, '_BY_Gender');
run;

proc print data=set2 ;run;

Re: Call Execute

Amanda_Lemon — Mon, 02 Jul 2018 13:18:35 GMT

It works! Thank you so much!