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.
From: firstname.lastname@example.org [mailto:email@example.com]
On Behalf Of Suren gc
Sent: Friday, March 28, 2008 1:34 PM
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?
I would want to select distinct products and create a dataset like this:
A 1 B 3 C 2 D 3