Hi   So i converted numeric variables into categorical variable. By far when i check my temporary data called 'forreg' i can see 'Male' equals 1 for Gender.   But When i tried to plot PROC REG it still doesn't allow me to plot and gives me error, saying:   150 data forreg; 151 set new; 152 KEEP Exam Assign Gender; 153 IF Gender='Male' then Gender=1; Else Gender=0; 154 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 153:30 153:45 NOTE: There were 146 observations read from the data set WORK.NEW. NOTE: The data set WORK.FORREG has 146 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 155 156 TITLE1 'Scatter'; 157 PROC REG data=forreg; 158 MODEL Exam = Assign Gender /VIF; ERROR: Variable GENDER in list does not match type prescribed for this list. NOTE: The previous statement has been deleted. 159 RUN; WARNING: No variables specified for an SSCP matrix. Execution terminating. NOTE: PROCEDURE REG used (Total process time): real time 0.08 seconds cpu time 0.03 seconds   How can i plot PROC REG, using my converted dummy variables?   And here is my code data forreg; set new; KEEP Exam Assign Gender; IF Gender='Male' then Gender=1; Else Gender=0; run; TITLE1 'Scatter'; PROC REG data=forreg; MODEL Exam = Assign Gender /VIF; RUN; ... View more

I'd like to test hypothesis, where the difference between genders regards to writing ability. My hypothesis is that females would have higher score than males.   And i was going to use 'proc glm' or 'proc reg' to test about it but the error says: ERROR: Variable gender in list does not match type prescribed for this list.   So is it meaning that i can't use categorical variables to test hypothesis?   Here is my code: proc reg data=temp; model write = gender; run;   ... View more

hi    i'd like to create tabulate table to compare the difference between the median of total 'CURRENT_BALANCE' and median of total 'weekint' for genders   And i tried to create table using this code but don't know how to fix this code.         HERE is my code proc tabulate data = mergediff; class gender; var CURRENT_BALANCE weekint; table gender ALL, median*(CURRENT_BALANCE ALL); run; HERE is my error:   318 proc tabulate data = mergediff; 319 class gender; 320 var CURRENT_BALANCE weekint; 321 table gender ALL, median*(CURRENT_BALANCE ALL); 322 run; ERROR: Statistic other than N was requested without analysis variable in the following nesting : gender * Median * All. ERROR: Statistic other than N was requested without analysis variable in the following nesting : All * Median * All. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE TABULATE used (Total process time): real time 0.01 seconds cpu time 0.00 seconds    I attached the result of data 'mergediff' by proc print for reference   ... View more

Hi   I want to import my .sas7bdat file and make some temporary data with only where it is CURRENT_BALANCE < 0    i attached the result of picture about proc print as well.     Here's code:   /* This is the STATS301 start up file */ *Set up title on line 1; TITLE1 "STATS 301 / 749750841 / glee217 : &sysuserid"; *Specify SAS library for storing permanent SAS datasets; LIBNAME stats301 "C:\Users\olivi\Desktop\301assn3"; **import .sas7bdat; proc print data="C:\Users\olivi\Desktop\301assn3\account_level_ds.sas7bdat"; run; data nonnegative; set temp(where=current_balance>0); run; And here's error.   82 /* This is the STATS301 start up file */ 83 *Set up title on line 1; 84 TITLE1 "STATS 301 / 749750841 / glee217 : &sysuserid"; 85 *Specify SAS library for storing permanent SAS datasets; 86 LIBNAME stats301 "C:\Users\olivi\Desktop\301assn3"; NOTE: Libref STATS301 was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\olivi\Desktop\301assn3 87 88 **import .sas7bdat; 89 proc print data="C:\Users\olivi\Desktop\301assn3\account_level_ds.sas7bdat"; 90 run; NOTE: No observations in data set C:\Users\olivi\Desktop\301assn3\account_level_ds.sas7bdat. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 91 92 93 data nonnegative; 94 set temp(where=current_balance>0); ... View more

data ResidentialSalesAuckland; infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; input Roadname $27. Suburb $28-55 Townorcity $56-65 TLA $66-80 District $81-90 ListPrice 91-99 SalePrice 100-107 @108 ListDate ArrementDate UnconditionalDate @139 DaysOnMarket 7. Bedrooms 147 LandArea 6. New $2. Valuation 157-165 ValuationYear 4.; Informat Listdate mmddyy10. ArrementDate mmddyy10. UnconditionalDate mmddyy10.; run; proc print data=ResidentialSalesAuckland (obs=20); title 'residential'; format ListDate date9. ArrementDate date9. UnconditionalDate date9.; run; Hi, I'm trying to delete the row with missing observation but i don't know why it's not working.   I have two questions to ask...     1. The first code before i put function 'if ListPrice =. then delete;'  was looking like above.  There are some errors showed up too like this but what's the problem with 'UnconditionalDate'??   this is the error from the first code:   0 data ResidentialSalesAuckland; 451 infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; 452 453 input Roadname $27. Suburb $28-55 Townorcity $56-65 TLA $66-80 District $81-90 454 ListPrice 91-99 SalePrice 100-107 @108 ListDate ArrementDate UnconditionalDate @139 454! DaysOnMarket 7. 455 Bedrooms 147 LandArea 6. New $2. Valuation 157-165 ValuationYear 4.; 456 457 Informat Listdate mmddyy10. ArrementDate mmddyy10. UnconditionalDate mmddyy10.; 458 run; NOTE: The infile 'H:\stats301\A2\ResidentialSalesAuckland.dat' is: Filename=H:\stats301\A2\ResidentialSalesAuckland.dat, RECFM=V,LRECL=32767,File Size (bytes)=120390, Last Modified=17 August 2017 10:29:46, Create Time=17 August 2017 10:29:45 NOTE: Invalid data for UnconditionalDate in line 13 147-147. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 13 Newell St Point Chevalier Auckland City Auckland 89 624000 4/29/2005 5/16/2005 3 N 169 Roadname=Newell St Suburb=Point Chevalier Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=624000 ListDate=16555 ArrementDate=16572 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=13 NOTE: Invalid data for UnconditionalDate in line 22 147-147. 22 Proteus Pl Greenlane Auckland City Auckland 89 630000 4/5/2005 4/30/2005 3 N 169 Roadname=Proteus Pl Suburb=Greenlane Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=630000 ListDate=16531 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=22 NOTE: Invalid data for UnconditionalDate in line 37 155-155. 37 Grangewood Cl Mangere Manukau City Auckland 89 272000 272000 4/7/2005 4/30/2005 N 169 Roadname=Grangewood Cl Suburb=Mangere Townorcity= TLA=Manukau City District=Auckland ListPrice=272000 SalePrice=272000 ListDate=16533 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=37 NOTE: Invalid data for UnconditionalDate in line 69 152-152. 69 Edwards Rd Grey Lynn Auckland Auckland City Auckland 89 580000 580000 4/5/2005 5/31/2005 0 N 169 Roadname=Edwards Rd Suburb=Grey Lynn Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=580000 SalePrice=580000 ListDate=16531 ArrementDate=16587 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=0 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=69 NOTE: Invalid data for UnconditionalDate in line 70 147-147. 70 Seascape Rd Remuera Auckland City Auckland 89 866000 4/13/2005 4/30/2005 3 839 N 169 Roadname=Seascape Rd Suburb=Remuera Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=866000 ListDate=16539 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=839 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=70 NOTE: Invalid data for UnconditionalDate in line 106 155-155. 106 Skinner Rd Mt Wellington Auckland City Auckland 89 282500 282500 4/19/2005 4/30/2005 N 169 Roadname=Skinner Rd Suburb=Mt Wellington Townorcity= TLA=Auckland City District=Auckland ListPrice=282500 SalePrice=282500 ListDate=16545 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=106 NOTE: Invalid data for UnconditionalDate in line 107 155-155. 107 Carter Pl Manurewa Manukau City Auckland 89 210000 210000 4/1/2005 4/30/2005 N 169 Roadname=Carter Pl Suburb=Manurewa Townorcity= TLA=Manukau City District=Auckland ListPrice=210000 SalePrice=210000 ListDate=16527 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=107 NOTE: Invalid data for UnconditionalDate in line 115 147-147. 115 Richbourne St Kingsland Auckland City Auckland 89 510000 4/20/2005 4/30/2005 3 169 Roadname=Richbourne St Suburb=Kingsland Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=510000 ListDate=16546 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=. New= Valuation=. ValuationYear=. _ERROR_=1 _N_=115 NOTE: Invalid data for UnconditionalDate in line 116 150-152. 116 Giani Court Manurewa Manukau City Auckland 89 349000 4/20/2005 4/29/2005 400 Y 169 Roadname=Giani Court Suburb=Manurewa Townorcity= TLA=Manukau City District=Auckland ListPrice=. SalePrice=349000 ListDate=16546 ArrementDate=16555 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=400 New=Y Valuation=. ValuationYear=. _ERROR_=1 _N_=116 NOTE: Invalid data for UnconditionalDate in line 117 150-152. 117 Giani Court Manurewa Manukau City Auckland 89 349000 4/20/2005 4/29/2005 400 N 169 Roadname=Giani Court Suburb=Manurewa Townorcity= TLA=Manukau City District=Auckland ListPrice=. SalePrice=349000 ListDate=16546 ArrementDate=16555 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=400 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=117 NOTE: Invalid data for UnconditionalDate in line 142 147-147. 142 Dalry Pl Mangere Bridge Manukau City Auckland 89 390000 4/8/2005 4/30/2005 3 663 N 169 Roadname=Dalry Pl Suburb=Mangere Bridge Townorcity= TLA=Manukau City District=Auckland ListPrice=. SalePrice=390000 ListDate=16534 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=663 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=142 NOTE: Invalid data for UnconditionalDate in line 162 147-147. 162 Mt Pleasant Rd Mt Eden Auckland Auckland City Auckland 89 760000 4/8/2005 4/30/2005 3 506 N 655000 2002 169 Roadname=Mt Pleasant Rd Suburb=Mt Eden Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=760000 ListDate=16534 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=3 LandArea=506 New=N Valuation=655000 ValuationYear=2002 _ERROR_=1 _N_=162 NOTE: Invalid data for UnconditionalDate in line 163 155-155. 163 Walters Rd Mt Wellington Auckland City Auckland 89 295000 295000 4/23/2005 4/30/2005 N 169 Roadname=Walters Rd Suburb=Mt Wellington Townorcity= TLA=Auckland City District=Auckland ListPrice=295000 SalePrice=295000 ListDate=16549 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=163 NOTE: Invalid data for UnconditionalDate in line 194 147-147. 194 Taupata St Mt Eden Auckland Auckland City Auckland 89 540500 4/11/2005 4/30/2005 4 599 N 169 Roadname=Taupata St Suburb=Mt Eden Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=540500 ListDate=16537 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=4 LandArea=599 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=194 NOTE: Invalid data for UnconditionalDate in line 222 155-155. 222 Putini Rd Mangere Bridge Manukau City Auckland 89 330000 330000 4/30/2005 5/31/2005 N 169 Roadname=Putini Rd Suburb=Mangere Bridge Townorcity= TLA=Manukau City District=Auckland ListPrice=330000 SalePrice=330000 ListDate=16556 ArrementDate=16587 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=222 NOTE: Invalid data for UnconditionalDate in line 241 152-152. 241 Dempsey St Remuera Auckland Auckland City Auckland 89 422500 4/12/2005 4/30/2005 0 N 169 Roadname=Dempsey St Suburb=Remuera Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=422500 ListDate=16538 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=0 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=241 NOTE: Invalid data for UnconditionalDate in line 247 147-147. 247 Whitford Rd Botany Downs Manukau City Auckland 89 465000 452500 4/30/2005 5/9/2005 5 911 N 260000 169 Roadname=Whitford Rd Suburb=Botany Downs Townorcity= TLA=Manukau City District=Auckland ListPrice=465000 SalePrice=452500 ListDate=16556 ArrementDate=16565 UnconditionalDate=. DaysOnMarket=. Bedrooms=5 LandArea=911 New=N Valuation=260000 ValuationYear=. _ERROR_=1 _N_=247 NOTE: Invalid data for UnconditionalDate in line 257 147-147. 257 Epsom Ave Epsom Auckland Auckland City Auckland 89 1277000 4/1/2005 4/30/2005 4 1025 N 169 Roadname=Epsom Ave Suburb=Epsom Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=1277000 ListDate=16527 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=4 LandArea=1025 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=257 NOTE: Invalid data for UnconditionalDate in line 280 152-152. 280 Arney Cres Remuera Auckland Auckland City Auckland 89 2300000 4/30/2005 4/30/2005 0 N 169 Roadname=Arney Cres Suburb=Remuera Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=2300000 ListDate=16556 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=0 New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=280 NOTE: Invalid data for UnconditionalDate in line 281 155-155. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 281 Merwan St Mangere Manukau City Auckland 89 270000 270000 4/22/2005 4/30/2005 N 169 Roadname=Merwan St Suburb=Mangere Townorcity= TLA=Manukau City District=Auckland ListPrice=270000 SalePrice=270000 ListDate=16548 ArrementDate=16556 UnconditionalDate=. DaysOnMarket=. Bedrooms=. LandArea=. New=N Valuation=. ValuationYear=. _ERROR_=1 _N_=281 NOTE: 704 records were read from the infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'. The minimum record length was 169. The maximum record length was 175. NOTE: The data set WORK.RESIDENTIALSALESAUCKLAND has 704 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 459 460 proc print data=ResidentialSalesAuckland (obs=20); 461 462 title 'residential'; 463 format ListDate date9. ArrementDate date9. UnconditionalDate date9.; 464 run; NOTE: There were 20 observations read from the data set WORK.RESIDENTIALSALESAUCKLAND. NOTE: PROCEDURE PRINT used (Total process time): real time 0.17 seconds cpu time 0.01 seconds     2. And then when i put  'if ListPrice =. then delete;' function to get rid of rows with missing value. And now it gave me 0 observartion 😕   Here is code: data ResidentialSalesAuckland; infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; if ListPrice =. then delete; input Roadname $27. Suburb $28-55 Townorcity $56-65 TLA $66-80 District $81-90 ListPrice 91-99 SalePrice 100-107 @108 ListDate ArrementDate UnconditionalDate @139 DaysOnMarket 7. Bedrooms 147 LandArea 6. New $2. Valuation 157-165 ValuationYear 4.; Informat Listdate mmddyy10. ArrementDate mmddyy10. UnconditionalDate mmddyy10.; run; proc print data=ResidentialSalesAuckland (obs=20); title 'residential'; format ListDate date9. ArrementDate date9. UnconditionalDate date9.; run; And the error:   *Question4; 467 options yearcutoff=1900 nodate; 468 469 data ResidentialSalesAuckland; 470 infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; 471 472 if ListPrice =. then delete; 473 474 input Roadname $27. Suburb $28-55 Townorcity $56-65 TLA $66-80 District $81-90 475 ListPrice 91-99 SalePrice 100-107 @108 ListDate ArrementDate UnconditionalDate @139 475! DaysOnMarket 7. 476 Bedrooms 147 LandArea 6. New $2. Valuation 157-165 ValuationYear 4.; 477 478 Informat Listdate mmddyy10. ArrementDate mmddyy10. UnconditionalDate mmddyy10.; 479 run; NOTE: The infile 'H:\stats301\A2\ResidentialSalesAuckland.dat' is: Filename=H:\stats301\A2\ResidentialSalesAuckland.dat, RECFM=V,LRECL=32767,File Size (bytes)=120390, Last Modified=17 August 2017 10:29:46, Create Time=17 August 2017 10:29:45 NOTE: DATA STEP stopped due to looping. NOTE: 0 records were read from the infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'. NOTE: The data set WORK.RESIDENTIALSALESAUCKLAND has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 480 481 proc print data=ResidentialSalesAuckland (obs=20); 482 483 title 'residential'; 484 format ListDate date9. ArrementDate date9. UnconditionalDate date9.; 485 run; NOTE: No observations in data set WORK.RESIDENTIALSALESAUCKLAND. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds       What's the problem from the original code and What do i have to do if i want to get rid of rows with missing values??   I will attach file how the first output looked like (just to make it sure, the data is not 'txt.'file!! it's dat. file but since i couldn't upload this file directly on this post, so  i changed it into txt. )       ... View more

*Question4; data ResidentialSalesAuckland; infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; input Roadname $27. Suburb $ 28-55 Townorcity $56-65 TLA $66-80 District $81-90 ListPrice 91-99 SalePrice 100-107 @108 ListDate MMDDYY9.; run; proc print; title 'residential'; format ListDate date9.; run;   This is my code. and everything before i create "ListDate" variable was fine.   But when i put this variable it gives me dot as missing value and i don't know what's the problem. As i counted the very first example from the error, for example, 4/11/2005 is counted as 9 spaces. This is why i put MMDDYY9. I tried to put DATE9. but it doesn't work neither.       here is the detail of error is saying:     102 *Question4; 103 data ResidentialSalesAuckland; 104 infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'; 105 input Roadname $27. Suburb $ 28-55 Townorcity $56-65 TLA $66-80 District $81-90 106 ListPrice 91-99 SalePrice 100-107 @108 ListDate MMDDYY9.; 107 run; NOTE: The infile 'H:\stats301\A2\ResidentialSalesAuckland.dat' is: Filename=H:\stats301\A2\ResidentialSalesAuckland.dat, RECFM=V,LRECL=32767,File Size (bytes)=120390, Last Modified=17 August 2017 10:29:46, Create Time=17 August 2017 10:29:45 NOTE: Invalid data for ListDate in line 1 108-116. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 1 Kealy Rd Mt Wellington Auckland City Auckland 89 355000 355000 4/11/2005 4/12/2005 4/30/2005 1 4 560 N 169 Roadname=Kealy Rd Suburb=Mt Wellington Townorcity= TLA=Auckland City District=Auckland ListPrice=355000 SalePrice=355000 ListDate=. _ERROR_=1 _N_=1 NOTE: Invalid data for ListDate in line 2 108-116. 2 Edzell Cl Dannemora Manukau Manukau City Auckland 89 586000 2/2/2005 4/17/2005 4/30/2005 74 5 491 N 169 Roadname=Edzell Cl Suburb=Dannemora Townorcity=Manukau TLA=Manukau City District=Auckland ListPrice=. SalePrice=586000 ListDate=. _ERROR_=1 _N_=2 NOTE: Invalid data for ListDate in line 3 108-116. 3 Te Wiata Pl Avondale - Auckland Auckland Auckland City Auckland 89 320250 2/24/2005 4/14/2005 4/30/2005 49 3 622 N 242000 2002 169 Roadname=Te Wiata Pl Suburb=Avondale - Auckland Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=320250 ListDate=. _ERROR_=1 _N_=3 NOTE: Invalid data for ListDate in line 4 108-116. 4 Delray Pl Howick Manukau City Auckland 89 645000 595000 3/8/2005 4/20/2005 5/3/2005 43 4 755 N 169 Roadname=Delray Pl Suburb=Howick Townorcity= TLA=Manukau City District=Auckland ListPrice=645000 SalePrice=595000 ListDate=. _ERROR_=1 _N_=4 NOTE: Invalid data for ListDate in line 5 108-116. 5 Carrie St Sandringham Auckland City Auckland 89 485000 3/14/2005 4/11/2005 4/30/2005 28 3 506 N 325000 2002 169 Roadname=Carrie St Suburb=Sandringham Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=485000 ListDate=. _ERROR_=1 _N_=5 NOTE: Invalid data for ListDate in line 6 108-116. 6 Christmas Rd Manurewa Manukau City Auckland 89 255000 3/15/2005 4/7/2005 5/31/2005 23 3 976 N 169 Roadname=Christmas Rd Suburb=Manurewa Townorcity= TLA=Manukau City District=Auckland ListPrice=. SalePrice=255000 ListDate=. _ERROR_=1 _N_=6 NOTE: Invalid data for ListDate in line 7 108-116. 7 Ware Pl Pakuranga Manukau Manukau City Auckland 89 379000 342500 3/17/2005 4/16/2005 5/31/2005 30 3 683 N 230000 2002 169 Roadname=Ware Pl Suburb=Pakuranga Townorcity=Manukau TLA=Manukau City District=Auckland ListPrice=379000 SalePrice=342500 ListDate=. _ERROR_=1 _N_=7 NOTE: Invalid data for ListDate in line 8 108-116. 8 Paunui St St Heliers Auckland City Auckland 89 1050000 1050000 3/18/2005 4/27/2005 4/30/2005 40 3 661 N 705000 169 Roadname=Paunui St Suburb=St Heliers Townorcity= TLA=Auckland City District=Auckland ListPrice=1050000 SalePrice=1050000 ListDate=. _ERROR_=1 _N_=8 NOTE: Invalid data for ListDate in line 9 108-116. 9 Faldo Dr Howick Manukau Manukau City Auckland 89 520000 474000 3/18/2005 4/17/2005 5/31/2005 30 4 725 N 169 Roadname=Faldo Dr Suburb=Howick Townorcity=Manukau TLA=Manukau City District=Auckland ListPrice=520000 SalePrice=474000 ListDate=. _ERROR_=1 _N_=9 NOTE: Invalid data for ListDate in line 10 108-116. 10 Maroa Rd One Tree Hill Auckland City Auckland 89 349000 3/30/2005 4/16/2005 4/30/2005 17 2 N 173000 169 Roadname=Maroa Rd Suburb=One Tree Hill Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=349000 ListDate=. _ERROR_=1 _N_=10 NOTE: Invalid data for ListDate in line 11 108-116. 11 Bannemman Rd Morningside - Auckland City Auckland City Auckland 89 400000 400000 4/2/2005 4/6/2005 4/30/2005 4 4 N 169 Roadname=Bannemman Rd Suburb=Morningside - Auckland City Townorcity= TLA=Auckland City District=Auckland ListPrice=400000 SalePrice=400000 ListDate=. _ERROR_=1 _N_=11 NOTE: Invalid data for ListDate in line 12 108-116. 12 Baldwin Ave Mt Albert Auckland City Auckland 89 767500 767500 4/6/2005 4/7/2005 4/30/2005 1 4 696 N 169 Roadname=Baldwin Ave Suburb=Mt Albert Townorcity= TLA=Auckland City District=Auckland ListPrice=767500 SalePrice=767500 ListDate=. _ERROR_=1 _N_=12 NOTE: Invalid data for ListDate in line 14 108-116. 14 Pukeora Ave Remuera Auckland City Auckland 89 540000 3/1/2005 4/21/2005 4/30/2005 51 2 N 169 Roadname=Pukeora Ave Suburb=Remuera Townorcity= TLA=Auckland City District=Auckland ListPrice=. SalePrice=540000 ListDate=. _ERROR_=1 _N_=14 NOTE: Invalid data for ListDate in line 15 108-116. 15 Cardwell St Onehunga Auckland Auckland City Auckland 89 483000 3/3/2005 4/2/2005 4/30/2005 30 3 440 N 250000 2002 169 Roadname=Cardwell St Suburb=Onehunga Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=483000 ListDate=. _ERROR_=1 _N_=15 NOTE: Invalid data for ListDate in line 16 108-116. 16 Tannock Pl Mangere Manukau City Auckland 89 182000 3/23/2005 4/13/2005 4/30/2005 21 3 675 N 169 Roadname=Tannock Pl Suburb=Mangere Townorcity= TLA=Manukau City District=Auckland ListPrice=. SalePrice=182000 ListDate=. _ERROR_=1 _N_=16 NOTE: Invalid data for ListDate in line 17 108-116. 17 Coleraine Pl Dannemora Manukau City Auckland 89 408000 408000 4/4/2005 4/4/2005 4/30/2005 0 N 169 Roadname=Coleraine Pl Suburb=Dannemora Townorcity= TLA=Manukau City District=Auckland ListPrice=408000 SalePrice=408000 ListDate=. _ERROR_=1 _N_=17 NOTE: Invalid data for ListDate in line 18 108-116. 18 Churchill Ave Manurewa Manukau City Auckland 89 300000 305500 4/15/2005 4/22/2005 5/31/2005 7 3 971 N 270000 169 Roadname=Churchill Ave Suburb=Manurewa Townorcity= TLA=Manukau City District=Auckland ListPrice=300000 SalePrice=305500 ListDate=. _ERROR_=1 _N_=18 NOTE: Invalid data for ListDate in line 19 108-116. 19 Walker Rd Point Chevalier Auckland Auckland City Auckland 89 470000 4/18/2005 4/26/2005 5/31/2005 8 3 0 N 320000 2002 169 Roadname=Walker Rd Suburb=Point Chevalier Townorcity=Auckland TLA=Auckland City District=Auckland ListPrice=. SalePrice=470000 ListDate=. _ERROR_=1 _N_=19 NOTE: Invalid data for ListDate in line 20 108-116. 20 Blowers Pl Chapel Park Dannemora Manukau City Auckland 89 349000 335000 4/19/2005 4/23/2005 5/31/2005 4 3 507 N 169 Roadname=Blowers Pl Chapel Park Suburb=Dannemora Townorcity= TLA=Manukau City District=Auckland ListPrice=349000 SalePrice=335000 ListDate=. _ERROR_=1 _N_=20 NOTE: Invalid data for ListDate in line 21 108-116. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. 21 Hillcrest Gr Hillpark Manukau City Auckland 89 379000 370000 4/19/2005 4/19/2005 5/13/2005 0 3 974 N 211000 2005 169 Roadname=Hillcrest Gr Suburb=Hillpark Townorcity= TLA=Manukau City District=Auckland ListPrice=379000 SalePrice=370000 ListDate=. _ERROR_=1 _N_=21 NOTE: 704 records were read from the infile 'H:\stats301\A2\ResidentialSalesAuckland.dat'. The minimum record length was 169. The maximum record length was 175. NOTE: The data set WORK.RESIDENTIALSALESAUCKLAND has 704 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.04 seconds   ... View more