topic Finding the distinct values along with all the columns from the previous table in New SAS User

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

Sandeep77 — Thu, 31 Aug 2023 14:35:20 GMT

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;

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

Kurt_Bremser — Thu, 31 Aug 2023 14:40:15 GMT

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

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

ballardw — Thu, 31 Aug 2023 14:41:18 GMT

What is a "previous table"?

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

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

PaigeMiller — Thu, 31 Aug 2023 14:42:23 GMT

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.