BookmarkSubscribeRSS Feed
Obsidian | Level 7



it seams that I have to build my own a module which replicates functionality of the Mathematica function "MAP". Or maybe somebody has already a solution for that?


In Mathematica you can map functions to a list:


In our IML case we have to make a loop over cashflows which we want to discount (using an own discFactor_s Function). 


do i = 1 to nrow(cf_m);
cf_d_v[i] = cf_m[i, 3] /*CF_AMT*/ # discFactor_s(discToDate_s, cf_m[i, 2] /*CF_DT*/, forward_m /*QUOTE_DT FROM_DT TO_DT QUOTE_RT*/);

But we would like to apply the cashflow  lines of the matrix to the function discFactor_s without a loop (we would like to avoid loops where ever possible):


cf_d_v = MAP[discFactor_s(discToDate_s, #[2], forward_m), cf_m)]....


#[2] -> the map function should take each row from the matrix cf_m  and extract the value from second column.

In Mathematica there is # used as represant of the list item taken from the list (in this case cf_m).


Does exist a comfortable solution for that?


Thanks in advance!






If cf_m is a matrix, then implement discFactor_s in a vectorized form so that the second argument can be a column vector and the function returns a column vector. Then the operation you want is 

cf_d_v = cf_m[, 3] # discFactor_s(discToDate_s, cf_m[, 2], forward_m);


If that doesn't answer your question, then please post a program that includes sample data, a sample function, and the output that you want.

Obsidian | Level 7

Thanks for the answer and your fast reply. Yes, that would be also a solution. But I thought about a general solution for such problems. Now I have tryed to built one (although it does not directly solves the problem, it goes into the direction of my desired function)


With pride 🙂 I present a MAP function in SAS IML  using the new SAS IML LISTS object...


proc iml;
start map(f, list);
n_list_l = ListLen(list);
list_out = ListCreate(n_list_l);
do i = 1 to n_list_l;
	call execute("result = " + f + ";");
	call ListSetItem(list_out, i, result);
measure = list_out;
finish map;

/*Define list of values (matrices)*/
list_input = [{1, 2}, {3, 4}, {5, 6}];
/*use new map function to apply specific items of the list*/
output = map("list$i[1]#list$i[2]", list_input);

/*Printing Content of the resulting list*/
package load ListUtil;
call listprint(output);

If you use the new "map" function you have to use the reserved words "list" and "i" within the first parameter of the function.... "list" refers always to the 2nd parameter of the map function. And "i" is the index running through the list. So in the first parameter you can execute some sort of operation or existing function which is applied or mapped to each entry in the list. The output is again a list of generic items.


Any suggestions for improvement very welcome...



That's fine. As you demonstrate, lists and the CALL EXECUTE subroutine are two powerful tools that provide great flexibility. For a few additional thought about using CALL EXECUTE to implement functions specified by a string, see "Evaluate a function by using the function name in SAS/IML."


My only substantive comment is that your goal was to perform the computation "without a loop (we would like to avoid loops where ever possible)."  You haven't done that. You've merely put the loop into a module so that it is hidden.


I realize that your actual computation is more complicated than your example, but if you are seeking efficiency, you can use matrices instead of lists and avoid the loop:


/*Define list of values (matrices)*/
input = {1  2, 
         3  4, 
         5  6};
output = input[,1] # input[,2];




Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

From The DO Loop
Want more? Visit our blog for more articles like these.
Discussion stats
  • 3 replies
  • 2 in conversation