Sentry Page Protection

Please Wait...

Exercise (4-10)

Copy and run the REPAIR data set from the yellow box below.

Data Repair; Infile Datalines dsd; Input brand : $10. model : $20. Purdate : $30. Repdate : date9. Parts : $20. Cost; Format Repdate date9.; Datalines; Asus,Zenbook,24JUL2012,06APR2015,Motherboard,57 Asus,Chromebook,05MAR2013,11JUL2014,Processor,61 Lenovo,Thinkpad,23JAN2012,20MAR2015,Hard Drive,358 Toshiba,Kirabook,07MAR2012,19DEC2014,Keyboard,136 Toshiba,Satellite,11APR2012,19NOV2015,Software,347 HP,Pavilion,04SEP2012,01DEC2014,Hard Drive,144 Dell,Inspiron,02MAR2013,19JUL2014,Keyboard,396 Lenovo,Thinkpad,28JAN2014,29AUG2014,Processor,355 Lenovo,Thinkpad,23JUN2012,08JAN2015,Keyboard,183 Asus,Zenbook,09JUN2012,06SEP2014,Processor,371 Lenovo,Yoga,22JAN2014,18JUN2015,Processor,238 HP,Probook,17MAY2014,24OCT2015,Processor,236 Lenovo,Yoga,03MAY2014,26OCT2014,Motherboard,136 Lenovo,Yoga,25AUG2013,11JUN2015,Hard Drive,163 HP,Envy,10DEC2012,14SEP2015,Hard Drive,189 HP,Pavilion,16APR2014,31JUL2014,Keyboard,92 Asus,Zenbook,28MAR2012,13JUL2014,Processor,340 HP,Pavilion,2013,31OCT2015,Keyboard,77 HP,Pavilion,25JUN2013,27AUG2014,Processor,53 Lenovo,Thinkpad,31JUL2012,13JAN2015,Motherboard,325 Toshiba,Kirabook,27AUG2012,12SEP2014,Keyboard,280 Toshiba,Kirabook,19FEB2012,29DEC2014,Processor,187 Lenovo,Thinkpad,02NOV2013,05DEC2014,Hard Drive,322 HP,Pavilion,FEB2013,27OCT2015,Hard Drive,291 Dell,Inspiron,09JUL2013,11NOV2014,Keyboard,62 Lenovo,Thinkpad,2014,16JUL2015,Motherboard,332 HP,Pavilion,22OCT2012,17OCT2014,Motherboard,73 Lenovo,Yoga,15MAR2013,28DEC2014,Keyboard,222 HP,Probook,11JAN2012,09OCT2015,Software,88 Asus,Transformer,28SEP2012,01DEC2015,Processor,168 Asus,Zenbook,28FEB2012,17MAR2015,Software,271 Lenovo,Yoga,29JAN2014,09AUG2015,Motherboard,81 Lenovo,Thinkpad,08APR2014,06SEP2015,Motherboard,188 Lenovo,Thinkpad,2014,14SEP2014,Keyboard,253 HP,Pavilion,21APR2012,17APR2015,Hard Drive,276 HP,Pavilion,21APR2014,20NOV2014,Software,377 Dell,Chromebook,14OCT2013,04JUN2015,Keyboard,280 Dell,XPS,09APR2014,21SEP2014,Keyboard,233 HP,Probook,07APR2013,17JUL2015,Processor,345 HP,Probook,2012,05APR2015,Motherboard,207 Lenovo,Yoga,13OCT2012,19NOV2015,Motherboard,188 Asus,Zenbook,06JUN2012,10MAR2015,Hard Drive,396 Lenovo,Yoga,07NOV2012,14NOV2015,Keyboard,85 Toshiba,Kirabook,01SEP2012,05NOV2015,Motherboard,201 Asus,Transformer,23JAN2013,15DEC2014,Keyboard,53 Toshiba,Kirabook,05AUG2012,04NOV2015,Keyboard,359 Toshiba,Satellite,06MAR2014,04DEC2014,Processor,321 Asus,Transformer,18JUL2012,24JUL2014,Processor,184 Toshiba,Kirabook,19DEC2013,27SEP2015,Keyboard,391 Toshiba,Kirabook,30MAY2014,24SEP2014,Hard Drive,271 Lenovo,Yoga,22JUN2014,03JAN2015,Processor,194 HP,Probook,04SEP2013,17SEP2015,Hard Drive,116 Asus,Zenbook,2013,17MAY2015,Processor,329 HP,Pavilion,OCT2013,27NOV2015,Keyboard,132 Lenovo,Thinkpad,13FEB2014,01JUL2014,Motherboard,228 Dell,Chromebook,24APR2012,21OCT2015,Keyboard,86 Toshiba,Satellite,07OCT2012,02MAR2015,Keyboard,95 Dell,XPS,27DEC2013,24SEP2014,Hard Drive,54 HP,Pavilion,27JUL2013,13AUG2014,Keyboard,182 Lenovo,Yoga,03SEP2012,19FEB2015,Software,342 Asus,Transformer,06MAR2013,20NOV2015,Keyboard,215 Asus,Transformer,05DEC2012,13AUG2015,Keyboard,122 Dell,XPS,22APR2013,12AUG2015,Processor,259 HP,Probook,18APR2013,04AUG2015,Processor,220 Lenovo,Thinkpad,06JAN2014,14MAR2015,Software,98 Lenovo,Thinkpad,14JUL2012,31JUL2015,Keyboard,234 Lenovo,Yoga,25MAY2014,26AUG2015,Keyboard,214 Dell,XPS,05APR2013,10NOV2014,Keyboard,171 Lenovo,Thinkpad,10AUG2012,13AUG2015,Motherboard,141 Toshiba,Kirabook,22JUL2013,23JUL2014,Software,336 HP,Pavilion,24JUN2014,28OCT2015,Software,107 Asus,Transformer,23JUN2012,21JUL2015,Keyboard,207 Dell,Inspiron,12OCT2013,09OCT2014,Hard Drive,128 Lenovo,Yoga,10JAN2012,27FEB2015,Hard Drive,183 Lenovo,Yoga,17DEC2013,13FEB2015,Keyboard,357 Lenovo,Yoga,06DEC2012,01SEP2014,Keyboard,203 Lenovo,Yoga,10SEP2013,27AUG2015,Motherboard,308 Lenovo,Thinkpad,28DEC2012,14APR2015,Keyboard,180 Lenovo,Yoga,03DEC2013,23MAR2015,Hard Drive,232 Lenovo,Yoga,2013,21JUN2015,Motherboard,210 HP,Envy,29JAN2014,02NOV2014,Hard Drive,52 HP,Probook,06JUN2014,27JUL2014,Processor,252 HP,Envy,13DEC2013,02MAR2015,Hard Drive,76 HP,Pavilion,10MAR2014,07OCT2015,Motherboard,161 Dell,Inspiron,24FEB2012,18NOV2014,Hard Drive,182 Dell,Inspiron,13MAR2012,06NOV2015,Keyboard,147 Asus,Zenbook,14DEC2013,26SEP2015,Hard Drive,64 HP,Probook,27APR2012,20JUN2015,Processor,299 Lenovo,Yoga,SEP2013,29SEP2014,Hard Drive,277 Lenovo,Z Series,06NOV2012,09AUG2014,Processor,160 Dell,XPS,15MAY2012,08MAY2015,Keyboard,216 Asus,Transformer,21MAR2013,23FEB2015,Keyboard,261 Lenovo,Yoga,14MAR2013,04DEC2014,Hard Drive,385 Toshiba,Kirabook,11FEB2013,08AUG2014,Processor,281 Asus,Zenbook,27JUL2013,21MAY2015,Hard Drive,92 HP,Pavilion,07MAY2013,27AUG2015,Keyboard,316 Lenovo,Z Series,12NOV2013,27APR2015,Hard Drive,373 Lenovo,Thinkpad,08FEB2013,09DEC2015,Hard Drive,220 Toshiba,Kirabook,27APR2014,19DEC2014,Software,343 Lenovo,Thinkpad,27SEP2013,19JUN2015,Hard Drive,373 Lenovo,Thinkpad,01MAY2014,27SEP2014,Processor,221 Toshiba,Kirabook,22NOV2013,05AUG2014,Motherboard,297 Lenovo,Yoga,SEP2012,21DEC2015,Hard Drive,376 Lenovo,Thinkpad,31JAN2014,20JUL2015,Hard Drive,198 Dell,Inspiron,2012,21SEP2015,Motherboard,360 Dell,XPS,21JUN2014,28SEP2015,Hard Drive,286 Dell,XPS,02SEP2012,11NOV2015,Keyboard,238 Asus,Transformer,21AUG2013,30OCT2015,Hard Drive,188 Asus,Chromebook,10JUL2012,28OCT2014,Keyboard,117 HP,Probook,07DEC2012,10JUL2014,Keyboard,109 Dell,XPS,28OCT2013,27MAR2015,Motherboard,171 Asus,Chromebook,13SEP2012,13JAN2015,Hard Drive,371 Lenovo,Thinkpad,05JUN2014,01NOV2014,Hard Drive,239 HP,Pavilion,10JAN2013,20SEP2015,Motherboard,319 Asus,Zenbook,12MAR2014,03FEB2015,Keyboard,100 Lenovo,Yoga,30APR2014,29JUL2014,Motherboard,156 HP,Probook,26APR2013,04OCT2014,Hard Drive,387 Lenovo,Yoga,20JUL2012,02AUG2014,Hard Drive,109 HP,Pavilion,18MAR2014,07OCT2015,Keyboard,63 Toshiba,Kirabook,23JAN2012,05MAR2015,Software,113 HP,Envy,29MAR2013,05JUL2014,Motherboard,105 Dell,XPS,06APR2014,20JUL2014,Hard Drive,74 Lenovo,Thinkpad,08MAY2013,27AUG2014,Hard Drive,215 Toshiba,Satellite,01MAR2012,13MAY2015,Processor,288 Toshiba,Kirabook,2012,18JUL2015,Motherboard,205 Dell,Inspiron,22JUN2012,05AUG2014,Processor,97 Asus,Transformer,11OCT2013,08JAN2015,Hard Drive,230 HP,Pavilion,12APR2013,07JUL2014,Keyboard,294 HP,Probook,24OCT2012,17SEP2014,Processor,138 Lenovo,Yoga,14NOV2012,05SEP2015,Hard Drive,144 Asus,Transformer,2012,08DEC2015,Keyboard,120 Toshiba,Kirabook,10AUG2013,24SEP2014,Keyboard,79 Lenovo,Yoga,03JUN2012,23JUN2015,Motherboard,221 Asus,Transformer,28MAY2014,24JUL2015,Software,204 Asus,Zenbook,15FEB2014,26JAN2015,Software,191 Dell,XPS,21NOV2012,20SEP2014,Software,354 HP,Envy,23FEB2013,15SEP2014,Processor,194 Toshiba,Kirabook,30DEC2012,26DEC2014,Motherboard,353 Dell,XPS,08MAY2012,21JUL2015,Software,385 HP,Probook,27OCT2012,04DEC2015,Keyboard,158 Toshiba,Kirabook,10NOV2012,14AUG2014,Motherboard,313 Dell,Inspiron,19JAN2014,19NOV2014,Motherboard,364 HP,Pavilion,NOV2013,08JUL2015,Hard Drive,252 Dell,XPS,16NOV2012,17OCT2015,Hard Drive,187 Lenovo,Yoga,16MAY2013,06JUL2015,Hard Drive,285 Lenovo,Thinkpad,09JUN2014,14FEB2015,Hard Drive,382 Dell,XPS,06FEB2014,19APR2015,Keyboard,251 HP,Probook,20JUL2013,02JUL2014,Hard Drive,378 Lenovo,Yoga,11APR2013,02JUL2014,Hard Drive,91 Toshiba,Kirabook,JUN2014,19APR2015,Hard Drive,55 HP,Envy,14OCT2013,09NOV2014,Motherboard,164 Lenovo,Yoga,2012,04JAN2015,Motherboard,368 Lenovo,Yoga,04FEB2012,14JUL2015,Software,305 HP,Envy,28JUL2013,30NOV2015,Keyboard,335 Lenovo,Thinkpad,25JAN2014,22APR2015,Hard Drive,378 Dell,XPS,06MAR2013,17MAY2015,Hard Drive,268 Lenovo,Thinkpad,08FEB2012,24AUG2015,Software,257 Lenovo,Z Series,24NOV2013,16JUN2015,Hard Drive,186 Toshiba,Kirabook,03JUN2012,12NOV2014,Motherboard,114 Lenovo,Thinkpad,12JAN2012,21JUN2015,Keyboard,74 HP,Pavilion,12DEC2013,11DEC2014,Hard Drive,373 Lenovo,Thinkpad,13JAN2014,15JUL2014,Motherboard,199 Asus,Transformer,27MAY2013,22AUG2015,Processor,154 Dell,Inspiron,2013,23AUG2014,Software,362 Dell,Chromebook,29MAR2013,27MAR2015,Processor,82 Lenovo,Yoga,04FEB2012,13MAY2015,Keyboard,325 Lenovo,Thinkpad,30APR2013,15MAR2015,Processor,146 Toshiba,Satellite,25MAY2013,12JUL2014,Processor,184 HP,Probook,16SEP2013,16NOV2015,Motherboard,230 Toshiba,Kirabook,12OCT2012,05JAN2015,Motherboard,269 Lenovo,Thinkpad,07OCT2012,02OCT2014,Motherboard,262 Dell,Chromebook,25MAY2012,14JUL2014,Hard Drive,193 Lenovo,Yoga,22NOV2012,14NOV2015,Keyboard,194 Toshiba,Kirabook,12DEC2013,21NOV2014,Hard Drive,341 HP,Envy,31AUG2013,05NOV2014,Motherboard,211 Dell,Inspiron,02JUN2013,22OCT2014,Keyboard,262 Lenovo,Thinkpad,04APR2012,23AUG2015,Software,140 Dell,XPS,05APR2014,26AUG2014,Hard Drive,235 Lenovo,Yoga,18MAY2014,12JUL2014,Processor,274 Toshiba,Satellite,17APR2012,21FEB2015,Hard Drive,333 HP,Pavilion,2013,17OCT2015,Processor,356 Lenovo,Yoga,2013,23SEP2014,Keyboard,300 Toshiba,Kirabook,16APR2012,03APR2015,Motherboard,102 Lenovo,Thinkpad,04MAR2013,09DEC2014,Keyboard,169 Dell,XPS,09APR2012,11OCT2014,Processor,80 Asus,Zenbook,24JUL2012,24JUN2015,Hard Drive,394 Lenovo,Z Series,25JAN2012,27AUG2015,Processor,315 Lenovo,Yoga,13APR2012,11NOV2015,Processor,111 Asus,Transformer,2013,03AUG2015,Processor,251 Asus,Transformer,JUN2013,15JUL2015,Software,122 Asus,Zenbook,19JUL2012,16FEB2015,Motherboard,173 Lenovo,Thinkpad,25JUN2012,02DEC2015,Motherboard,176 Asus,Zenbook,13OCT2013,22OCT2015,Motherboard,72 Toshiba,Kirabook,15AUG2012,13AUG2015,Keyboard,266 Toshiba,Kirabook,2012,07JUL2014,Processor,193 Dell,XPS,01AUG2012,23OCT2015,Processor,364 Asus,Transformer,06FEB2013,18AUG2014,Processor,286 Lenovo,Thinkpad,10FEB2013,01FEB2015,Keyboard,193 Lenovo,Yoga,17NOV2012,26AUG2014,Keyboard,369 Asus,Zenbook,16JUN2014,26JUL2015,Processor,337 Asus,Chromebook,2013,25FEB2015,Motherboard,262 Asus,Zenbook,30MAY2013,03AUG2015,Motherboard,292 Asus,Transformer,09JUN2013,28OCT2014,Keyboard,132 Lenovo,Yoga,01DEC2012,30AUG2014,Keyboard,240 Asus,Zenbook,21NOV2013,10FEB2015,Software,389 Lenovo,Z Series,JAN2013,11JUL2015,Motherboard,376 HP,Envy,07FEB2014,04JUN2015,Motherboard,303 Lenovo,Yoga,04DEC2013,26OCT2014,Processor,114 Dell,Inspiron,13AUG2012,07NOV2015,Keyboard,262 Dell,Chromebook,09JAN2012,25OCT2014,Processor,340 Asus,Zenbook,17AUG2013,07AUG2014,Hard Drive,154 Asus,Transformer,26MAR2012,26JAN2015,Motherboard,127 Lenovo,Yoga,11JAN2013,04SEP2015,Keyboard,131 Toshiba,Kirabook,19JUL2012,27FEB2015,Hard Drive,370 Dell,XPS,18SEP2012,03NOV2014,Motherboard,337 Asus,Transformer,26JUN2013,13MAR2015,Keyboard,55 Dell,XPS,15MAR2012,25AUG2014,Keyboard,69 Asus,Zenbook,21APR2012,08MAY2015,Processor,127 Asus,Zenbook,25DEC2012,16JUN2015,Software,151 Lenovo,Thinkpad,18MAR2013,16OCT2015,Processor,316 Asus,Transformer,09JUN2013,09APR2015,Hard Drive,368 Dell,XPS,03JUL2013,30SEP2015,Keyboard,240 HP,Pavilion,02SEP2013,10AUG2014,Motherboard,204 HP,Pavilion,22MAY2013,06NOV2015,Hard Drive,251 Lenovo,Yoga,07JAN2014,30JUL2015,Keyboard,137 Lenovo,Yoga,13FEB2014,22FEB2015,Motherboard,374 Asus,Chromebook,28MAY2013,04OCT2015,Hard Drive,382 Asus,Transformer,04MAY2014,29SEP2015,Keyboard,86 Lenovo,Yoga,17NOV2012,16MAY2015,Keyboard,211 Asus,Zenbook,12DEC2012,12AUG2014,Processor,304 Dell,Inspiron,10AUG2013,13JUN2015,Keyboard,173 Dell,XPS,01DEC2012,10JUN2015,Hard Drive,380 Asus,Zenbook,26JAN2012,19JUL2014,Keyboard,287 HP,Envy,12DEC2013,09JUL2014,Software,354 Lenovo,Thinkpad,26SEP2013,12OCT2014,Keyboard,240 HP,Probook,04APR2014,04SEP2015,Processor,219 Lenovo,Z Series,09JAN2014,07NOV2015,Motherboard,185 Toshiba,Satellite,01APR2012,05AUG2015,Keyboard,99 Lenovo,Yoga,04FEB2012,19FEB2015,Motherboard,153 Asus,Zenbook,10APR2013,20DEC2015,Hard Drive,51 Dell,XPS,2012,28JUL2015,Hard Drive,159 Asus,Transformer,27MAY2014,25OCT2014,Hard Drive,139 Lenovo,Thinkpad,25MAY2012,12JUN2015,Processor,383 Toshiba,Kirabook,25JUN2013,03JUL2014,Processor,80 HP,Pavilion,31JAN2014,06NOV2014,Motherboard,270 Lenovo,Thinkpad,12APR2014,10JUL2015,Hard Drive,280 Lenovo,Yoga,14DEC2013,30OCT2015,Software,394 Asus,Zenbook,15DEC2012,20JUL2015,Motherboard,143 Asus,Transformer,01DEC2013,04JUL2014,Motherboard,124 Asus,Transformer,13DEC2013,04JUN2015,Motherboard,388 Asus,Zenbook,27MAR2014,24JAN2015,Processor,394 Asus,Zenbook,08APR2012,23AUG2015,Keyboard,102 Lenovo,Z Series,08JUN2013,11JAN2015,Motherboard,254 Lenovo,Yoga,18MAR2014,04SEP2014,Keyboard,314 HP,Envy,20JUN2012,13AUG2015,Keyboard,327 Lenovo,Thinkpad,31JAN2012,23SEP2015,Keyboard,127 Asus,Transformer,OCT2013,23SEP2015,Motherboard,340 Asus,Chromebook,29JUL2012,15APR2015,Hard Drive,269 Lenovo,Yoga,22APR2013,17JUL2014,Motherboard,190 HP,Envy,31DEC2012,10NOV2014,Hard Drive,383 Lenovo,Yoga,27MAY2014,17NOV2015,Processor,196 Asus,Zenbook,10AUG2012,13AUG2015,Hard Drive,50 Lenovo,Yoga,25JUN2012,09DEC2014,Keyboard,337 Dell,Inspiron,19JAN2012,23JUL2015,Processor,290 Asus,Zenbook,28AUG2013,30DEC2014,Processor,334 Dell,XPS,28APR2014,04JAN2015,Hard Drive,139 Lenovo,Yoga,13DEC2013,10DEC2014,Processor,302 Toshiba,Kirabook,21JAN2012,20SEP2015,Keyboard,203 Dell,Inspiron,01APR2014,09AUG2015,Processor,245 Asus,Zenbook,31DEC2013,28DEC2014,Keyboard,89 Asus,Zenbook,10APR2012,21MAR2015,Motherboard,68 Toshiba,Kirabook,08JUN2012,04OCT2015,Motherboard,119 Dell,XPS,25NOV2013,01DEC2014,Software,339 HP,Probook,01OCT2012,25JUL2014,Motherboard,242 Asus,Transformer,25JUN2012,28NOV2014,Keyboard,179 Asus,Transformer,JUN2012,08AUG2015,Keyboard,318 Lenovo,Thinkpad,21DEC2012,22SEP2014,Keyboard,332 Toshiba,Kirabook,27MAY2012,17OCT2014,Keyboard,102 Asus,Transformer,18OCT2013,02NOV2015,Hard Drive,249 Dell,XPS,04JAN2013,30OCT2014,Keyboard,95 Asus,Transformer,29JUL2013,07MAY2015,Motherboard,109 Dell,Chromebook,17DEC2013,26OCT2015,Motherboard,351 HP,Pavilion,17NOV2013,25OCT2014,Software,82 HP,Probook,28JUL2012,02SEP2015,Hard Drive,68 Asus,Transformer,24SEP2013,04AUG2015,Hard Drive,257 HP,Pavilion,2014,24SEP2015,Keyboard,361 Asus,Transformer,02FEB2013,17NOV2014,Hard Drive,264 Asus,Chromebook,04JUL2012,04DEC2014,Hard Drive,129 HP,Probook,01MAY2014,02APR2015,Processor,243 Asus,Transformer,28JUN2012,27OCT2014,Keyboard,188 HP,Envy,26JUL2012,17SEP2014,Motherboard,191 Asus,Chromebook,23MAR2012,31OCT2015,Hard Drive,275 Dell,XPS,19APR2012,01DEC2014,Motherboard,367 HP,Pavilion,01APR2013,09JUL2014,Motherboard,188 HP,Pavilion,16MAY2013,13JUL2015,Hard Drive,157 Toshiba,Kirabook,08APR2013,18JUL2015,Hard Drive,148 Toshiba,Kirabook,07MAY2012,24SEP2015,Motherboard,234 Lenovo,Yoga,14MAR2013,08AUG2015,Processor,239 Toshiba,Kirabook,10JUN2014,15AUG2014,Keyboard,158 Asus,Transformer,20NOV2012,28OCT2015,Processor,158 Lenovo,Yoga,25OCT2012,22MAY2015,Keyboard,92 Asus,Zenbook,15APR2012,21OCT2014,Hard Drive,346 Lenovo,Thinkpad,2012,18SEP2015,Processor,137 HP,Envy,06MAR2014,16JUN2015,Software,179 Lenovo,Yoga,16JUN2012,02FEB2015,Keyboard,154 Dell,Inspiron,28JUN2014,22NOV2014,Keyboard,165 Asus,Transformer,23AUG2013,21SEP2015,Software,152 HP,Probook,04MAY2014,08JAN2015,Keyboard,369 Asus,Transformer,26MAY2013,29SEP2014,Hard Drive,176 Lenovo,Thinkpad,22MAY2014,07MAY2015,Hard Drive,257 Dell,Chromebook,16MAR2014,31OCT2014,Keyboard,211 HP,Envy,13MAY2014,15AUG2014,Hard Drive,231 Asus,Transformer,04JUN2012,16JAN2015,Keyboard,275 Asus,Zenbook,07APR2012,30SEP2015,Keyboard,373 Lenovo,Yoga,20FEB2014,11AUG2015,Processor,62 Asus,Transformer,22MAR2013,12NOV2014,Motherboard,370 Asus,Transformer,31JUL2013,17DEC2014,Hard Drive,312 Lenovo,Thinkpad,30MAY2012,15AUG2014,Processor,140 Lenovo,Yoga,13APR2013,22AUG2014,Hard Drive,227 HP,Pavilion,11JAN2013,10JUL2014,Processor,128 HP,Probook,20MAY2014,20MAR2015,Hard Drive,211 Lenovo,Yoga,30OCT2013,18AUG2014,Keyboard,62 Lenovo,Thinkpad,14AUG2013,21APR2015,Motherboard,244 Dell,XPS,21MAY2012,08JAN2015,Keyboard,173 HP,Pavilion,03JUN2012,02OCT2014,Hard Drive,280 Lenovo,Thinkpad,07JUL2012,08OCT2014,Processor,343 Lenovo,Thinkpad,05FEB2014,20JUL2015,Hard Drive,128 Asus,Chromebook,01MAR2012,19APR2015,Processor,122 Dell,Inspiron,03JUN2012,03NOV2014,Processor,261 Asus,Zenbook,2013,13SEP2014,Hard Drive,82 Asus,Zenbook,MAR2014,16SEP2014,Processor,373 Toshiba,Kirabook,2013,14MAR2015,Motherboard,370 HP,Probook,16JUN2012,02FEB2015,Keyboard,286 Asus,Transformer,30MAY2013,31JUL2014,Hard Drive,269 Lenovo,Thinkpad,06MAY2012,22SEP2015,Keyboard,383 Asus,Zenbook,30MAY2013,24MAY2015,Motherboard,96 Lenovo,Yoga,FEB2013,08DEC2015,Keyboard,219 Toshiba,Kirabook,30SEP2013,20NOV2015,Motherboard,150 Dell,Chromebook,NOV2012,07MAY2015,Processor,273 Asus,Transformer,14SEP2012,24APR2015,Hard Drive,278 Asus,Zenbook,13MAR2012,19APR2015,Software,156 Asus,Transformer,27OCT2012,20NOV2015,Keyboard,195 Lenovo,Yoga,30APR2013,01SEP2015,Keyboard,233 HP,Envy,11MAR2014,14DEC2015,Keyboard,373 HP,Pavilion,24FEB2012,08AUG2014,Keyboard,376 Lenovo,Thinkpad,24FEB2014,02MAY2015,Keyboard,231 HP,Pavilion,26MAR2012,26SEP2015,Processor,331 Lenovo,Yoga,05MAR2014,05NOV2014,Keyboard,143 Lenovo,Yoga,2013,18DEC2015,Hard Drive,198 Toshiba,Kirabook,06FEB2012,02AUG2014,Processor,241 Dell,XPS,03OCT2013,09AUG2015,Keyboard,364 Lenovo,Yoga,19MAY2014,13DEC2014,Keyboard,140 Lenovo,Yoga,06APR2014,18JAN2015,Software,371 Dell,XPS,16JAN2012,20APR2015,Keyboard,389 HP,Probook,07MAY2013,29SEP2014,Processor,117 HP,Pavilion,08SEP2013,26OCT2015,Keyboard,127 Dell,Chromebook,12JAN2012,30APR2015,Keyboard,160 Lenovo,Thinkpad,24SEP2013,04JUL2014,Keyboard,314 HP,Probook,24SEP2012,14SEP2015,Processor,354 HP,Probook,21JUN2012,02DEC2014,Hard Drive,135 Asus,Transformer,APR2012,26NOV2015,Motherboard,121 HP,Envy,17NOV2012,01AUG2014,Motherboard,295 Lenovo,Yoga,22MAR2012,10OCT2014,Keyboard,324 HP,Pavilion,20FEB2014,03OCT2014,Keyboard,398 Asus,Transformer,26JUN2014,07JAN2015,Processor,173 Lenovo,Yoga,24APR2014,25NOV2014,Processor,318 Lenovo,Thinkpad,26JUN2013,06APR2015,Motherboard,318 HP,Pavilion,08JUN2014,22AUG2015,Hard Drive,300 Toshiba,Satellite,01MAY2013,14MAR2015,Keyboard,274 Lenovo,Thinkpad,06SEP2012,04AUG2015,Hard Drive,156 Toshiba,Satellite,07MAR2012,20MAY2015,Motherboard,234 Asus,Zenbook,05JUL2013,08FEB2015,Hard Drive,118 HP,Probook,18JAN2014,10MAR2015,Software,375 Lenovo,Thinkpad,2014,24JUN2015,Keyboard,278 Lenovo,Yoga,09JAN2012,02SEP2015,Keyboard,358 Lenovo,Thinkpad,16JAN2014,14JUN2015,Hard Drive,278 Lenovo,Z Series,30NOV2013,25JUL2015,Keyboard,169 Asus,Zenbook,17APR2014,02NOV2014,Hard Drive,181 Lenovo,Yoga,16SEP2012,14SEP2014,Keyboard,399 Asus,Transformer,13JUL2013,03SEP2015,Software,140 Dell,Chromebook,2013,27NOV2015,Motherboard,192 Asus,Zenbook,06DEC2012,11MAR2015,Processor,297 Lenovo,Yoga,18MAY2014,22JUL2014,Keyboard,143 Asus,Transformer,27MAR2014,04NOV2015,Motherboard,218 HP,Envy,19MAR2014,11MAY2015,Hard Drive,345 Asus,Zenbook,13OCT2013,10OCT2014,Motherboard,261 Lenovo,Yoga,01APR2012,23SEP2015,Software,299 Lenovo,Thinkpad,15MAR2014,02NOV2015,Processor,380 Asus,Zenbook,20NOV2013,26MAY2015,Motherboard,235 Dell,XPS,AUG2012,04DEC2014,Hard Drive,205 HP,Pavilion,AUG2012,08SEP2014,Hard Drive,250 Lenovo,Yoga,01AUG2012,16MAR2015,Motherboard,145 Lenovo,Yoga,17AUG2012,30MAY2015,Processor,261 Lenovo,Yoga,16JUN2014,30MAY2015,Motherboard,390 Lenovo,Yoga,23SEP2012,15FEB2015,Keyboard,134 Asus,Transformer,14JAN2013,21JUN2015,Processor,374 Toshiba,Kirabook,2014,22OCT2014,Hard Drive,379 HP,Probook,JAN2013,17FEB2015,Keyboard,257 Asus,Transformer,28OCT2012,12NOV2015,Keyboard,261 Lenovo,Yoga,12FEB2014,18APR2015,Keyboard,94 HP,Envy,31JUL2013,04AUG2015,Processor,167 Toshiba,Kirabook,25MAY2012,17OCT2015,Motherboard,75 Asus,Transformer,16FEB2012,11DEC2015,Keyboard,66 Asus,Transformer,29OCT2013,28DEC2014,Motherboard,150 Lenovo,Thinkpad,01MAR2013,16NOV2015,Processor,160 HP,Pavilion,03JAN2013,23AUG2015,Motherboard,73 Toshiba,Satellite,10MAY2013,10JAN2015,Processor,259 Dell,Chromebook,11SEP2013,01JUL2015,Hard Drive,380 HP,Envy,16AUG2012,23APR2015,Processor,345 Toshiba,Satellite,16NOV2012,29AUG2014,Hard Drive,159 HP,Probook,26OCT2012,02OCT2014,Hard Drive,132 Lenovo,Thinkpad,11OCT2013,30MAY2015,Keyboard,271 Asus,Zenbook,12APR2013,02NOV2015,Hard Drive,215 Lenovo,Yoga,01FEB2014,09SEP2015,Hard Drive,381 Lenovo,Yoga,20AUG2013,24JUL2015,Software,203 Dell,Inspiron,APR2014,21FEB2015,Keyboard,160 Lenovo,Thinkpad,21MAR2014,04JUN2015,Software,80 Lenovo,Yoga,16OCT2013,16OCT2015,Hard Drive,309 Dell,Inspiron,18JAN2014,30MAR2015,Software,144 Asus,Zenbook,26FEB2014,19JAN2015,Processor,102 Dell,Inspiron,04JAN2014,24AUG2015,Keyboard,201 Asus,Zenbook,17JUL2012,21JUL2015,Hard Drive,182 Lenovo,Thinkpad,06MAR2014,21JUL2015,Hard Drive,324 Dell,Inspiron,17JAN2013,09AUG2015,Keyboard,324 HP,Pavilion,29JUN2013,21NOV2014,Keyboard,348 HP,Probook,05NOV2012,23OCT2015,Keyboard,368 Lenovo,Z Series,26NOV2013,26AUG2015,Keyboard,114 Lenovo,Yoga,16OCT2012,13OCT2014,Keyboard,388 HP,Pavilion,05NOV2012,10JUN2015,Processor,299 Dell,XPS,30APR2014,18DEC2015,Motherboard,223 Lenovo,Yoga,OCT2013,27DEC2014,Motherboard,94 Lenovo,Z Series,10JAN2012,22JUL2015,Processor,177 Asus,Transformer,03JUN2013,09DEC2014,Keyboard,297 HP,Probook,14JAN2012,17JUN2015,Keyboard,204 Lenovo,Yoga,06MAR2014,19JUL2014,Motherboard,61 Dell,XPS,01AUG2012,09SEP2014,Processor,111 Lenovo,Yoga,12JAN2014,16OCT2014,Keyboard,204 Asus,Transformer,04APR2012,15AUG2015,Software,373 Asus,Transformer,28OCT2012,03JUL2014,Processor,350 Asus,Zenbook,12JUN2014,17AUG2014,Keyboard,92 Toshiba,Satellite,02JAN2013,12OCT2014,Motherboard,155 Toshiba,Kirabook,SEP2013,27MAR2015,Motherboard,315 Dell,XPS,11MAR2012,17AUG2015,Hard Drive,53 HP,Envy,21NOV2012,22MAR2015,Hard Drive,363 HP,Pavilion,25MAY2012,15JAN2015,Hard Drive,93 Lenovo,Yoga,25SEP2012,02JAN2015,Processor,86 Lenovo,Thinkpad,2014,27JAN2015,Hard Drive,369 Dell,Inspiron,10JAN2013,17SEP2014,Motherboard,100 HP,Pavilion,20APR2014,03MAR2015,Motherboard,88 Dell,Inspiron,15FEB2012,26AUG2015,Hard Drive,202 Lenovo,Thinkpad,13JAN2012,14MAY2015,Keyboard,113 Lenovo,Z Series,21JUN2013,28APR2015,Keyboard,200 Dell,XPS,20DEC2012,06APR2015,Hard Drive,165 Dell,XPS,04JAN2012,28NOV2015,Hard Drive,76 Dell,XPS,08AUG2012,05AUG2015,Hard Drive,346 HP,Probook,25MAR2012,17AUG2015,Software,203 Toshiba,Kirabook,26APR2013,02AUG2014,Processor,161 Asus,Transformer,08MAY2013,19OCT2014,Keyboard,67 Asus,Zenbook,21JUL2013,04SEP2015,Hard Drive,160 Asus,Transformer,12APR2012,19JUL2014,Motherboard,261 Asus,Zenbook,28NOV2013,21APR2015,Keyboard,261 Asus,Zenbook,03OCT2013,03JAN2015,Keyboard,184 Asus,Transformer,30JUL2012,10DEC2015,Processor,98 Lenovo,Yoga,15FEB2013,13JUL2014,Keyboard,82 Asus,Transformer,03JUL2012,31MAY2015,Hard Drive,168 Toshiba,Kirabook,11SEP2012,27DEC2015,Motherboard,339 Dell,XPS,30DEC2013,02AUG2014,Keyboard,320 Asus,Zenbook,2012,27JUL2014,Motherboard,345 HP,Envy,09MAY2014,28JUL2014,Hard Drive,207 Toshiba,Kirabook,02OCT2013,27AUG2015,Keyboard,53 Asus,Zenbook,19FEB2014,23FEB2015,Hard Drive,262 Toshiba,Kirabook,10DEC2013,04MAY2015,Processor,291 Lenovo,Yoga,10OCT2013,10JUL2014,Hard Drive,173 HP,Pavilion,10JUN2012,25SEP2014,Keyboard,229 Asus,Zenbook,10APR2014,27OCT2014,Motherboard,363 Lenovo,Yoga,16FEB2014,06DEC2014,Hard Drive,134 Lenovo,Thinkpad,16JUN2014,13AUG2015,Keyboard,59 Lenovo,Thinkpad,25OCT2012,14SEP2014,Motherboard,310 Asus,Zenbook,17APR2014,17FEB2015,Keyboard,181 Asus,Transformer,07MAR2014,01APR2015,Motherboard,278 Toshiba,Satellite,26MAY2014,18AUG2014,Processor,200 Dell,Chromebook,23FEB2014,18NOV2015,Motherboard,195 Lenovo,Yoga,2012,14MAY2015,Keyboard,246 Dell,XPS,01JAN2012,21APR2015,Software,121 Asus,Chromebook,19JUL2012,08DEC2015,Hard Drive,355 HP,Probook,18DEC2012,28JUL2015,Processor,65 Lenovo,Yoga,04APR2013,10AUG2014,Keyboard,235 HP,Probook,30OCT2012,16DEC2015,Software,185 Lenovo,Thinkpad,30SEP2013,06FEB2015,Keyboard,153 HP,Pavilion,29OCT2012,20JUN2015,Keyboard,83 HP,Pavilion,31MAR2012,10APR2015,Hard Drive,178 Asus,Zenbook,28AUG2013,14DEC2014,Hard Drive,220 Asus,Transformer,16MAY2013,05OCT2015,Hard Drive,54 Toshiba,Kirabook,21JAN2013,28SEP2015,Keyboard,252 HP,Pavilion,06MAY2014,17JUL2014,Keyboard,114 HP,Probook,24APR2014,20MAR2015,Software,137 Lenovo,Thinkpad,03FEB2012,31JUL2014,Keyboard,225 Asus,Zenbook,27MAY2012,19OCT2014,Keyboard,282 HP,Pavilion,26JAN2012,15DEC2014,Software,178 HP,Pavilion,27FEB2014,04DEC2015,Software,240 ; Run;

The REPAIR data set contains the record of the list of defective laptops at a local repair store from 2012 to 2015.
 
Tom, the owner of the repair store, is looking to publish a report so that he can make recommendations for customers to buy their next machine.
 
Task 1

Count the number of defective laptops for each brand between 2012 to 2015.

Which brand has the highest number of defective laptops?

Next