Please look at:     data have; input A B $ C D $; datalines; 1 a 1 a 2 b 1 b 3 c 2 c 4 d 3 d 5 e 4 a ; run; /* replace WORK and HAVE with the name of your actual dataset*/ proc sql noprint; select nobs into : rowcount from dictionary.tables where libname='WORK' and memname='HAVE' ; run; %put &rowcount; /*put the libname.dataset in this procfreq code*/ proc freq data=have nlevels ; ods output Nlevels=Havelevels; run; data want; set HaveLevels (drop=NMissLevels NNonMissLevels); If Nlevels = &rowcount then Duplicates='FALSE'; else Duplicates='TRUE'; run; I had to create a dataset have for the example. Use your dataset libname and dataset name in place of "have".   Note that in the Proc Sql part the library  name and data set are stored in uppercase so the values have to be upper or use functions to make them match. ... View more