Hi Dr, I can understand your frustration. You might try removing the RANGE keyword for the import as well (it names the worksheet in the file). On my Mac system, I can go to a 'Terminal' window and type/execute the following bolded command and I see 3 files in the folder listed. $ ls /SASUniversityEdition/myfolders/sasuser.v94/ HM1.sas Program 1.sas addicts.xls So I can see my Excel file of 'addicts.xls' plus other files. This is what I also see in the left pane of the SAS window under My Folders. I created the /SASUniversityEdition folder on the top level of my system (usually 'Macintosh HD') as well as the 'myfolders' folder underneath that. After doing that, the next time I signed into SAS, the 'sasuser.v94' folder was created for me. I would not believe that it would make much difference if I had created (but ownership of the folder might be different). Your /SASUniversityEdition folder may be under a different folder (such as your username on the Mac). Also make sure your shared folder setup allows FULL access (under Virtual Box Devices). As to the macro. This syntax works for me: %let path=/folders/myfolders/sasuser.v94 ; libname foo "&path" ; PROC IMPORT OUT= work.addicts DATAFILE= "&path./addicts.xls" DBMS=xls REPLACE; * RANGE="addicts"; GETNAMES=YES; MIXED=NO; * SCANTEXT=YES; * USEDATE=YES; * SCANTIME=YES; RUN;/** Import an XLS file. **/ 45 %let path=/folders/myfolders/sasuser.v94 ; 46 libname foo "&path" ; NOTE: Libref FOO was successfully assigned as follows: Engine: V9 Physical Name: /folders/myfolders/sasuser.v94 47 48 PROC IMPORT OUT= foo.addicts 49 DATAFILE= "&path/addicts.xls" 50 DBMS=xls REPLACE; 51 * RANGE="addicts"; 52 GETNAMES=YES; 53 54 MIXED=NO; 55 * SCANTEXT=YES; 56 * USEDATE=YES; 57 * SCANTIME=YES; 58 59 RUN; NOTE: The import data set has 238 observations and 6 variables. NOTE: FOO.ADDICTS data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds
... View more
