Proc Sort Data = Have ; By Id ; Run ;

Data _Null_ ; Set Have ; By Id ;

If First.ID Then Do ; Call Execute( '%Nrtsr( %Detail_RPT( ID =' || ID || ' ) ) ' ) ; End ;

Run ;

Toby Dunn

You can see a lot by just looking. ~Yogi Berra

Do not seek to follow in the footsteps of the wise. Seek what they sought. ~Matsuo Basho

You never know what is enough, until you know what is more than enough. ~William Blake, Proverbs of Hell

From: firepit <FirePitMarta@GMAIL.COM> Reply-To: firepit <FirePitMarta@GMAIL.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: help with macros Date: Thu, 26 Apr 2007 07:36:37 -0700

I have a variable (ID) that I am using within a macro. There are about 800 entries, but only 150 unique ids. Is there a way to write another macro to pick and automatically insert the unique ids after the '='? I can pull out the unique ids with a sql, but I don't know where to go from there. I am not very strong with macros, so any help would be appreciated!

code looks like:

%detail_rpt(ID=123456789); %detail_rpt(ID=123456779); %detail_rpt(ID=123456769); %detail_rpt(ID=123456759); . . . . .

_________________________________________________________________ Mortgage rates near historic lows. Refinance $200,000 loan for as low as $771/month* https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f8&disc=y&vers=689&s=4056&p=5117