I finally pulled through. Below is my working macro code.   %macro KW_MC (obsvar,classvar,dataname,alpha); proc npar1way data=&dataname;  class &classvar; var &obsvar; run; %mend; /*invoke the KW_MC macro*/ %KW_MC(obsvar= x, classvar= y, dataname=a , alpha=0.05); ... View more

@FabeehaSheikh1 wrote: nothing wrong with proc compare. This was one of the interview questions. I want to compare all variables and values it contains in the dataset without using proc compare. Hence, this question. In an interview question my response would start with the "what do you want to know" from the comparison. Some of the table properties are in Dictionary.tables for Proc SQL (or sashelp.vtables for other procs). Variable properties in Dictionary.columns or sashelp.vcolumns . Value comparisons get into, most likely some form of Proc SQL or Data step merge/update/modify or similar,l depending on the actual questions about the values. Big difference in approaches of if the question involves equality of values, specific combinations of values or something like how close are the values such as comparing the results of two different models where you "know" the values of the predicted variable(s) are likely to differ but by how much. (Which might well be doable inside the modeling proc if careful).   No reason to go into a lot of code for other things that aren't needed/wanted to answer specific questions. ... View more