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 (January 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 10 Jan 2003 18:36:32 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: data _null_ and #byvar titles
Comments: To: mbraten@BEAR.COM
Content-Type: text/plain; charset=us-ascii

The data set doesn't have to be sorted if the NOTSORTED option is used in the BY line.

And of course the data don't have to be sorted if the data set is appropriately indexed on the by variables.

-- Manager, Technical Development METRICS Department, First Health West Sacramento, California USA

>>> "Braten, Michael (Exchange)" <mbraten@BEAR.COM> 01/10/03 10:19 AM >>> #byvar / #byval only apply to PROCs in that the dataset going in must be sorted so the output of the Procs be sorted as well.

You can achieve the same effect when you 1) sort the your data set before using it in a _null_ 2) make use of first. processing 3) and use a report header on the file statement.

I admit its a bit more work, but it may fit your needs.

> -----Original Message----- > From: diskin.dennis@KENDLE.COM [SMTP:diskin.dennis@KENDLE.COM] > Sent: Thursday, January 09, 2003 11:25 AM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Re: data _null_ and #byvar titles > > Roland, > > I think #byvar / #byval only apply to PROCs. They would not really make > sense in a datastep. You should already know what your BY variables are. > > FWIW, > Dennis Diskin > > > > > From: Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK>@LISTSERV.UGA.EDU> on > 01/09/2003 10:45 AM > > Please respond to Roland <roland@RASHLEIGH-BERRY.FSNET.CO.UK> > > Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> > > > To: SAS-L@LISTSERV.UGA.EDU > cc: > > Subject: data _null_ and #byvar titles > > > Is there a sensible way to interface with the #byvar and #byval in a title > line when producing a report using data _null_ or do I have to do it the > hard way? > > Roland > -- > "Today's mighty oak is just yesterday's nut, > that held its ground." - David Icke

**************************************************************** Bear Stearns is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. ***********************************************************************

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