Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About Jweinstein2001
12-06-2022
Jweinstein2001
Calcite | Level 5
Member since
09-27-2021
- 29 Posts
- 1 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Jweinstein2001
Subject Views Posted 319 12-06-2022 09:19 AM 323 12-06-2022 09:19 AM 675 12-05-2022 05:02 PM 697 12-05-2022 04:57 PM 761 12-05-2022 04:37 PM 778 12-05-2022 04:24 PM 374 12-05-2022 04:09 PM 737 12-05-2022 04:01 PM 898 12-05-2022 03:46 PM 970 12-05-2022 03:30 PM -
Activity Feed for Jweinstein2001
- Posted Re: Trying to create two numeric variables but neither are appearing properly. on SAS Programming. 12-06-2022 09:19 AM
- Posted Re: Trying to create two numeric variables but neither are appearing properly. on SAS Programming. 12-06-2022 09:19 AM
- Posted Re: Need help creating a variable from imported dataset on SAS Programming. 12-05-2022 05:02 PM
- Liked Re: Need help creating a variable from imported dataset for ballardw. 12-05-2022 05:02 PM
- Posted Re: Creating new Numerical Variables on SAS Programming. 12-05-2022 04:57 PM
- Posted Re: Creating new Numerical Variables on SAS Programming. 12-05-2022 04:37 PM
- Posted Creating new Numerical Variables on SAS Programming. 12-05-2022 04:24 PM
- Posted Trying to create two numeric variables but neither are appearing properly. on SAS Programming. 12-05-2022 04:09 PM
- Posted Need help creating a variable from imported dataset on SAS Programming. 12-05-2022 04:01 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:46 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:30 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:26 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:25 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:22 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:20 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:16 PM
- Posted Re: Need help addressing the variables within my code on SAS Programming. 12-05-2022 03:12 PM
- Posted Need help addressing the variables within my code on SAS Programming. 12-05-2022 02:56 PM
- Posted Re: Need help with making code work for xchart on SAS Programming. 03-22-2022 04:10 PM
- Posted Re: Need help with making code work for xchart on SAS Programming. 03-22-2022 03:08 PM
-
Posts I Liked
Subject Likes Author Latest Post 1
12-06-2022
09:19 AM
Or it actually got double posted, which I don't understand.
... View more
12-06-2022
09:19 AM
If you check the question it was regarding something else along with this question in which was never answered and was only answered within this thread, thank you.
... View more
12-05-2022
05:02 PM
Thank you very very much
... View more
12-05-2022
04:57 PM
Now it is saying the variables are uninitialized.
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.
38:1 RC
68
69 options MSGLEVEL=I;
70 libname Ec351 "/home/u59307513/Ec351";
NOTE: Libref EC351 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59307513/Ec351
71 proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
72 getnames=yes;
73 run;
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type.
NOTE: The import data set has 11914 observations and 7 variables.
NOTE: EC351.PROJECT1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.04 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 3242.71k
OS Memory 37092.00k
Timestamp 12/05/2022 09:56:14 PM
Step Count 730 Switch Count 2
Page Faults 0
Page Reclaims 669
Page Swaps 0
Voluntary Context Switches 51
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1544
74
75
76 data ec351.projectsorted;
77 set ec351.project1;
78 options validvarname=any;
79 if year < 2017 then delete;
80 run;
NOTE: There were 11914 observations read from the data set EC351.PROJECT1.
NOTE: The data set EC351.PROJECTSORTED has 1668 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1604.59k
OS Memory 35508.00k
Timestamp 12/05/2022 09:56:14 PM
Step Count 731 Switch Count 2
Page Faults 0
Page Reclaims 263
Page Swaps 0
Voluntary Context Switches 64
Involuntary Context Switches 0
Block Input Operations 1568
Block Output Operations 264
81
82 data ec351.projectuseabledata ;
83 set ec351.projectsorted;
84 if "Transmission Type"n = 'MANUAL' then Trans = 0;
85 else Trans = 1 ;
86 if Number_of_doors = 2 then doors = 0;
87 else doors = 1;
88 drop year;
89 AvgMPG = (City_MPG+Highway_MPG)/2;
90 run;
NOTE: Variable Number_of_doors is uninitialized.
NOTE: Variable Highway_MPG is uninitialized.
NOTE: Variable City_MPG is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1668 at 89:19
NOTE: There were 1668 observations read from the data set EC351.PROJECTSORTED.
NOTE: The data set EC351.PROJECTUSEABLEDATA has 1668 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 1172.15k
OS Memory 34996.00k
Timestamp 12/05/2022 09:56:14 PM
Step Count 732 Switch Count 1
Page Faults 0
Page Reclaims 94
Page Swaps 0
Voluntary Context Switches 48
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 520
91
92 proc print data= ec351.projectuseabledata;
93 run;
NOTE: There were 1668 observations read from the data set EC351.PROJECTUSEABLEDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 3.36 seconds
user cpu time 3.36 seconds
system cpu time 0.00 seconds
memory 1491.96k
OS Memory 34736.00k
Timestamp 12/05/2022 09:56:17 PM
Step Count 733 Switch Count 0
Page Faults 0
Page Reclaims 95
Page Swaps 0
Voluntary Context Switches 15
Involuntary Context Switches 3
Block Input Operations 544
Block Output Operations 1248
94
95
96
97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
107
... View more
12-05-2022
04:37 PM
I kept getting marked as spam when I did this,
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.
38:1 RC
68
69 options MSGLEVEL=I;
70 libname Ec351 "/home/u59307513/Ec351";
NOTE: Libref EC351 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59307513/Ec351
71 proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
72 getnames=yes;
73 run;
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type.
NOTE: The import data set has 11914 observations and 7 variables.
NOTE: EC351.PROJECT1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 3242.00k
OS Memory 36836.00k
Timestamp 12/05/2022 09:37:00 PM
Step Count 721 Switch Count 2
Page Faults 0
Page Reclaims 669
Page Swaps 0
Voluntary Context Switches 54
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1544
74
75
76 data ec351.projectsorted;
77 set ec351.project1;
78 options validvarname=any;
79 if year < 2017 then delete;
80 run;
NOTE: There were 11914 observations read from the data set EC351.PROJECT1.
NOTE: The data set EC351.PROJECTSORTED has 1668 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1605.68k
OS Memory 35252.00k
Timestamp 12/05/2022 09:37:00 PM
Step Count 722 Switch Count 2
Page Faults 0
Page Reclaims 254
Page Swaps 0
Voluntary Context Switches 63
Involuntary Context Switches 0
Block Input Operations 1568
Block Output Operations 264
81
82 data ec351.projectuseabledata ;
83 set ec351.projectsorted;
84 if "Transmission Type"n = 'MANUAL' then Trans = 0;
85 else Trans = 1 ;
86 if "Number_of_doors" = 2 then doors = 0;
87 else doors = 1;
88 drop year;
89 AvgMPG = ('City_MPG'+'Highway_MPG')/2;
90 run;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
86:4 89:11 89:22
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=27495 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=1
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=24995 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=2
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=28195 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=3
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=31 city mpg=21 MSRP=46450 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=4
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=49050 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=5
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=51050 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=6
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=44450 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=7
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=34 city mpg=23 MSRP=38950 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=8
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=35 city mpg=24 MSRP=33150 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=9
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=24 MSRP=35150 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=10
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=23 MSRP=40950 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=11
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=29905 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=12
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=31785 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=13
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=26685 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=14
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=22490 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=15
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=25690 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=16
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=30900 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=17
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=27795 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=18
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=21995 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=19
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 11.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 22.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=24490 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=20
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1668 at 89:21
NOTE: There were 1668 observations read from the data set EC351.PROJECTSORTED.
NOTE: The data set EC351.PROJECTUSEABLEDATA has 1668 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1173.59k
OS Memory 34740.00k
Timestamp 12/05/2022 09:37:00 PM
Step Count 723 Switch Count 1
Page Faults 0
Page Reclaims 99
Page Swaps 0
Voluntary Context Switches 50
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 536
91
92 proc print data= ec351.projectuseabledata;
93 run;
NOTE: There were 1668 observations read from the data set EC351.PROJECTUSEABLEDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.46 seconds
user cpu time 2.46 seconds
system cpu time 0.00 seconds
memory 1481.00k
OS Memory 34480.00k
Timestamp 12/05/2022 09:37:02 PM
Step Count 724 Switch Count 0
Page Faults 0
Page Reclaims 82
Page Swaps 0
Voluntary Context Switches 13
Involuntary Context Switches 9
Block Input Operations 544
Block Output Operations 1000
94
95
96
97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
107
... View more
12-05-2022
04:24 PM
Im trying to create two new numeric variables. My code is giving me the error saying the data is not able to be found within the lines, and for the other variable, nothing appears at all. I don't believe I'm doing anything wrong but obviously am.
... View more
12-05-2022
04:09 PM
The code below includes my code to program the new variables and the dataset along with the log that shows the errors of not being able to find the proper numeric variables. Doors only appear as a value of 1 when they should be taking on a value of 0 at times, and AVGMPG isn't appearing at all. options MSGLEVEL=I;
libname Ec351 "/home/u59307513/Ec351";
proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
getnames=yes;
run;
data ec351.projectsorted;
set ec351.project1;
options validvarname=any;
if year < 2017 then delete;
run;
data ec351.projectuseabledata ;
set ec351.projectsorted;
if "Transmission Type"n = 'MANUAL' then Trans = 0;
else Trans = 1 ;
if 'Number_of_doors' = 2 then doors = 0;
else doors = 1;
drop year;
AvgMPG = (('City_MPG'+'Highway_MPG')/2);
run;
proc print data= ec351.projectuseabledata;
run;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.
38:1 RC
68
69 options MSGLEVEL=I;
70 libname Ec351 "/home/u59307513/Ec351";
NOTE: Libref EC351 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59307513/Ec351
71 proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
72 getnames=yes;
73 run;
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type.
NOTE: The import data set has 11914 observations and 7 variables.
NOTE: EC351.PROJECT1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.04 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 3242.59k
OS Memory 36836.00k
Timestamp 12/05/2022 09:05:57 PM
Step Count 685 Switch Count 2
Page Faults 0
Page Reclaims 669
Page Swaps 0
Voluntary Context Switches 53
Involuntary Context Switches 1
Block Input Operations 0
Block Output Operations 1544
74
75
76 data ec351.projectsorted;
77 set ec351.project1;
78 options validvarname=any;
79 if year < 2017 then delete;
80 run;
NOTE: There were 11914 observations read from the data set EC351.PROJECT1.
NOTE: The data set EC351.PROJECTSORTED has 1668 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1604.28k
OS Memory 35252.00k
Timestamp 12/05/2022 09:05:57 PM
Step Count 686 Switch Count 2
Page Faults 0
Page Reclaims 257
Page Swaps 0
Voluntary Context Switches 64
Involuntary Context Switches 0
Block Input Operations 1568
Block Output Operations 264
81
82 data ec351.projectuseabledata ;
83 set ec351.projectsorted;
84 if "Transmission Type"n = 'MANUAL' then Trans = 0;
85 else Trans = 1 ;
86 if 'Number_of_doors' = 2 then doors = 0;
87 else doors = 1;
88 drop year;
89 AvgMPG = (('City_MPG'+'Highway_MPG')/2);
90 run;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
86:4 89:12 89:23
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=27495 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=1
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=24995 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=2
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=28195 Trans=0 doors=1 AvgMPG=.
_ERROR_=1 _N_=3
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=31 city mpg=21 MSRP=46450 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=4
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=49050 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=5
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=51050 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=6
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=44450 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=7
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=34 city mpg=23 MSRP=38950 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=8
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=35 city mpg=24 MSRP=33150 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=9
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=24 MSRP=35150 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=10
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=23 MSRP=40950 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=11
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=29905 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=12
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=31785 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=13
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=26685 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=14
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=22490 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=15
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=25690 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=16
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=30900 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=17
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=27795 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=18
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=21995 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=19
NOTE: Invalid numeric data, 'Number_of_doors' , at line 86 column 4.
NOTE: Invalid numeric data, 'City_MPG' , at line 89 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 89 column 23.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=24490 Trans=1 doors=1 AvgMPG=.
_ERROR_=1 _N_=20
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1668 at 89:22
NOTE: There were 1668 observations read from the data set EC351.PROJECTSORTED.
NOTE: The data set EC351.PROJECTUSEABLEDATA has 1668 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1285.50k
OS Memory 34740.00k
Timestamp 12/05/2022 09:05:57 PM
Step Count 687 Switch Count 1
Page Faults 0
Page Reclaims 98
Page Swaps 0
Voluntary Context Switches 51
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 536
91
92 proc print data= ec351.projectuseabledata;
93 run;
NOTE: There were 1668 observations read from the data set EC351.PROJECTUSEABLEDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.53 seconds
user cpu time 2.53 seconds
system cpu time 0.00 seconds
memory 1473.31k
OS Memory 34480.00k
Timestamp 12/05/2022 09:06:00 PM
Step Count 688 Switch Count 0
Page Faults 0
Page Reclaims 80
Page Swaps 0
Voluntary Context Switches 12
Involuntary Context Switches 3
Block Input Operations 544
Block Output Operations 1000
94
95
96
97 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
107
... View more
12-05-2022
04:01 PM
options MSGLEVEL=I;
libname Ec351 "/home/u59307513/Ec351";
proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
getnames=yes;
run;
data ec351.projectsorted;
set ec351.project1;
options validvarname=any;
if year < 2017 then delete;
run;
data ec351.projectuseabledata ;
set ec351.projectsorted;
if "Transmission Type"n = 'MANUAL' then Trans = 0;
else Trans = 1 ;
drop year;
AvgMPG = (("City_MPG"+"Highway_MPG")/2);
run;
proc print data= ec351.projectuseabledata;
run;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.
38:1 RC
68
69 options MSGLEVEL=I;
70 libname Ec351 "/home/u59307513/Ec351";
NOTE: Libref EC351 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59307513/Ec351
71 proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
72 getnames=yes;
73 run;
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type.
NOTE: The import data set has 11914 observations and 7 variables.
NOTE: EC351.PROJECT1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
user cpu time 0.02 seconds
system cpu time 0.00 seconds
memory 3242.43k
OS Memory 36580.00k
Timestamp 12/05/2022 08:57:59 PM
Step Count 640 Switch Count 2
Page Faults 0
Page Reclaims 670
Page Swaps 0
Voluntary Context Switches 50
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1544
74
75
76 data ec351.projectsorted;
77 set ec351.project1;
78 options validvarname=any;
79 if year < 2017 then delete;
80 run;
NOTE: There were 11914 observations read from the data set EC351.PROJECT1.
NOTE: The data set EC351.PROJECTSORTED has 1668 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1491.40k
OS Memory 34996.00k
Timestamp 12/05/2022 08:57:59 PM
Step Count 641 Switch Count 2
Page Faults 0
Page Reclaims 262
Page Swaps 0
Voluntary Context Switches 63
Involuntary Context Switches 0
Block Input Operations 1568
Block Output Operations 264
81
82 data ec351.projectuseabledata ;
83 set ec351.projectsorted;
84 if "Transmission Type"n = 'MANUAL' then Trans = 0;
85 else Trans = 1 ;
86 drop year;
87 AvgMPG = (("City_MPG"+"Highway_MPG")/2);
88 run;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
87:12 87:23
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=27495 Trans=0 AvgMPG=. _ERROR_=1
_N_=1
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=24995 Trans=0 AvgMPG=. _ERROR_=1
_N_=2
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=160 Transmission Type=MANUAL Number of Doors=2 highway MPG=35 city mpg=26 MSRP=28195 Trans=0 AvgMPG=. _ERROR_=1
_N_=3
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=31 city mpg=21 MSRP=46450 Trans=1 AvgMPG=.
_ERROR_=1 _N_=4
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=49050 Trans=1 AvgMPG=.
_ERROR_=1 _N_=5
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=51050 Trans=1 AvgMPG=.
_ERROR_=1 _N_=6
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=335 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=32 city mpg=21 MSRP=44450 Trans=1 AvgMPG=.
_ERROR_=1 _N_=7
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=34 city mpg=23 MSRP=38950 Trans=1 AvgMPG=.
_ERROR_=1 _N_=8
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=35 city mpg=24 MSRP=33150 Trans=1 AvgMPG=.
_ERROR_=1 _N_=9
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=24 MSRP=35150 Trans=1 AvgMPG=.
_ERROR_=1 _N_=10
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=248 Transmission Type=AUTOMATIC Number of Doors=2 highway MPG=33 city mpg=23 MSRP=40950 Trans=1 AvgMPG=.
_ERROR_=1 _N_=11
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=29905 Trans=1 AvgMPG=.
_ERROR_=1 _N_=12
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=31785 Trans=1 AvgMPG=.
_ERROR_=1 _N_=13
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=26685 Trans=1 AvgMPG=.
_ERROR_=1 _N_=14
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=22490 Trans=1 AvgMPG=.
_ERROR_=1 _N_=15
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=25690 Trans=1 AvgMPG=.
_ERROR_=1 _N_=16
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=295 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=28 city mpg=18 MSRP=30900 Trans=1 AvgMPG=.
_ERROR_=1 _N_=17
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=27795 Trans=1 AvgMPG=.
_ERROR_=1 _N_=18
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=21995 Trans=1 AvgMPG=.
_ERROR_=1 _N_=19
NOTE: Invalid numeric data, 'City_MPG' , at line 87 column 12.
NOTE: Invalid numeric data, 'Highway_MPG' , at line 87 column 23.
WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
Year=2017 Engine HP=184 Transmission Type=AUTOMATIC Number of Doors=4 highway MPG=36 city mpg=23 MSRP=24490 Trans=1 AvgMPG=.
_ERROR_=1 _N_=20
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1668 at 87:22
NOTE: There were 1668 observations read from the data set EC351.PROJECTSORTED.
NOTE: The data set EC351.PROJECTUSEABLEDATA has 1668 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 1174.59k
OS Memory 34484.00k
Timestamp 12/05/2022 08:57:59 PM
Step Count 642 Switch Count 1
Page Faults 0
Page Reclaims 99
Page Swaps 0
Voluntary Context Switches 51
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 280
89
90 proc print data= ec351.projectuseabledata;
91 run;
NOTE: There were 1668 observations read from the data set EC351.PROJECTUSEABLEDATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 2.30 seconds
user cpu time 2.29 seconds
system cpu time 0.00 seconds
memory 1327.03k
OS Memory 34480.00k
Timestamp 12/05/2022 08:58:01 PM
Step Count 643 Switch Count 0
Page Faults 0
Page Reclaims 147
Page Swaps 0
Voluntary Context Switches 20
Involuntary Context Switches 16
Block Input Operations 288
Block Output Operations 904
92
93
94
95 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
105 The variable AVGMPG comes up as a ".", and I was wondering why I'm getting an error when its trying to read the values of both MPG variables.
... View more
12-05-2022
03:46 PM
Even when I change the value to all caps, the same outcome occurs.
... View more
12-05-2022
03:26 PM
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result.
38:1 RC
68
69 options MSGLEVEL=I;
70 libname Ec351 "/home/u59307513/Ec351";
NOTE: Libref EC351 was successfully assigned as follows:
Engine: V9
Physical Name: /home/u59307513/Ec351
71 proc import datafile='/home/u59307513/Ec351/CarPrice Regression Dataset Ec351.xls' dbms=xls out=EC351.Project1 replace;
72 getnames=yes;
73 run;
NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type.
NOTE: The import data set has 11914 observations and 7 variables.
NOTE: EC351.PROJECT1 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
user cpu time 0.01 seconds
system cpu time 0.01 seconds
memory 3242.68k
OS Memory 36324.00k
Timestamp 12/05/2022 08:23:43 PM
Step Count 524 Switch Count 2
Page Faults 0
Page Reclaims 669
Page Swaps 0
Voluntary Context Switches 50
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 1544
74
75
76 data ec351.projectsorted;
77 set ec351.project1;
78 options validvarname=any;
79 if year < 2017 then delete;
80 run;
NOTE: There were 11914 observations read from the data set EC351.PROJECT1.
NOTE: The data set EC351.PROJECTSORTED has 1668 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.01 seconds
system cpu time 0.00 seconds
memory 1605.50k
OS Memory 34740.00k
Timestamp 12/05/2022 08:23:43 PM
Step Count 525 Switch Count 2
Page Faults 0
Page Reclaims 260
Page Swaps 0
Voluntary Context Switches 61
Involuntary Context Switches 0
Block Input Operations 1568
Block Output Operations 264
81
82 data ec351.projectuseabledata ;
83 set ec351.projectsorted;
84 if "Transmission Type"n = 'manual' then Newvar = 0;
85 else Newvar = 1 ;
86 drop year;
87 AvgMPG = ((City_MPG+Highway_MPG)/2);
88 run;
NOTE: Variable Highway_MPG is uninitialized.
NOTE: Variable City_MPG is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1668 at 87:20
NOTE: There were 1668 observations read from the data set EC351.PROJECTSORTED.
NOTE: The data set EC351.PROJECTUSEABLEDATA has 1668 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 1171.81k
OS Memory 34228.00k
Timestamp 12/05/2022 08:23:43 PM
Step Count 526 Switch Count 1
Page Faults 0
Page Reclaims 97
Page Swaps 0
Voluntary Context Switches 53
Involuntary Context Switches 0
Block Input Operations 288
Block Output Operations 520
89
90
91
92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
102 Thank you very much by the way.
... View more
12-05-2022
03:25 PM
Yes ive looked, I created the dataset and it has hundreds that are manual and hundreds that arent. With my code it should be changing these values to 0.
... View more
12-05-2022
03:22 PM
also if I dont use quotes it creates new variable for the highway and city, how do I avoid this while referencing them?
... View more
12-05-2022
03:20 PM
Sorry, I found the issue, it's saying NOTE: VARCHAR data type is not supported by the V9 engine. Variable Transmission Type has been converted to CHAR data type. After opening up my options it's tells me it's changing the data type, how would I now make this usable datatype?
... View more
12-05-2022
03:16 PM
I linked the dataset, the value is different and should be changing, I've ran into this problem before even though I feel as if I'm doing everything correctly.
... View more
