[SAS Hard Coding] 车型对应车商代码

今天临时接到一个活，把一堆车辆相关的数据做多维度的分析，其中一个维度是车型车商分类。

再一看数据，瞬间崩溃，录得那个乱啊，无力吐槽，时间紧迫，就写了个Hard Coding的代码来识别：

• 根据某汽车网站的分类来写代码

• 根据实际数据做了些调整

• 时间紧急，没有二级分类，不区分什么“东风本田”、“广汽本田”之类的交叉分类

虽然是Hard Coding，不过这些已有的车分类应该是不会变的。

时间紧迫的产物，部分可能有错漏，各位可以根据自己需要再改改。

居然没有SAS的代码高亮模板。好吧，纯文本也可以，能用就行

data car_2013;set car_2013;

format brand $20.;

      if index(product,'Volvo') thenbrand='沃尔沃';

elseif index(product,'宝马') or index(product,'利星行')

     or index(product,'BMW') or index(product,'MINI Cooper')

     or index(product,'迷你')

     or (index(product,'X5') and index(product,'xDrive') )

     then brand='宝马';

elseif index(product,'捷豹') thenbrand='捷豹';

elseif index(product,'奥迪') or index(product,'Q5') thenbrand='奥迪';

elseif index(product,'轩逸')

or index(product,'逍客')

or index(product,'天籁')

or index(product,'阳光')

or index(product,'骊威')

or index(product,'骐达')

or index(product,'奇骏')

or index(product,'GT-R')

or index(product,'NV200')

or index(product,'玛驰')

or index(product,'楼兰')

or index(product,'帕拉丁')

or index(product,'370Z')

or index(product,'途乐')

or index(product,'D22皮卡')

or index(product,'贵士')

or index(product,'凯普斯达')

or index(product,'D22')

or index(product,'碧莲')

or index(product,'Juke')

or index(product,'Pathfinder')

or index(product,'日产')

or index(product,'聆风')

then brand='日产';

elseif index(product,'大众')

or index(product,'CrossPOLO')

or index(product,'高尔夫')

or index(product,'桑塔纳')

or index(product,'捷达')

or index(product,'朗逸')

or index(product,'速腾')

or index(product,'途观')

or index(product,'宝来')

or index(product,'帕萨特')

or index(product,'迈腾')

or index(product,'POLO')

or index(product,'CC')

or index(product,'朗行')

or index(product,'朗境')

or index(product,'辉腾')

or index(product,'途安')

or index(product,'尚酷')

or index(product,'途锐')

or index(product,'甲壳虫')

or index(product,'Tiguan')

or index(product,'夏朗')

or index(product,'Eos')

or index(product,'Cross')

or index(product,'Multivan')

or index(product,'志俊')

then brand='大众';

elseif index(product,'北现')

           or index(product,'现代')

           or index(product,'索纳塔')

           or index(product,'悦动')

           or index(product,'朗动')

           or index(product,'瑞纳')

           or index(product,'名图')

           or index(product,'途胜')

            orindex(product,'胜达')

           or index(product,'伊兰特')

           or index(product,'劳恩斯')

           or index(product,'飞思')

           or index(product,'格锐')

           or index(product,'名驭')

           or index(product,'雅尊')

           or index(product,'雅科仕')

           or index(product,'维拉克斯')

           or index(product,'康恩迪')

           or index(product,'辉翼')

           or index(product,'ix35')

            then brand='现代';

elseif index(product,'爱丽舍')

or index(product,'世嘉')

or index(product,'雪铁龙')

or index(product,'毕加索')

or index(product,'AIRCROSS')

then brand='雪铁龙';

elseif index(product,'奔驰') or index(product,'Smart') thenbrand='奔驰';

elseif index(product,'汉兰达')

or index(product,'凯美瑞')

or index(product,'威驰')

or index(product,'花冠')

or index(product,'卡罗拉')

or index(product,'RAV4')

or index(product,'锐志')

or index(product,'普拉多')

or index(product,'逸致')

or index(product,'YARiS')

or index(product,'皇冠')

or index(product,'陆地巡洋舰')

or index(product,'兰德酷路泽')

or index(product,'丰田')

or index(product,'雅力士')

or index(product,'普锐斯')

or index(product,'红杉')

or index(product,'FJ酷路泽')

or index(product,'埃尔法')

or index(product,'Wish')

or index(product,'杰路驰')

or index(product,'柯斯达')

or index(product,'普瑞维亚')

or index(product,'威飒')

or index(product,'Sienna')

or index(product,'考斯特')

or index(product,'海狮')

or index(product,'IQ')

then brand='丰田';

elseif index(product,'锋范')

           or index(product,'雅阁')

           or index(product,'锋范')

           or index(product,'凌派')

            orindex(product,'思域')

           or index(product,'飞度')

           or index(product,'杰德')

           or index(product,'歌诗图')

           or index(product,'奥德赛')

           or index(product,'思铭')

           or index(product,'思铂睿')

            orindex(product,'艾力绅')

           or index(product,'音赛特')

           or index(product,'思威')

           or index(product,'理念') /*合资*/

           or index(product,'本田')

           or index(product,'讴歌')

            then brand='本田';

elseif index(product,'英菲尼迪') thenbrand='英菲尼迪';

elseif index(product,'江淮') or index(product,'嘉兴宝俊行') then brand='江淮';

elseif index(product,'雷克萨斯') or index(product,'LEXUS') thenbrand='雷克萨斯';

elseif index(product,'保时捷')

or index(product,'卡宴')

or index(product,'凯宴')

or index(product,'博克斯特')

or index(product,'Cayman')

or index(product,'卡曼')

then brand='保时捷';

elseif index(product,'切诺基')

           or index(product,'Jeep')

           or index(product,'指南者')

           or index(product,'牧马人')

            orindex(product,'自由客')

           or index(product,'自由光')

            then brand='Jeep';

elseif index(product,'别克') or index(product,'君威')

           or index(product,'君越')

           or index(product,'昂科拉')

           or index(product,'林荫大道')

or index(product,'英朗') or index(product,'凯越') thenbrand='别克';

elseif index(product,'路虎') or index(product,'神行者') or index(product,'揽胜') or index(product,'极光') then brand='路虎';

elseif index(product,'凯迪拉克') or index(product,'凯雷德') then brand='凯迪拉克';

elseif index(product,'哈弗') or index(product,'长城') or index(product,'腾翼') thenbrand='长城';

elseif index(product,'起亚') or index(product,'智跑')

           or index(product,'狮跑')

           or index(product,'福瑞迪')

           or index(product,'赛拉图')

            orindex(product,'索兰托')

           or index(product,'秀尔')

           or index(product,'凯尊')

           or index(product,'锐欧')

           or index(product,'新佳乐')

           or index(product,'霸锐')

           or index(product,'速迈') thenbrand='起亚';

  

elseif index(product,'纳智捷')

or index(product,'大7')

or index(product,'MASTER')

then brand='纳智捷';

  

elseif index(product,'科鲁兹')

or index(product,'雪佛兰')

or index(product,'赛欧')

or index(product,'迈锐宝')

or index(product,'科迈罗')

or index(product,'科帕奇')

or index(product,'爱唯欧')

or index(product,'景程')

or index(product,'沃蓝达')

or index(product,'科尔维特')

then brand='雪佛兰';

  

  

elseif index(product,'长安')

or index(product,'致尚')

or index(product,'逸动')

or index(product,'悦翔')

or index(product,'奔奔')

or index(product,'睿骋')

/*以下是商用车*/

or index(product,'欧力威')

or index(product,'欧诺')

or index(product,'勋龙')

or index(product,'镭蒙')

or index(product,'尊行')

or index(product,'星卡')

or index(product,'星光')

or index(product,'金牛星')

or index(product,'运通')

or index(product,'雪虎')

then brand='长安';

  

elseif index(product,'阿斯顿马丁')

then brand='阿斯顿马丁';

  

elseif index(product,'比亚迪')

then brand='比亚迪';

  

elseif index(product,'标致')

then brand='标致';

  

elseif index(product,'宾利')

then brand='宾利';

  

elseif index(product,'传祺')

then brand='广汽';

  

elseif index(product,'大通')

then brand='大通';

  

elseif index(product,'道奇')

or index(product,'酷威')

or index(product,'酷搏')

or index(product,'公羊')

then brand='道奇';

  

elseif index(product,'帝豪')

then brand='帝豪';

  

elseif index(product,'菱悦')

or index(product,'菱致')

or index(product,'菱仕')

or index(product,'得利卡')

or index(product,'希旺')

or index(product,'菱帅')

or index(product,'富利卡')

or index(product,'菱利')

or index(product,'东南')

then brand='东南';

  

elseif index(product,'安德拉')

or index(product,'雅特')

or index(product,'英速亚')

or index(product,'麦瑞纳')

or index(product,'赛飞利')

or index(product,'Monza')

or index(product,'威达')

or index(product,'欧捷利')

or index(product,'欧美佳')

or index(product,'欧宝')

then brand='欧宝';

  

  

elseif index(product,'森林人')

or index(product,'斯巴鲁')

or index(product,'傲虎')

or index(product,'翼豹')

or index(product,'力狮')

or index(product,'驰鹏')

then brand='斯巴鲁';

  

elseif index(product,'奥拓')

or index(product,'雨燕')

or index(product,'锋驭')

or index(product,'天语')

or index(product,'羚羊')

or index(product,'北斗星')

or index(product,'利亚纳')

or index(product,'派喜')

or index(product,'浪迪')

or index(product,'维特拉')

or index(product,'凯泽西')

or index(product,'快捷')

then brand='铃木';

  

elseif index(product,'巴博斯')

then brand='巴博斯';

  

elseif index(product,'奔腾')

then brand='奔腾';

  

elseif index(product,'东风')

or index(product,'景逸')

or index(product,'菱智')

or index(product,'风行')

then brand='东风';

  

elseif index(product,'法拉利')

then brand='法拉利';

  

elseif index(product,'菲翔')

or index(product,'菲亚特')

or index(product,'博悦')

or index(product,'西耶那')

or index(product,'周末风')

or index(product,'派力奥')

or index(product,'领雅')

or index(product,'朋多')

or index(product,'柯罗马')

or index(product,'海酷')

or index(product,'德特乐福斯')

then brand='菲亚特';

  

elseif index(product,'猎豹')

or index(product,'飞扬')

or index(product,'黑金刚')

or index(product,'飞腾')

or index(product,'欧酷曼')

or index(product,'长丰')

or index(product,'金麒麟')

or index(product,'福铃')

or index(product,'飞铃')

then brand='猎豹';

  

elseif index(product,'雷诺')

or index(product,'科雷傲')

or index(product,'风朗')

or index(product,'纬度')

or index(product,'梅甘娜')

or index(product,'风景')

or index(product,'拉古那')

or index(product,'塔利斯曼')

or index(product,'Alpine')

or index(product,'威赛帝')

then brand='雷诺';

  

elseif index(product,'福克斯')

or index(product,'蒙迪欧')

or index(product,'翼虎')

or index(product,'翼搏')

or index(product,'嘉年华')

or index(product,'锐界')

or index(product,'探险者')

or index(product,'致胜')

or index(product,'野马')

or index(product,'麦柯斯')

or index(product,'征服者')

or index(product,'福特')

then brand='福特';

  

elseif index(product,'海马')

or index(product,'丘比特')

or index(product,'福美来')

or index(product,'骑士')

or index(product,'海福星')

or index(product,'欢动')

or index(product,'马自达')

or index(product,'普力马')

or index(product,'睿翼')

then brand='马自达';

  

elseif index(product,'福田')

or index(product,'迷迪')

or index(product,'蒙派克')

or index(product,'拓陆者')

or index(product,'奥铃捷运')

or index(product,'萨普')

or index(product,'欧曼')

or index(product,'风景快运')

or index(product,'奥铃TX')

or index(product,'奥铃CTX')

or index(product,'风景快捷')

or index(product,'欧马可')

then brand='福田';

  

elseif index(product,'金杯')

or index(product,'智尚')

or index(product,'海狮')

or index(product,'阁瑞斯')

or index(product,'海星')

or index(product,'西部大力神')

or index(product,'西部牛仔')

or index(product,'雷龙')

or index(product,'金典')

or index(product,'霸道') /*？？？是丰田的？*/

or index(product,'睿翔')

then brand='金杯';

  

elseif index(product,'悍马')

then brand='悍马';

  

elseif index(product,'江淮')

or index(product,'瑞风')

or index(product,'和悦')

or index(product,'瑞鹰')

or index(product,'悦悦')

or index(product,'宾悦')

or index(product,'同悦')

or index(product,'瑞铃')

then brand='江淮';

  

elseif index(product,'五菱')

or index(product,'宏光')

or index(product,'之光')

or index(product,'荣光')

or index(product,'鸿途')

or index(product,'兴旺')

or index(product,'小旋风')

or index(product,'扬光')

then brand='五菱';

  

elseif index(product,'红旗')

then brand='红旗';

  

elseif index(product,'中华')

or index(product,'骏捷')

or index(product,'尊驰')

or index(product,'酷宝')

then brand='中华';

  

elseif index(product,'克莱斯勒')

or index(product,'大捷龙')

or index(product,'300C')

or index(product,'300M')

or index(product,'城乡')

or index(product,'辉煌')

or index(product,'铂锐')

then brand='克莱斯勒';

  

elseif index(product,'兰博基尼')

or index(product,'Aventador')

or index(product,'盖拉多')

or index(product,'蝙蝠')

or index(product,'Veneno')

then brand='兰博基尼';

  

elseif index(product,'劳斯莱斯')

then brand='劳斯莱斯';

  

elseif index(product,'双龙')

or index(product,'柯兰多')

or index(product,'爱腾')

or index(product,'主席')

or index(product,'路帝')

or index(product,'享御')

then brand='双龙';

  

elseif index(product,'力帆')

or index(product,'丰顺')

or index(product,'兴顺')

or index(product,'X50')

then brand='力帆';

  

elseif index(product,'莲花')

or index(product,'L5 GTS')

or index(product,'L3 GT')

or index(product,'竞悦')

then brand='莲花';

  

elseif index(product,'林肯')

or index(product,'领航员')

or index(product,'城市')

then brand='林肯';

  

elseif index(product,'华泰')

or index(product,'圣达菲')

or index(product,'宝利格')

or index(product,'路盛')

or index(product,'特拉卡')

then brand='华泰';

  

elseif index(product,'陆风')

then brand='陆风';

  

elseif index(product,'玛莎拉蒂')

or index(product,'GranSport')

then brand='玛莎拉蒂';

  

elseif index(product,'吉利')

or index(product,'美人豹')

or index(product,'中国龙')

or index(product,'豪情')

or index(product,'美日')

or index(product,'优利欧')

or index(product,'全球鹰')

or index(product,'自由舰')

or index(product,'熊猫')

or index(product,'远景')

or index(product,'英伦')

or index(product,'金刚')

or index(product,'金鹰')

then brand='吉利';

  

elseif index(product,'明锐')

or index(product,'昕锐')

or index(product,'斯柯达')

or index(product,'昊锐')

or index(product,'晶锐')

or index(product,'速派')

then brand='斯柯达';

  

elseif index(product,'名爵')

or index(product,'MG')

then brand='名爵';

  

elseif index(product,'三菱')

or index(product,'风迪思')

or index(product,'欧蓝德')

or index(product,'帕杰罗')

or index(product,'格蓝迪')

or index(product,'蓝瑟')

or index(product,'君阁')

or index(product,'戈蓝')

or index(product,'劲炫')

or index(product,'伊柯丽斯')

or index(product,'菱绅')

or index(product,'翼神')

then brand='三菱';

  

  

elseif index(product,'奇瑞')

or index(product,'瑞虎')

or index(product,'艾瑞泽')

or index(product,'风云')

or index(product,'旗云')

or index(product,'东方之子')

then brand='奇瑞';

  

elseif index(product,'黄海')

or index(product,'挑战者')

or index(product,'旗胜')

or index(product,'柴神')

or index(product,'傲骏')

or index(product,'翱龙')

or index(product,'曙光骄子')

then brand='黄海';

  

elseif index(product,'启辰')

then brand='启辰';

  

elseif index(product,'依维柯')

or index(product,'欧霸')

then brand='依维柯';

  

elseif index(product,'永源')

or index(product,'风景线')

or index(product,'猎鹰')

or index(product,'庄威')

or index(product,'五星')

then brand='永源';

  

elseif index(product,'江铃')

or index(product,'驭胜')

or index(product,'全顺')

or index(product,'宝典')

or index(product,'域虎')

or index(product,'域虎')

or index(product,'顺达')

or index(product,'凯运')

or index(product,'凯锐')

or index(product,'凯威')

then brand='江铃';

  

if brand='' then brand='其他';

run;