BookmarkSubscribeRSS Feed
knveraraju91
Barite | Level 11

Dear,

I need to help in my code in data step two below. In my actual program i had to create a macro variable using proc sql and use it in a data step similar to below. 

In data step two below, i need to create variable 'C' with value='TREATEMENT A Respond'. But i am getting errors. Please help. Thank you

%let treat1=TREATMENT A;
%put &treat1.;
data one;
input a b $;
datalines;
1 a
2 b
;

data two;
set one;
if b='a' then do;
c=&treat1.|| 'respond';
end;run;
3 REPLIES 3
novinosrin
Tourmaline | Level 20
%let treat1=TREATMENT A;
%put &treat1.;
data one;
input a b $;
datalines;
1 a
2 b
;

data two;
set one;
if b='a' then do;
c="&treat1."|| 'respond';
end;run;

 Correction was c="&treat1."|| 'respond';

r_behata
Barite | Level 11
data two;
set one;
if b='a' then do;
c=catx(' ',"&treat1.","respond");
end;
run;

You may also use the CATX function.

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
  • 3 replies
  • 30900 views
  • 3 likes
  • 4 in conversation