Hi, I've been trying to import an excel file to SAS on Demand, which I did. But when I run it, it says "The table "WORK.IMPORT" cannot be opened because it does not contain any columns". There are multiple columns in the excel file I don't know why it's not reading it. I need help with this. I've attached it all below for you to understand what I'm talking about. this is the log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 /* Generated Code (IMPORT) */ 74 /* Source File: PA Database-Class of 2017.xlsx */ 75 /* Source Path: /home/u58459983/sasuser.v94 */ 76 /* Code generated on: 4/22/21, 3:17 AM */ 77 78 %web_drop_table(WORK.IMPORT); NOTE: Table WORK.IMPORT has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 189.00k OS Memory 32900.00k Timestamp 04/22/2021 07:24:52 AM Step Count 111 Switch Count 2 Page Faults 0 Page Reclaims 20 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 79 80 81 FILENAME REFFILE '/home/u58459983/sasuser.v94/PA Database-Class of 2017.xlsx'; 82 83 PROC IMPORT DATAFILE=REFFILE 84 DBMS=XLSX 85 OUT=WORK.IMPORT; 86 GETNAMES=YES; 87 RUN; NOTE: The import data set has 0 observations and 0 variables. NOTE: WORK.IMPORT data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2581.68k OS Memory 35460.00k Timestamp 04/22/2021 07:24:52 AM Step Count 112 Switch Count 2 Page Faults 0 Page Reclaims 557 Page Swaps 0 Voluntary Context Switches 14 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 160 88 89 PROC CONTENTS DATA=WORK.IMPORT; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.05 seconds user cpu time 0.05 seconds system cpu time 0.00 seconds memory 2598.18k OS Memory 33928.00k Timestamp 04/22/2021 07:24:52 AM Step Count 113 Switch Count 0 Page Faults 0 Page Reclaims 152 Page Swaps 0 Voluntary Context Switches 2 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 16 90 91 92 %web_open_table(WORK.IMPORT); 93 94 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 106
... View more