Hi there,
I am working on a project for school, and I am by no means an expert. For every assignment, but this one, we have been given a dataset. So, this is the first time choosing my own.
As, I run Summary Statistics and try to add Analysis Variables it states "no columns are available." It does the same when I try to add a dependent variable for linear regression.
Here is the code for my data set??
/* Generated Code (IMPORT) */
/* Source File: IRP Data.xlsx */
/* Source Path: /home/u57962939/IS3310 */
/* Code generated on: 9/26/21, 9:08 AM */
%web_drop_table(IS3310.IRP);
FILENAME REFFILE '/home/u57962939/IS3310/IRP Data.xlsx';
PROC IMPORT DATAFILE=REFFILE
DBMS=XLSX
OUT=IS3310.IRP;
GETNAMES=YES;
RUN;
PROC CONTENTS DATA=IS3310.IRP; RUN;
%web_open_table(IS3310.IRP);
Here is the log:
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
70
71 /* Generated Code (IMPORT) */
72 /* Source File: IRP Data.xlsx */
73 /* Source Path: /home/u57962939/IS3310 */
74 /* Code generated on: 9/26/21, 9:08 AM */
75
76 %web_drop_table(IS3310.IRP);
77
78
79 FILENAME REFFILE '/home/u57962939/IS3310/IRP Data.xlsx';
80
81 PROC IMPORT DATAFILE=REFFILE
82 DBMS=XLSX
83 OUT=IS3310.IRP;
84 GETNAMES=YES;
85 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 975 observations and 27 variables.
NOTE: IS3310.IRP data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.24 seconds
user cpu time 0.24 seconds
system cpu time 0.00 seconds
memory 2976.03k
OS Memory 28580.00k
Timestamp 09/26/2021 02:08:43 PM
Step Count 38 Switch Count 2
Page Faults 0
Page Reclaims 697
Page Swaps 0
Voluntary Context Switches 30
Involuntary Context Switches 0
Block Input Operations 208
Block Output Operations 520
86
87 PROC CONTENTS DATA=IS3310.IRP; RUN;
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.08 seconds
user cpu time 0.09 seconds
system cpu time 0.00 seconds
memory 2586.87k
OS Memory 28584.00k
Timestamp 09/26/2021 02:08:43 PM
Step Count 39 Switch Count 0
Page Faults 0
Page Reclaims 722
Page Swaps 0
Voluntary Context Switches 10
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 32
88
89
90 %web_open_table(IS3310.IRP);
91
92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
103
User: u57962939
Messages: 9
US Region
I would really appreciate any help!
