Hello, thanks for the tip! I used your code and ran into the following errors; NOTE: Statements not processed because of errors noted above. 57 ! format <Finish> mmddyy10. ; _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. 58 modify myexcel2; 58 ! format <Start> mmddyy10. ; _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. 59 quit; NOTE: Statements not processed because of errors noted above. NOTE: The SAS System stopped processing this step because of errors. My code: proc import datafile='/folders/myfolders/iPlan/ExcelCompareWorksheets.xlsx' out=work.myexcel dbms=xlsx; range='NewGoat$B2:BJ89'; run; proc import datafile='/folders/myfolders/iPlan/ExcelCompareWorksheets.xlsx' out=work.myexcel2 dbms=xlsx; range='OldGoat$B2:BJ89'; run; proc datasets library=work nodetails memtype=data; /* assumes the two sets are in the library work*/ modify myexcel; format <Finish> mmddyy10. ; modify myexcel2; format <Start> mmddyy10. ; quit; proc compare base=myexcel compare=myexcel2; run;
... View more
