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 (May 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 4 May 2007 19:49:46 +0000
Reply-To:     iw1junk@COMCAST.NET
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ian Whitlock <iw1junk@COMCAST.NET>
Subject:      Re: Call Macro in a loop
Comments: cc: manotickgirl@GMAIL.COM

Summary: Use arrays! #iw-value=1


data out (drop = i j); set in ; array v (30) ; array m (4) ; array s (4) ; array r (*) r1-r30 ;

do i = 1 to dim(r) ; if i in ( 1, .... ) then j + 1 ; r[i] = (v[i] - m[j])/ s[j] ; end ; run ;

Sorry for the dots but you are not trying very hard to be clear about &I in &SUBJ. Unrolling the array with a macro should have minimal affect on the execution time.

If you insist on trying it then try

%macro q ; %local i j ; %do i = 1 %to 30 ; %if &i .... %then %let j = %eval(&j + 1) ; r&i = (v&i-m&j) / s&j ; %end ; %mend q ;

data out ; set in ; %q run ;

If you find the time significantly different, please let us know.

Ian Whitlock ================

Date: Fri, 4 May 2007 11:11:11 -0700 Reply-To: manotickgirl@GMAIL.COM Sender: "SAS(r) Discussion" From: manotickgirl@GMAIL.COM Organization: Subject: Re: Call Macro in a loop Comments: To: sas-l In-Reply-To: <050420071651.27534.463B64920006299E00006B8E220702085305029A06CE9907@comcas> Content-Type: text/plain; charset="iso-8859-1"

I didn't explain it well, sorry, I'll try it again: Table: V1 V2...M1 M2...S1 S2... R1 R2... Gene1 .....(values)... (values) Gene2 .....(values)... (values)

I add variables R1 R2... as follows: R1=(V1-M1)/S1, R2=(V2-M1)/S1... R30= (V30-M4)/S4... I wanna optimize this, I can pass parameters R&I, V&I, M&I and S&I to macro2: %macro macro2(R,V,M,S); data test2; set test1; &R= (&V-&m)/(&s;) run; %mend macro2;

What I need is to go from i=1 to n and form parameters like (R1, V1, M1, S1), (R2, V2, M1, S1) ... with a jump in a counter for m and s every time I find &i in an array &subj.

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