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;
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.