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 (August 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 10 Aug 2004 16:06:24 -0700
Reply-To:     Dale McLerran <stringplayer_2@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dale McLerran <stringplayer_2@YAHOO.COM>
Subject:      Re: QUINTILES: Help needed
Comments: To: Alex <apavluck@GMAIL.COM>
In-Reply-To:  <e2f33a06.0408101117.6f3ee1fe@posting.google.com>
Content-Type: text/plain; charset=us-ascii

Alex,

It is not clear whether you want to identify the values which cut the data into quintiles or if you want to assign the data to quintiles. The suggestion to use PROC RANK with the GROUPS=5 option would assign the data to quintiles. However, if you want to identify the values which cut the data into quintiles, then you could use something like the following:

PROC UNIVARIATE noprint DATA=PRFOLATE; VAR E_LYC E_MET VAR2 VAR3 VAR4; OUTPUT OUT=CUT1 PCTLPTS=20 pctlname=_ pctlpre=E_LYC E_MET VAR2 VAR3 VAR4; OUTPUT OUT=CUT2 PCTLPTS=40 pctlname=_ pctlpre=E_LYC E_MET VAR2 VAR3 VAR4; OUTPUT OUT=CUT3 PCTLPTS=60 pctlname=_ pctlpre=E_LYC E_MET VAR2 VAR3 VAR4; OUTPUT OUT=CUT4 PCTLPTS=80 pctlname=_ pctlpre=E_LYC E_MET VAR2 VAR3 VAR4; TITLE 'QUINTILES FOR CREATION OF CATEGORICAL VARIABLES'; RUN;

data cut; retain pctile; set cut1(in=a) cut2(in=b) cut3(in=c) cut4(in=d); pctile = 20*a + 40*b + 60*c + 80*d; run;

proc print data=CUT;run;

Dale

--- Alex <apavluck@GMAIL.COM> wrote:

> Hello. I am trying to calculate quintiles for multiple continuous > variables. I have come up with the below code but I don't like the > output (1 long line). Is there a better way to do this OR is there a > way to drop a line after each run? > > Thanks, Alex > > > > *****************CODE******************************; > > PROC UNIVARIATE noprint DATA=PRFOLATE; > VAR E_LYC E_MET VAR2 VAR3 VAR4; > OUTPUT OUT=CUT PCTLPTS=20 40 60 80 > pctlpre=E_LYC_ E_MET_ VAR2_ VAR3_ VAR4_; > TITLE 'QUINTILES FOR CREATION OF CATEGORICAL VARIABLES'; > RUN; proc print data=CUT;run; >

===== --------------------------------------- Dale McLerran Fred Hutchinson Cancer Research Center mailto: dmclerra@fhcrc.org Ph: (206) 667-2926 Fax: (206) 667-5977 ---------------------------------------

__________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail


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