topic Re: checking for specific values in SAS Programming

checking for specific values

Aexor — Wed, 26 May 2021 12:07:25 GMT

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!

Re: checking for specific values

Tom — Wed, 26 May 2021 13:01:42 GMT

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.

Re: checking for specific values

mkeintz — Wed, 26 May 2021 13:03:13 GMT

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.

Re: checking for specific values

Reeza — Wed, 26 May 2021 16:06:44 GMT

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!