04-04-2017 12:16 PM
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
04-04-2017 12:20 PM
Two approaches I use often.
proc sql; create table WANT as select DISTINCT VARIABLE from HAVE; quit;
proc sort data=HAVE(keep=VARIABLE) nodupkey out=WANT; by VARIABLE; run;
04-04-2017 12:38 PM
To get just a little more information, you could try:
proc freq data=have;
tables variable / missing;
Now you'll see how often each value appears in your data set.