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;
%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';
data two;
set one;
if b='a' then do;
c=catx(' ',"&treat1.","respond");
end;
run;
You may also use the CATX function.
Most simple method:
data two;
set one;
if b = 'a' then c = "&treat1. respond";
run;
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!
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.
Ready to level-up your skills? Choose your own adventure.