Here is what i arrived at /* Generated Code (IMPORT) */ /* Source File: RI Data Set.xlsx */ /* Source Path: /home/u58810830 */ /* Code generated on: 9/29/21, 3:18 PM */ %web_drop_table(WORK.IMPORT2); FILENAME REFFILE '/home/u58810830/RI Data Set.xlsx'; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=WORK.IMPORT2; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.IMPORT2; RUN; %web_open_table(WORK.IMPORT2); 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 /* Generated Code (IMPORT) */ 70 /* Source File: RI Data Set.xlsx */ 71 /* Source Path: /home/u58810830 */ 72 /* Code generated on: 9/29/21, 3:18 PM */ 73 74 %web_drop_table(WORK.IMPORT2); NOTE: Table WORK.IMPORT2 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.00 seconds memory 192.31k OS Memory 25504.00k Timestamp 09/29/2021 08:27:47 PM Step Count 98 Switch Count 2 Page Faults 0 Page Reclaims 15 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 75 76 77 FILENAME REFFILE '/home/u58810830/RI Data Set.xlsx'; 78 79 PROC IMPORT DATAFILE=REFFILE 80 DBMS=XLSX 81 OUT=WORK.IMPORT2; 82 GETNAMES=YES; 83 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 19 observations and 5 variables. NOTE: WORK.IMPORT2 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.01 seconds memory 2765.00k OS Memory 28068.00k Timestamp 09/29/2021 08:27:47 PM Step Count 99 Switch Count 2 Page Faults 0 Page Reclaims 659 Page Swaps 0 Voluntary Context Switches 17 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 84 85 PROC CONTENTS DATA=WORK.IMPORT2; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.03 seconds user cpu time 0.04 seconds system cpu time 0.00 seconds memory 1716.87k OS Memory 26536.00k Timestamp 09/29/2021 08:27:47 PM Step Count 100 Switch Count 0 Page Faults 0 Page Reclaims 122 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 16 86 87 88 %web_open_table(WORK.IMPORT2); 89 90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 100 User: u58810830 Statement Options The CONTENTS Procedure Data Set Name WORK.IMPORT2 Observations 19 Member Type DATA Variables 5 Engine V9 Indexes 0 Created 09/29/2021 15:27:48 Observation Length 84 Last Modified 09/29/2021 15:27:48 Deleted Observations 0 Protection Compressed NO Data Set Type Sorted NO Label Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64 Encoding utf-8 Unicode (UTF-8) Engine/Host Dependent Information Data Set Page Size 131072 Number of Data Set Pages 1 First Data Page 1 Max Obs per Page 1557 Obs in First Data Page 19 Number of Data Set Repairs 0 Filename /saswork/SAS_work18D70001DC82_odaws02-usw2.oda.sas.com/SAS_workAF000001DC82_odaws02-usw2.oda.sas.com/import2.sas7bdat Release Created 9.0401M6 Host Created Linux Inode Number 536894750 Access Permission rw-r--r-- Owner Name u58810830 File Size 256KB File Size (bytes) 262144 Alphabetic List of Variables and Attributes # Variable Type Len Format Informat Label 2 B Char 24 $24. $24. B 3 C Char 14 $14. $14. C 1 Contacts Dataset: Char 16 $16. $16. Contacts Dataset: 4 D Char 14 $14. $14. D 5 E Char 16 $16. $16. E
... View more