Try PROC COMPARE with the LISTBASEVAR and NOVALUES options.

Sometimes it's hard to find an answer in the manuals because it's necessary to synthesize from information in a number of different locations. This was not one of those times.

> From: Panos PAPANIKOLAOU <PapanikolaouP@CARDIFF.AC.UK> > Subject: proc compare and list of K vars > > Dear All, > > i have two data-sets which differ in the number of columns and > rows as well. So, let say: > > A. BASE with N1 cases and K1 variables > > B. ADD with N2 cases and K2 variables > > and K1 > K2 (this also holds true for N1 and N2 but it does not > matter) > > I am wondering how should I use PROC COMPARE to get > an output (a list) of the variables which are in BASE data-set but > NOT in the ADD data-set. That is, I am looking for any suggestions > to use PROC COMPARE and get a list of DK = K1 - K2. > > I would appreciate if I would have any comments and ideas on how > to proceed. SAS statements and codes would be be very welcome > and well received. > > Thank you very much indeed for taking the time to consider my > request. I look forward to hearing from you. > > Regards > Panos