topic Re: How to compare xpt files in SAS Programming

How to compare xpt files

knveraraju91 — Fri, 09 Oct 2020 04:51:37 GMT

Dear,

I need compare to two sets of xpt files in different folders. How to compare the xpt datasets and find differences. Please suggest.

Thank you

Re: How to compare xpt files

SASKiwi — Fri, 09 Oct 2020 05:30:40 GMT

Extract the datasets from the XPT files into normal SAS datasets and then use PROC COMPARE to check difference between the datasets:

libname testlib xport 'c:\temp\MyFile.xpt'; 
proc copy in=testlib out=work; 
  select MyTable1 MyTable2; 
run;

proc compare base = Mytable1
             compare = MyTable2;
run;

Re: How to compare xpt files

ballardw — Fri, 09 Oct 2020 14:31:51 GMT

If the dataset names might be the same then import into two different libraries then compare.