Re: checking for specific values

Aexor · Posted 05-26-2021 08:07 AM

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 · Posted 05-26-2021 09:01 AM

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 · Posted 05-26-2021 09:03 AM

Why?

And

Do you want this just for numeric vars, character vars, or all vars?
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.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Reeza · Posted 05-26-2021 12:06 PM

Let's break this down further:

How to get the number of unique values in a single column, in a data set?
How to do #1 for all of the data sets in a library?
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!

checking for specific values