|
Suren:
You are describing the behaviour of SAS PROC SORT nodupkey ... It
arbitrarily takes the first instance of the value of a key in the obs
sequence of a SAS dataset.
S
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Suren gc
Sent: Friday, March 28, 2008 1:34 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Distinct on proc sql -- Clarification
I want to select distinct variables from first column in the select
clause, however, it doesnot matter whether variables of other columns
are duplicated. Would this possible?
Data:
product Num
A 1
A 2
B 2
B 3
C 2
D 3
A 2
B 4
I would want to select distinct products and create a dataset like this:
A 1 B 3 C 2 D 3
Thanks,
Suren
| 
