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
