Date:         Tue, 9 Oct 2001 10:19:30 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: grabbing the unique variable from a data set
Comments: To: bobby <itp_group@HOTMAIL.COM>
Content-type: text/plain; charset=iso-8859-1

if data volumes are small enough to allow sorting the data, use the option of proc sort NODUPKEY
proc sort data=bobs.dataset out=uniques NOdupKey ;
     by that_variable;
run;
good luck
Peter Crawford


Datum:         09/10/2001 07:12
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    bobby <itp_group@HOTMAIL.COM>

Betreff:       grabbing the unique variable from a data set
Nachrichtentext:

Hi all,
I am trying to work out a way to grab teh unique variables from a data
set
example if a data set contained:
bob
bob
bob
kill
bob
kill
eat
I would like it to return a dataset containing bob, kill, eat

NOTE: that the strings could be anything (unknown) it must simply just
return the unique variables of a column in a dataset.
Thankyou
Hugh





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.