Sorry, your first question doesn't make sense, then title can be found on the row indicated by the arrow 3 in the below code plus the text from the macro variable indicated by arrow 2 (note I have updated your to follow some good programmnig practice rules such as indentation and keeping one code line on one line for readbility). Do note that the %let is not condition in this code, macro code is separate from datastep code. Output is marked by arrow 1:
data txns;
do amt=40000, 42000, 48000;
output; <--1
end;
run;
%let title_suffix=NOTE: Large Transaction Amounts!!; <--2
data process;
set txns;
if amt >= 50000 then do;
large_tran_flag = 'Y';
end;
run;
title "Transaction Report &title_suffix"; <--3
proc print data=process:
run;
For your second question - which should be in a separate post - you can use the of array syntax to simplfy your code:
data want;
array abc(5) (12 5 . 17 20);
result=sum(of abc{*});
run;
Sorry, your first question doesn't make sense, then title can be found on the row indicated by the arrow 3 in the below code plus the text from the macro variable indicated by arrow 2 (note I have updated your to follow some good programmnig practice rules such as indentation and keeping one code line on one line for readbility). Do note that the %let is not condition in this code, macro code is separate from datastep code. Output is marked by arrow 1:
data txns;
do amt=40000, 42000, 48000;
output; <--1
end;
run;
%let title_suffix=NOTE: Large Transaction Amounts!!; <--2
data process;
set txns;
if amt >= 50000 then do;
large_tran_flag = 'Y';
end;
run;
title "Transaction Report &title_suffix"; <--3
proc print data=process:
run;
For your second question - which should be in a separate post - you can use the of array syntax to simplfy your code:
data want;
array abc(5) (12 5 . 17 20);
result=sum(of abc{*});
run;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.