Finding the distinct values along with all the columns from the previous table

[Sandeep77]

Hi all,

I am trying the find the distinct icustomerid. But when I do that it does not give me the other columns from the previous table. I want the output to just show the distinct icustomerid with all the columns from the previous table. Here is a sample dataset:

Data Test;
infile cards expandtabs;
input icustomerid debt_code Lettered;
datalines ;
125 4413245 1
125 4426817 1
782 4423817 2
972 4422740 2
1052 4429532 2
1052 4419588 1
1052 4419420 3
2294 4428625 3
;
run; 

Proc sql;
create table distinct_customer as 
select distinct icustomerid
from All_letters;
quit;

[Kurt_Bremser]

Which of the other values should be taken when there are multiple observations? You need to have a rule for this.

[ballardw]

What is a "previous table"?

You need to provide an example of the desired output given your input example data set.

[PaigeMiller]

Please show us the desired output from this data and from this PROC SQL. If you want distinct levels of icustomerid, its not clear what you want to see in the other columns.

PS: from now on, please show us the desired output, rather than making us ask.