Okay, let's define them.

%let trt11 = 101 ; %let trt12 = 102 ; %let trt13 = 102 ; %let trt1 = 21 ; %let trt2 = 22 ; %let trt3 = 23 ; %macro sqldata; data sqlman; retain total total1 0; %do i=1 %to 3; total1=total1 + &&&trt1&i.; total=total+&&&trt&i.; output; %end; run; %mend; %sqldata

Now we get

NOTE: Line generated by the macro variable "I". 1 &211

The problem is too many ampersands. Try

%macro sqldata; data sqlman; retain total total1 0; %do i=1 %to 3; total1=total1 + &&trt1&i.; total=total+&&trt&i.; output; %end; run; %mend; %sqldata

Ed

Edward Heaton, Senior Systems Analyst, Westat (An Employee-Owned Research Corporation), 1600 Research Boulevard, Room RW-3541, Rockville, MD 20850-3195 Voice: (301) 610-4818 Fax: (301) 610-5128 mailto:EdHeaton@westat.com http://www.westat.com

-----Original Message----- From: Nagakumar Sridhar [mailto:nsridhar@atherogenics.com] Sent: Thursday, May 15, 2003 3:54 PM To: Ed Heaton Subject: Re: Help with a macro

Ed:

They are defined in an sql just prior to this where I take the count of all ae's for the 3 treatment groups and put them into trt1-trt3 and the count of visits to trt11-trt13.

I should have included that.

Regards Kumar ----- Original Message ----- From: "Ed Heaton" <EdHeaton@westat.com> To: "'Nagakumar Sridhar'" <nsridhar@ATHEROGENICS.COM> Sent: Thursday, May 15, 2003 2:48 PM Subject: RE: Help with a macro

> Kumar, > > You are looking for macro variables called trt11, trt12, trt13, trt1, trt2, > and trt3. You don't have such macro variables; where are they defined? > > Ed > > -----Original Message----- > From: Nagakumar Sridhar [mailto:nsridhar@ATHEROGENICS.COM] > Sent: Thursday, May 15, 2003 1:49 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Help with a macro > > > I have written a macro: > > > %macro sqldata; > data sqlman; > retain total total1 0; > %do i=1 %to 3; > total1=total1 + &&&trt1&i.; > total=total+&&&trt&i.; > output; > %end; > run; > %mend; > > %sqldata; > > > which is supposed to go thro' 3 iterations (the 4th one will fail) and pick > up the values for trt1. It is not working when the value of trt3 is zero > (returns an error that says it was unable to resolve trt3). > > > > I'd appreciate any help in this regard. > > > > Kumar Sridhar