|Date: ||Thu, 26 Apr 2007 15:05:48 +0000|
|Reply-To: ||toby dunn <tobydunn@HOTMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||toby dunn <tobydunn@HOTMAIL.COM>|
|Subject: ||Re: help with macros|
|Content-Type: ||text/plain; format=flowed|
Data = Have ;
By Id ;
Data _Null_ ;
Set Have ;
By Id ;
If First.ID Then Do ;
Call Execute( '%Nrtsr( %Detail_RPT( ID =' || ID || ' ) ) ' ) ;
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.
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>
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
I am not very strong with macros, so any help would be appreciated!
code looks like:
Mortgage rates near historic lows. Refinance $200,000 loan for as low as