Thank you very much it worked. Below is my log; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc import out=X datafile = "/folders/myfolders/Test.xlsx" 74 dbms=xlsx replace; 75 run; NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. NOTE: The import data set has 1797 observations and 13 variables. NOTE: WORK.X data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.91 seconds cpu time 0.89 seconds 76 Quit; 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90 I got 100 records when I used the import wizard because the code was giving me the "physical file does not exist" error. It happens as other users suggested that it was just the first page of records out of many I was looking at. The import wizard does work and brings in all of my data. Thank you very much again.
... View more