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 (December 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 16 Dec 2009 12:39:25 -0800
Reply-To:     "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Nordlund, Dan (DSHS/RDA)" <NordlDJ@DSHS.WA.GOV>
Subject:      Re: Loop within a Proc Mixed or Proc Autoreg statement
Comments: To: "Data _null_;" <iebupdte@gmail.com>
In-Reply-To:  <ce1fb7450912161217p31dfd244ge0a54f01708e5b5e@mail.gmail.com>
Content-Type: text/plain; charset=windows-1252

That was the answer to my question. I needed to set BYLINE=1. Thanks.

Dan

Daniel J. Nordlund Washington State Department of Social and Health Services Planning, Performance, and Accountability Research and Data Analysis Division Olympia, WA 98504-5204

> -----Original Message----- > From: Data _null_; [mailto:iebupdte@gmail.com] > Sent: Wednesday, December 16, 2009 12:18 PM > To: Nordlund, Dan (DSHS/RDA) > Cc: SAS-L@listserv.uga.edu > Subject: Re: Loop within a Proc Mixed or Proc Autoreg statement > > What is your setting of the system option BYLINE? If it is 1 then you > should see the regular BYLINE. If BYLINE=1 and you don't see a by > line then I don't understand the question. > > On 12/16/09, Nordlund, Dan (DSHS/RDA) <NordlDJ@dshs.wa.gov> wrote: > > > -----Original Message----- > > > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of > > > Data _null_; > > > Sent: Wednesday, December 16, 2009 11:19 AM > > > To: SAS-L@LISTSERV.UGA.EDU > > > Subject: Re: Loop within a Proc Mixed or Proc Autoreg statement > > > > > > Here is example of TRANSPOSE and BY group processing. Including > > > creating a sample data set. > > > > > > data have; > > > array ptf[25]; > > > do id = 1 to 10; > > > y = rannor(12345); > > > do _n_ = 1 to dim(ptf); > > > ptf[_n_] = rannor(0); > > > end; > > > output; > > > end; > > > run; > > > proc transpose out=tall; > > > by id y; > > > var ptf:; > > > run; > > > data tall; > > > set tall; > > > attrib ptf length=8 label='Portfolio'; > > > ptf = input(substr(_name_,4),f8.); > > > run; > > > proc sort data=tall; > > > by ptf; > > > run; > > > proc mixed data=tall; > > > by ptf; > > > model y = col1 / s; > > > repeated / subject=intercept type=ar(1); > > > run; > > > > > > > > > > Data _null_, > > > > Thanks for the example. I wonder if you (or anyone else) can show how to get > Proc Mixed to display the BY level being used in the output for each run of proc > mixed? Or have I just missed it in the output? > > > > Dan > > > > Daniel J. Nordlund > > Washington State Department of Social and Health Services > > Planning, Performance, and Accountability > > Research and Data Analysis Division > > Olympia, WA 98504-5204 > >


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