BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Amanda_Lemon
Quartz | Level 8

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_SAS
SAS Super FREQ

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;

View solution in original post

2 REPLIES 2
Rick_SAS
SAS Super FREQ

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;
Amanda_Lemon
Quartz | Level 8
It works! Thank you so much!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1110 views
  • 0 likes
  • 2 in conversation