checking for specific values

[Aexor]

Hi,

A sas library consists 10 datasets for e.g SASHELP lib, I want to find the variable having maximum number of unique values present in the SASHELP.

Please suggest.

Thanks!

[Tom]

What have you tried?

Do you know how to find the variable you want for a single dataset?

Can you provide an example dataset and explain what you mean by maximum unique values?

I would recommend looking into the NLEVELS option on PROC FREQ.

[mkeintz]

Why?

And

1. Do you want this just for numeric vars, character vars, or all vars?
2. What about ID vars?  They are often unique values for each observation in a data set (like NAME in SASHELP.CLASS), so their cardinality is the same as the number of observations.  There would be no need to do frequencies to find the number of unique values.

[Reeza]

Let's break this down further:

1. How to get the number of unique values in a single column, in a data set?
2. How to do #1 for all of the data sets in a library? 
3. Sort results from #2 and take records/data of interest?

Which steps do you need help with exactly? Please show what ever you've tried so far.

---

@Aexor wrote:

Hi,

A sas library consists 10 datasets for e.g SASHELP lib, I want to find the variable having maximum number of unique values present in the SASHELP.

Please suggest.

Thanks!

---