Date: Wed, 26 Oct 2005 08:14:29 -0700
Reply-To: "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Subject: The SUM function
Content-Type: text/plain; charset="us-ascii"
Whups again, guess I need some coffee.
Thanks Chang, I had it on my mind and
forgot to go back and put in the dataset
criteria. This does nicely now. Third
time is the charm.
* build same suffix arglist ;
%* handle with or without libref ;
%if %index(&ds,.) eq 0 %then
proc sql noprint;
select distinct name into :samesfx separated by ','
where upcase(libname) eq upcase("&_lib")
and upcase(memname) eq upcase("&_ds")
and name like "%nrstr(%%)&suffix.";
%put samesfx var list is >&samesfx<;
%sumsfx(sample,count); * create same suffix variable list ;
abcdsum = sum(&samesfx);
Senior Programmer Analyst, IM&R
Russell Investment Group
Global Leaders in Multi-Manager Investing
> The information contained in this message is intended only for the use
> of the recipient named above. This message may contain confidential
> or undisclosed information. If the reader of this message is not the
> intended recipient or an agent responsible for delivering to the
> intended recipient, you are hereby notified that you have received
> this message in error, and that any review, dissemination,
> distribution or copying of it is strictly prohibited. If you have
> received this message in error, please notify us by telephone
> immediately at 253-439-2367. Thank you for your cooperation.