LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 25 Feb 2008 15:28:41 -0500
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Subject:      Re: Efficient matrix multiplication.

On Mon, 25 Feb 2008 11:42:13 -0800, RodrigoLopezAlsina@GMAIL.COM wrote:

>I am trying to multiply two matrixes in SAS in an efficient way. > >I have one 5millionx40 and a 40x40 matrix that I want to multiply >together. I can do this using PROC IML, but I just found out that the >machine I will be using doesn't have this package so I have to do it >in a Data step. > >I have tried using PROC SQL but it is terribly inefficient (takes >hours to do what IML does in minutes). > >Do you have a suggestion of how I could tackle this problem in an >efficient way? > >Thanks in advance. > >R

1. How sparse are the 2 matrices? What fraction of the cells are zero or missing?

2. Are the 2 martrices stored in SAS data sets of the indicated dimensions? If not, how are they stored?

3. Please post your SQL code.


Back to: Top of message | Previous page | Main SAS-L page