topic Distnict values for a Column in SAS Programming

Distnict values for a Column

vishyy — Tue, 04 Apr 2017 16:16:56 GMT

Hi All.

I have a huge dataset which has various coulmns(variables).

I want to find different values that exist in the dataset for a particular variable.

Thanks in advance

Vishyy

JoshB — Tue, 04 Apr 2017 16:20:41 GMT

Two approaches I use often.

PROC SQL

proc sql;
  create table WANT as
    select DISTINCT VARIABLE
    from HAVE;
quit;

SORT PROCEDURE

proc sort data=HAVE(keep=VARIABLE) nodupkey out=WANT;
  by VARIABLE;
run;

Astounding — Tue, 04 Apr 2017 16:38:38 GMT

To get just a little more information, you could try:

proc freq data=have;

tables variable / missing;

run;

Now you'll see how often each value appears in your data set.