1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
87 PROC IMPORT DATAFILE=REFFILE
88 DBMS=CSV
89 OUT=HW1.glass;
90 GETNAMES=YES;
91 RUN;
NOTE: Import cancelled. Output dataset HW1.GLASS already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 247.71k
OS Memory 23456.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 24 Switch Count 0
Page Faults 0
Page Reclaims 120
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
92
93 *The above data step shows that I imported data;
94
95
96 FILENAME REFFILE '/home/u59197232/mylib/bupa.xlsx';
97
98 PROC IMPORT DATAFILE=REFFILE
99 DBMS=XLSX
100 OUT=HW1.bupa;
101 GETNAMES=YES;
102 *The above data step shows I imported data;
103
104 FILENAME REFFILE '/home/u59197232/dataset1/hepa1.sas7bdat';
105
NOTE: Import cancelled. Output dataset HW1.BUPA already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 686.71k
OS Memory 23952.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 25 Switch Count 1
Page Faults 0
Page Reclaims 178
Page Swaps 0
Voluntary Context Switches 6
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
106 PROC IMPORT DATAFILE=REFFILE
107 DBMS=DLM
108 OUT=HW1.hepa1;
109 DELIMITER='';
110 GETNAMES=NO;
111 GUESSINGROWS=MAX;
112 RUN;
NOTE: Import cancelled. Output dataset HW1.HEPA1 already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 197.93k
OS Memory 23456.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 26 Switch Count 0
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
113
114 *The previous step indicates that I imported data;
115 data modified;
116 set hw1.hepa1;
117 rename var1= class
118 var2= age
119 var3= sex
120 var4= steriod
121 var5= antivirals
122 var6= fatigue
123 var7= malaise
124 var8= anorexia
125 var9= liverbig
126 var10= liverfirm
127 var11= spleenpalpable
128 var12= spiders
129 var13= ascites
130 var14= varices
131 var15= bilirubin
132 var16= alkphosphate
133 var17= sgot
134 var18= albumin
135 var19= protime
136 var20= histology;
137 run;
WARNING: The variable var1 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var2 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var3 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var4 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var5 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var6 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var7 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var8 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var9 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var10 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var11 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var12 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var13 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var14 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var15 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var16 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var17 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var18 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var19 in the DROP, KEEP, or RENAME list has never been referenced.
WARNING: The variable var20 in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 154 observations read from the data set HW1.HEPA1.
NOTE: The data set WORK.MODIFIED has 154 observations and 20 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 974.21k
OS Memory 24488.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 27 Switch Count 2
Page Faults 0
Page Reclaims 220
Page Swaps 0
Voluntary Context Switches 16
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 272
138
139 libname HW1 '/home/u59197232/dataset1';
NOTE: Libref HW1 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59197232/dataset1
140 proc import datafile='/home/u59197232/dataset1/bupa.sas7bdat'
141 dbms=xlsx
142 out=hw1.bupa;
143 getnames=yes;
144 run;
NOTE: Import cancelled. Output dataset HW1.BUPA already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 686.71k
OS Memory 24464.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 28 Switch Count 0
Page Faults 0
Page Reclaims 138
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
145 *The above is a read in for bupa;
146
147
148 libname HW1 '/home/u59197232/dataset1';
NOTE: Libref HW1 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59197232/dataset1
149 proc import datafile= '/home/u59197232/dataset1/glass.sas7bdat'
150 dbms=xlsx
151 out=hw1.glass;
152 getnames=yes;
153 run;
NOTE: Import cancelled. Output dataset HW1.GLASS already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 686.71k
OS Memory 24464.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 29 Switch Count 0
Page Faults 0
Page Reclaims 138
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
154 *The above is a read in for glass;
155
156 libname HW1 '/home/u59197232/dataset1';
NOTE: Libref HW1 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59197232/dataset1
157 proc import datafile= '/home/u59197232/dataset1/hepa1.sas7bdat'
158 dbms= dlm
159 out=hw1.hepa1;
160 getnames=no;
161 run;
NOTE: Import cancelled. Output dataset HW1.HEPA1 already exists. Specify REPLACE option to overwrite it.
NOTE: The SAS System stopped processing this step because of errors.
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 193.93k
OS Memory 23968.00k
Timestamp 09/02/2021 02:31:16 PM
Step Count 30 Switch Count 0
Page Faults 0
Page Reclaims 14
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 8
162
163 *The above is a read in for hepa;
164
165 proc print data= '/home/u59197232/dataset1/glass.sas7bdat' ;
166 run;
NOTE: There were 213 observations read from the data set /home/u59197232/dataset1/glass.sas7bdat.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.37 seconds
user cpu time 0.37 seconds
system cpu time 0.00 seconds
memory 1282.59k
OS Memory 24996.00k
Timestamp 09/02/2021 02:31:17 PM
Step Count 31 Switch Count 1
Page Faults 0
Page Reclaims 471
Page Swaps 0
Voluntary Context Switches 11
Involuntary Context Switches 2
Block Input Operations 288
Block Output Operations 152
167 *The above shows the proc print step for the glass file;
168
169 proc print data= '/home/u59197232/dataset1/bupa.sas7bdat';
170 run;
NOTE: There were 344 observations read from the data set /home/u59197232/dataset1/bupa.sas7bdat.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.40 seconds
user cpu time 0.40 seconds
system cpu time 0.00 seconds
memory 723.12k
OS Memory 24996.00k
Timestamp 09/02/2021 02:31:17 PM
Step Count 32 Switch Count 1
Page Faults 0
Page Reclaims 82
Page Swaps 0
Voluntary Context Switches 12
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 176
171
172 *The above shows the proc print step for the bupa file;
173
174 proc print data= '/home/u59197232/dataset1/hepa1.sas7bdat';
175 run;
NOTE: There were 154 observations read from the data set /home/u59197232/dataset1/hepa1.sas7bdat.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.46 seconds
user cpu time 0.47 seconds
system cpu time 0.00 seconds
memory 753.00k
OS Memory 24996.00k
Timestamp 09/02/2021 02:31:17 PM
Step Count 33 Switch Count 1
Page Faults 0
Page Reclaims 76
Page Swaps 0
Voluntary Context Switches 6
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 160
176
177
178
179
180
181 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
191
... View more