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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.