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;