topic Re: need to find title and output of the follwing code- thanks in SAS Programming

need to find title and output of the follwing code- thanks

chann1313 — Wed, 02 Mar 2016 00:56:12 GMT

data txns; do amt = 40000, 42000, 48000;

output;

end;

run;

data process;

set txns; if amt >= 50000 then do;

%let title_suffix = NOTE: Large Transaction Amounts!!;

large_tran_flag = 'Y';

end;

run; title "Transaction Report &title_suffix";

proc print data = process:

run;

another one :

Given the following array, how would you total the values

array abc(5) ( 12 5 . 17 20);

Re: need to find title and output of the follwing code- thanks

RW9 — Wed, 02 Mar 2016 09:37:07 GMT

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;

Re: need to find title and output of the follwing code- thanks

chann1313 — Thu, 03 Mar 2016 11:37:51 GMT

Thanks rw9, I m trying to learn.