|Date: ||Tue, 21 Dec 1999 16:20:20 -0500|
|Reply-To: ||Howard Schreier <Howard_Schreier@ITA.DOC.GOV>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Howard Schreier <Howard_Schreier@ITA.DOC.GOV>|
|Subject: ||Re: proc compare and list of K vars|
|Content-Type: ||text/plain; charset=US-ASCII|
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
> 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.