NE Washington DC newbie user here. Tried using manuals and online help and just a little lost. I am trying to use the proc compare command to compare the data in two tables. However, the two tables of data appear to be sorted differently.
Thus the delimma how to write a query that will order the data in away that I can compare to tables.
libname xdata 'c:\SAS_Testing\ndprod3';
proc compare data=xdata.county_msa compare=xdata.county_msa1 ;
select * from xdata.county_msa
where state_fips = '72'
order by cnty;
The COMPARE Procedure
Comparison of XDATA.COUNTY_MSA with XDATA.COUNTY_MSA1
I'm not sure why you are trying to do this directly in code. If you are using EGuide (the topic of this group), the compare task is under the data tab. It leads you through it and sorts and sets up the keys for you.