Hello SASPhile,
This code checks if a new variable has been added to dataset WORK.I compared to WORK.R:
[pre]
proc SQL;
select name into :l0 separated by ' '
from sashelp.vcolumn where LIBNAME="WORK" and memname="I"
;quit;
proc SQL;
select name into :l1 separated by ' '
from sashelp.vcolumn where LIBNAME="WORK" and memname="R"
;quit;
options nosymbolgen;
%put l0=&l0;
%put l1=&l1;
%let d=%EVAL(%LENGTH(&l1)-%LENGTH(&l0));
[/pre]
To check if old variable values have been changed it is good to use suggested proc COMPARE with base=Old dataset Compare=New dataset subsetted to contain old variables only.
HTH, SPR