Statistical programming, matrix languages, and more

use of sas base functions within PROC IML

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

use of sas base functions within PROC IML

Hi all,

at first an example:

PROC IML;

   a = {1 2 3} ; b = {1,2,3}; c = {1 2 3, 2 3 4, 3 4 5}  ;

   ssq_a       = SSQ(a);

   sum_b       = SUM(b);

   median_c    = MEDIAN(c);

      print a b c       ssq_a       sum_b       median_c    ;

   std_a = STD(a)    ;

   std_c = STD(c)    ;

      print       std_a       std_c ;

QUIT  ; *proc iml ;

My question: In the SAS Online Doc: http://support.sas.com/documentation/cdl/en/imlug/59656/HTML/default/viewer.htm#langref_sect315.htm there is a list of the "Base SAS Functions Accessible from SAS/IML". As you can see, if you run the example above, only some of the listed base functions work, like SUM, SSQ or MEDIAN, but not STD or CV. How can I use the sas base functions like STD, CV,... in IML?

Thank you in advance for every tip, best regards,

saibot


Accepted Solutions
Solution
‎11-02-2011 01:30 PM
SAS Super FREQ
Posts: 3,236

use of sas base functions within PROC IML

1) This issue is discussed and solved in Section 4.9 of my book, Statistical Programming with SAS/IML Software.

2) If you are using SAS IML 9.22 or beyond, you can use the VAR function, and of course STD=sqrt(VAR(..)). SAS 9.3 supports the STD function directly.

For more on this topic, see my blog: http://blogs.sas.com/content/iml/2011/06/08/calling-base-sas-functions-from-sasiml-how-to-handle-arg...

View solution in original post


All Replies
Solution
‎11-02-2011 01:30 PM
SAS Super FREQ
Posts: 3,236

use of sas base functions within PROC IML

1) This issue is discussed and solved in Section 4.9 of my book, Statistical Programming with SAS/IML Software.

2) If you are using SAS IML 9.22 or beyond, you can use the VAR function, and of course STD=sqrt(VAR(..)). SAS 9.3 supports the STD function directly.

For more on this topic, see my blog: http://blogs.sas.com/content/iml/2011/06/08/calling-base-sas-functions-from-sasiml-how-to-handle-arg...

Occasional Contributor
Posts: 11

Re: use of sas base functions within PROC IML

Thank you very much for your help, Rick. I tried the function GetArgList that you proposed in your blog and it worked fine.

I am very surprised that the use of such elementary functions in IML is so complicated. In some cases, for example for such simple functions like STD or CV, the programming "by hand" is easier to read than the three steps "GetArgList --> Creation of Macro Variable --> Use of SAS-Base function with macro variable". But as more base functions are available in higher SAS versions, it seems that SAS is working on that topic.

Thank you and best regards,

saibot

Post a Question
Discussion Stats
  • 2 replies
  • 208 views
  • 0 likes
  • 2 in conversation