. ************************************************* . * Aufbereitung IKT-Umfrage 2010 * . ************************************************* . . /* Unternehmensgruppe */ . . replace ugruppe=. if (ugruppe<0 < ugruppe>1) (0 real changes made) . . /* Angaben */ . . replace angaben=. if (angaben<0 | angaben>1) (486 real changes made, 486 to missing) . replace angaben=1 if ugruppe==0 (2761 real changes made) . . /* Konkurrenzsituation */ . . replace konkanz=. if konkanz<0 (766 real changes made, 766 to missing) . . replace konkmehr=. if (konkmehr<0 | konkmehr>1) (116 real changes made, 116 to missing) . replace konkmehr=. if konkanz ! =. (0 real changes made) . . replace konkanz_zu_a=. if (konkanz_zu_a<0 | konkanz_zu_a>1) (0 real changes made) . replace konkanz_zu_a=. if konkanz ! =1 (0 real changes made) . . replace konkanz_zu_b=. if konkanz_zu_b<2 (3671 real changes made, 3671 to missing) . . replace konkanz_aus=. if konkanz_aus<0 (768 real changes made, 768 to missing) . replace konkanz_aus=. if (konkanz==. & konkmehr==.) (0 real changes made) . . /* Konkurrenzdummies */ . . gen konkanz1=. (4408 missing values generated) . replace konkanz1=1 if (konkanz>=0 | konkanz<=5) (4408 real changes made) . replace konkanz1=0 if konkanz>5 (2491 real changes made) . . gen konkanz2=. (4408 missing values generated) . replace konkanz2=1 if (konkanz>5 | konkanz<=50) (4408 real changes made) . replace konkanz2=0 if (konkanz>50 | konkanz<=5) (3063 real changes made) . . gen konkanz3=. (4408 missing values generated) . replace konkanz3=1 if konkanz>50 (1146 real changes made) . replace konkanz3=0 if konkanz<=50 (3262 real changes made) . . . gen lkonkanz=ln(konkanz) (998 missing values generated) . . /* Beschäftigentzahlen */ . . replace bges09=. if bges09<0 (1 real change made, 1 to missing) . . gen lbges09=ln(bges09) (1 missing value generated) . replace lbges09=. if lbges09<0 (0 real changes made) . . replace tz_vh=. if tz_vh<0 (1451 real changes made, 1451 to missing) . replace tz_vh=tz_vh/100 tz_vh was byte now float (1972 real changes made) . . replace tz_abs=. if (tz_abs<0 | tz_abs>bges09) (2 real changes made, 2 to missing) . replace tz_vh=(tz_abs/bges09) if tz_vh==. (1150 real changes made) . replace tz_vh=. if (tz_vh<0 | tz_vh>1) (0 real changes made) . . /* Größenklassen */ . . gen gk1=. (4408 missing values generated) . replace gk1=1 if (bges09 >= 5 | bges09 < 50) (4408 real changes made) . replace gk1=0 if (bges09 >= 50 | bges09 < 5) (2265 real changes made) . . gen gk2=. (4408 missing values generated) . replace gk2=1 if (bges09 >= 50 | bges09 < 500) (4408 real changes made) . replace gk2=0 if (bges09 >= 500 | bges09 < 50) (2882 real changes made) . . gen gk3=. (4408 missing values generated) . replace gk3=1 if bges09 >= 500 (469 real changes made) . replace gk3=0 if bges09 < 500 (3939 real changes made) . . /* Qualifikationsstruktur */ . . replace buni_vh=. if buni_vh<0 (27 real changes made, 27 to missing) . replace buni_vh=buni_vh/100 buni_vh was byte now float (1401 real changes made) . replace buni_abs=. if buni_abs<0 (10 real changes made, 10 to missing) . replace buni_vh=(buni_abs/bges09) if buni_vh==. (2335 real changes made) . replace buni_vh=. if (buni_vh<0 | buni_vh>1) (1 real change made, 1 to missing) . . replace bfs_vh=. if bfs_vh<0 (25 real changes made, 25 to missing) . replace bfs_vh=bfs_vh/100 bfs_vh was byte now float (1605 real changes made) . replace bfs_abs=. if bfs_abs<0 (15 real changes made, 15 to missing) . replace bfs_vh=(bfs_abs/bges09) if bfs_vh==. (2330 real changes made) . replace bfs_vh=. if (bfs_vh<0 | bfs_vh>1) (2 real changes made, 2 to missing) . . replace boa_vh=. if boa_vh<0 (29 real changes made, 29 to missing) . replace boa_vh=boa_vh/100 boa_vh was byte now float (902 real changes made) . replace boa_abs=. if boa_abs<0 (20 real changes made, 20 to missing) . replace boa_vh=(boa_abs/bges09) if boa_vh==. (2325 real changes made) . replace boa_vh=. if (boa_vh<0 | boa_vh>1) (2 real changes made, 2 to missing) . . replace baz_vh=. if baz_vh<0 (22 real changes made, 22 to missing) . replace baz_vh=baz_vh/100 baz_vh was byte now float (1046 real changes made) . replace baz_abs=. if baz_abs<0 (5 real changes made, 5 to missing) . replace baz_vh=(baz_abs/bges09) if baz_vh==. (2340 real changes made) . replace baz_vh=. if (baz_vh<0 | baz_vh>1) (0 real changes made) . . gen ohne=boa_vh+baz_vh (433 missing values generated) . . /* Altersstruktur */ . . replace bu30_vh=. if bu30_vh<0 (1718 real changes made, 1718 to missing) . replace bu30_vh=bu30_vh/100 bu30_vh was byte now float (2228 real changes made) . replace bu30_abs=. if bu30_abs<0 (2 real changes made, 2 to missing) . replace bu30_vh=(bu30_abs/bges09) if bu30_vh==. (1326 real changes made) . replace bu30_vh=. if (bu30_vh<0 | bu30_vh>1) (0 real changes made) . . replace bu50_vh=. if bu50_vh<0 (1731 real changes made, 1731 to missing) . replace bu50_vh=bu50_vh/100 bu50_vh was byte now float (2396 real changes made) . replace bu50_abs=. if bu50_abs<0 (2 real changes made, 2 to missing) . replace bu50_vh=(bu50_abs/bges09) if bu50_vh==. (1379 real changes made) . replace bu50_vh=. if (bu50_vh<0 | bu50_vh>1) (1 real change made, 1 to missing) . . gen mittel=1-bu30_vh-bu50_vh (407 missing values generated) . . /* altersgemischte Teams */ . . replace team_alter=. if (team_alter<0 | team_alter>1) (176 real changes made, 176 to missing) . . /* Weiterbildungsmaßnahmen */ . . replace weiter=. if (weiter<0 | weiter>1) (43 real changes made, 43 to missing) . . replace it_weiter_vh=. if it_weiter_vh<0 (1239 real changes made, 1239 to missing) . replace it_weiter_vh=it_weiter_vh/100 it_weiter_vh was byte now float (1406 real changes made) . replace it_weiter_abs=. if it_weiter_abs<0 (2 real changes made, 2 to missing) . replace it_weiter_abs=. if weiter==. (0 real changes made) . replace it_weiter_abs=0 if weiter==0 (691 real changes made) . replace it_weiter_vh=(it_weiter_abs/bges09) if it_weiter_vh==. (1737 real changes made) . replace it_weiter_vh=. if (it_weiter_vh<0 | it_weiter_vh>1) (0 real changes made) . replace it_weiter_vh=. if weiter==. (0 real changes made) . replace it_weiter_vh=0 if weiter==0 (1 real change made) . . replace nit_weiter_vh=. if nit_weiter_vh<0 (1528 real changes made, 1528 to missing) . replace nit_weiter_vh=nit_weiter_vh/100 nit_weiter_vh was byte now float (1962 real changes made) . replace nit_weiter_abs=. if nit_weiter_abs<0 (6 real changes made, 6 to missing) . replace nit_weiter_abs=0 if weiter==0 (691 real changes made) . replace nit_weiter_abs=. if weiter==. (0 real changes made) . replace nit_weiter_vh=(nit_weiter_abs/bges09) if nit_weiter_vh==. (1888 real changes made) . replace nit_weiter_vh=. if (nit_weiter_vh<0 | nit_weiter_vh>1) (0 real changes made) . replace nit_weiter_vh=. if weiter==. (0 real changes made) . replace nit_weiter_vh=0 if weiter==0 (1 real change made) . . /* Personalmanagement-Modelle */ . . replace org_leist=. if (org_leist<0 | org_leist>1) (72 real changes made, 72 to missing) . replace org_konto=. if (org_konto<0 | org_konto>1) (40 real changes made, 40 to missing) . replace org_rot=. if (org_rot<0 | org_rot>1) (48 real changes made, 48 to missing) . replace org_einheit=. if (org_einheit<0 | org_einheit>1) (62 real changes made, 62 to missing) . replace org_eigen=. if (org_eigen<0 | org_eigen>1) (48 real changes made, 48 to missing) . . /* Anteil Beschäftigte am PC */ . . replace pcwork_vh=. if pcwork_vh<0 (1443 real changes made, 1443 to missing) . replace pcwork_vh=pcwork_vh/100 pcwork_vh was byte now float (2783 real changes made) . replace pcwork_abs=. if pcwork_abs<0 (1 real change made, 1 to missing) . replace pcwork_vh=(pcwork_abs/bges09) if pcwork_vh==. (1433 real changes made) . replace pcwork_vh=. if (pcwork_vh<0 | pcwork_vh>1) (1 real change made, 1 to missing) . . /* Beschäftigte mit Internetzugang */ . . replace www_bges_vh=. if www_bges_vh<0 (1241 real changes made, 1241 to missing) . replace www_bges_vh=www_bges_vh/100 www_bges_vh was byte now float (3044 real changes made) . replace www_bges_abs=. if www_bges_abs<0 (2 real changes made, 2 to missing) . replace www_bges_vh=(www_bges_abs/bges09) if www_bges_vh==. (1227 real changes made) . replace www_bges_vh=. if (www_bges_vh<0 | www_bges_vh>1) (0 real changes made) . . replace www_mobil_vh=. if www_mobil_vh<0 (1470 real changes made, 1470 to missing) . replace www_mobil_vh=www_mobil_vh/100 www_mobil_vh was byte now float (1688 real changes made) . replace www_mobil_abs=. if www_mobil_abs<0 (2 real changes made, 2 to missing) . replace www_mobil_vh=(www_mobil_abs/bges09) if www_mobil_vh==. (1429 real changes made) . replace www_mobil_vh=. if (www_mobil_vh<0 | www_mobil_vh>1) (2 real changes made, 2 to missing) . . /* Instrument-Variablen */ . . replace pers_wiki=. if (pers_wiki<0 | pers_wiki>1) (30 real changes made, 30 to missing) . replace pers_smart=. if (pers_smart<0 | pers_smart>1) (20 real changes made, 20 to missing) . replace pers_blog=. if (pers_blog<0 | pers_blog>1) (45 real changes made, 45 to missing) . replace pers_profil=. if (pers_profil<0 | pers_profil>1) (24 real changes made, 24 to missing) . . /* Instrument-Dummy generieren */ . . gen instrument=. (4408 missing values generated) . replace instrument=1 if (pers_wiki==1 | pers_blog==1 | pers_profil==1) (2123 real changes made) . replace instrument=0 if (pers_wiki==0 & pers_blog==0 & pers_profil==0) (2243 real changes made) . . /* Unternehmenssoftware */ . . replace sw_contr=. if (sw_contr<0 | sw_contr>2) (33 real changes made, 33 to missing) . replace sw_crm=. if (sw_crm<0 | sw_crm>2) (71 real changes made, 71 to missing) . replace sw_scm=. if (sw_scm<0 | sw_scm>2) (36 real changes made, 36 to missing) . replace sw_cdms=. if (sw_cdms<0 | sw_cdms>2) (35 real changes made, 35 to missing) . . /* Softwarevariablen generieren */ . . gen erp=. (4408 missing values generated) . replace erp=1 if (sw_contr==1 | sw_contr==2) (3236 real changes made) . replace erp=0 if sw_contr==0 (1139 real changes made) . . gen crm=. (4408 missing values generated) . replace crm=1 if (sw_crm==1 | sw_crm==2) (1865 real changes made) . replace crm=0 if sw_crm==0 (2472 real changes made) . . gen scm=. (4408 missing values generated) . replace scm=1 if (sw_scm==1 | sw_scm==2) (1572 real changes made) . replace scm=0 if sw_scm==0 (2800 real changes made) . . gen cdms=. (4408 missing values generated) . replace cdms=1 if (sw_cdms==1 | sw_cdms==2) (2237 real changes made) . replace cdms=0 if sw_cdms==0 (2136 real changes made) . . /* teilweise Software-Nutzung */ . . gen erp_min=. (4408 missing values generated) . replace erp_min=1 if sw_contr==1 (1172 real changes made) . replace erp_min=0 if (sw_contr==0 | sw_contr==2) (3203 real changes made) . gen erp_max=. (4408 missing values generated) . replace erp_max=1 if sw_contr==2 (2064 real changes made) . replace erp_max=0 if (sw_contr==0 | sw_contr==1) (2311 real changes made) . . gen crm_min=. (4408 missing values generated) . replace crm_min=1 if sw_crm==1 (920 real changes made) . replace crm_min=0 if (sw_crm==0 | sw_crm==2) (3417 real changes made) . gen crm_max=. (4408 missing values generated) . replace crm_max=1 if sw_crm==2 (945 real changes made) . replace crm_max=0 if (sw_crm==0 | sw_crm==1) (3392 real changes made) . . gen scm_min=. (4408 missing values generated) . replace scm_min=1 if sw_scm==1 (710 real changes made) . replace scm_min=0 if (sw_scm==0 | sw_scm==2) (3662 real changes made) . gen scm_max=. (4408 missing values generated) . replace scm_max=1 if sw_scm==2 (862 real changes made) . replace scm_max=0 if (sw_scm==0 | sw_scm==1) (3510 real changes made) . . gen cdms_min=. (4408 missing values generated) . replace cdms_min=1 if sw_cdms==1 (989 real changes made) . replace cdms_min=0 if (sw_cdms==0 | sw_cdms==2) (3384 real changes made) . gen cdms_max=. (4408 missing values generated) . replace cdms_max=1 if sw_cdms==2 (1248 real changes made) . replace cdms_max=0 if (sw_cdms==0 | sw_cdms==1) (3125 real changes made) . . /* Interaction terms */ . . gen erpscm=erp*scm (58 missing values generated) . gen erpcrm=erp*crm (90 missing values generated) . gen scmcrm=scm*crm (92 missing values generated) . gen erpcrmscm=erp*scm*crm (109 missing values generated) . . gen soft=. (4408 missing values generated) . replace soft=1 if (erp==1 | crm==1 | scm==1) (3490 real changes made) . replace soft=0 if (erp==0 & crm==0 & scm==0) (884 real changes made) . . /* E-Commerce */ . . replace www_b2c=. if (www_b2c<0 | www_b2c>2) (5 real changes made, 5 to missing) . replace www_b2b=. if (www_b2b<0 | www_b2b>2) (19 real changes made, 19 to missing) . replace www_best=. if (www_best<0 | www_best>2) (24 real changes made, 24 to missing) . . gen b2c=. (4408 missing values generated) . replace b2c=1 if (www_b2c==1 | www_b2c==2) (903 real changes made) . replace b2c=0 if www_b2c==0 (3500 real changes made) . . gen b2b=. (4408 missing values generated) . replace b2b=1 if (www_b2b==1 | www_b2b==2) (1611 real changes made) . replace b2b=0 if www_b2b==0 (2778 real changes made) . . gen best=. (4408 missing values generated) . replace best=1 if (www_best==1 | www_best==2) (3458 real changes made) . replace best=0 if www_best==0 (926 real changes made) . . /* teilweise Nutzung von E-Commerce */ . . gen b2c_min=. (4408 missing values generated) . replace b2c_min=1 if www_b2c==1 (611 real changes made) . replace b2c_min=0 if (www_b2c==0 | www_b2c==2) (3792 real changes made) . gen b2c_max=. (4408 missing values generated) . replace b2c_max=1 if www_b2c==2 (292 real changes made) . replace b2c_max=0 if (www_b2c==0 | www_b2c==1) (4111 real changes made) . . gen b2b_min=. (4408 missing values generated) . replace b2b_min=1 if www_b2b==1 (1054 real changes made) . replace b2b_min=0 if (www_b2b==0 | www_b2b==2) (3335 real changes made) . gen b2b_max=. (4408 missing values generated) . replace b2b_max=1 if www_b2b==2 (557 real changes made) . replace b2b_max=0 if (www_b2b==0 | www_b2b==1) (3832 real changes made) . . gen best_min=. (4408 missing values generated) . replace best_min=1 if www_best==1 (2160 real changes made) . replace best_min=0 if (www_best==0 | www_best==2) (2224 real changes made) . gen best_max=. (4408 missing values generated) . replace best_max=1 if www_best==2 (1298 real changes made) . replace best_max=0 if (www_best==0 | www_best==1) (3086 real changes made) . . /* E-Commerce allgemein */ . . gen ecom=. (4408 missing values generated) . replace ecom=1 if (b2b==1 | b2c==1) (1909 real changes made) . replace ecom=0 if (b2b==0 & b2c==0) (2484 real changes made) . . /* Vernetzung Unternehmenssoftware */ . . replace sw_net=. if (sw_net<0 | sw_net>1) (51 real changes made, 51 to missing) . replace sw_net=0 if (sw_contr==0 & sw_crm==0 & sw_scm==0) (743 real changes made) . replace sw_net=. if (sw_contr==. & sw_crm==. & sw_scm==.) (2 real changes made, 2 to missing) . . /* IT-Fachkräfte 2009 */ . . replace itges09=. if (itges09<0 | itges09>bges09) (53 real changes made, 53 to missing) . . gen litges09=ln(itges09) (1532 missing values generated) . . /* Einsatz verschiedener Social Software Anwendungen */ . . replace web_wiki=. if (web_wiki<0 | web_wiki>2) (26 real changes made, 26 to missing) . replace web_wiki=0 if web_wiki==2 (489 real changes made) . replace web_blog=. if (web_blog<0 | web_blog>2) (29 real changes made, 29 to missing) . replace web_blog=0 if web_blog==2 (98 real changes made) . replace web_socnet=. if (web_socnet<0 | web_socnet>2) (22 real changes made, 22 to missing) . replace web_socnet=0 if web_socnet==2 (62 real changes made) . replace web_koll=. if (web_koll<0 | web_koll>2) (24 real changes made, 24 to missing) . replace web_koll=0 if web_koll==2 (220 real changes made) . replace web_pod=. if (web_pod<0 | web_pod>2) (24 real changes made, 24 to missing) . replace web_pod=0 if web_pod==2 (112 real changes made) . replace web_rss=. if (web_rss<0 | web_rss>2) (46 real changes made, 46 to missing) . replace web_rss=0 if web_rss==2 (383 real changes made) . replace web_tag=. if (web_tag<0 | web_tag>2) (28 real changes made, 28 to missing) . replace web_tag=0 if web_tag==2 (303 real changes made) . . . /* Social Software Intensität */ . . gen intens = web_wiki + web_blog + web_socnet + web_koll (72 missing values generated) . . /* Socvial Software privat genutzt als Dummy */ . . gen privat=. (4408 missing values generated) . replace privat=1 if (pers_wiki==1 | pers_blog==1 | pers_profil==1) (2123 real changes made) . replace privat=0 if (pers_wiki==0 & pers_blog==0 & pers_profil==0) (2243 real changes made) . . . /* Intensität bei den Instrumenten */ . . gen intens_instr = pers_wiki + pers_blog + pers_profil (64 missing values generated) . . . /* Instrument für Social Software nach Taylor */ . . gen altinstr=. (4408 missing values generated) . replace altinstr=0.2692308 if branche==1 (549 real changes made) . replace altinstr=0.3855422 if branche==2 (177 real changes made) . replace altinstr=0.2545455 if branche==3 (301 real changes made) . replace altinstr=0.2983871 if branche==4 (274 real changes made) . replace altinstr=0.4228856 if branche==5 (326 real changes made) . replace altinstr=0.3513514 if branche==6 (292 real changes made) . replace altinstr=0.3670886 if branche==7 (174 real changes made) . replace altinstr=0.1764706 if branche==8 (261 real changes made) . replace altinstr=0.2688172 if branche==9 (189 real changes made) . replace altinstr=0.2977099 if branche==10 (254 real changes made) . replace altinstr=0.5531915 if branche==11 (190 real changes made) . replace altinstr=0.7189542 if branche==12 (283 real changes made) . replace altinstr=0.4434783 if branche==13 (229 real changes made) . replace altinstr=0.2790698 if branche==14 (136 real changes made) . replace altinstr=0.5217391 if branche==15 (154 real changes made) . replace altinstr=0.4852941 if branche==16 (255 real changes made) . replace altinstr=0.3414634 if branche==17 (169 real changes made) . . gen instr2=altinstr*bges09 (195 missing values generated) . . . /* Zwecke des Einsatzes von Social Software */ . . replace zweck_komint=. if (zweck_komint<0 | zweck_komint>1) (4 real changes made, 4 to missing) . replace zweck_komint=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_komint=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace zweck_wissen=. if (zweck_wissen<0 | zweck_wissen>1) (7 real changes made, 7 to missing) . replace zweck_wissen=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_wissen=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace zweck_projint=. if (zweck_projint<0 | zweck_projint>1) (2 real changes made, 2 to missing) . replace zweck_projint=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_projint=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace zweck_komkund=. if (zweck_komkund<0 | zweck_komkund>1) (9 real changes made, 9 to missing) . replace zweck_komkund=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_komkund=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace zweck_kompart=. if (zweck_kompart<0 | zweck_kompart>1) (9 real changes made, 9 to missing) . replace zweck_kompart=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_kompart=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace zweck_projext=. if (zweck_projext<0 | zweck_projext>1) (10 real changes made, 10 to missing) . replace zweck_projext=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace zweck_projext=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . /* Einführungsjahr Social Software */ . . replace web_jahr=. if web_jahr<0 (91 real changes made, 91 to missing) . replace web_jahr=. if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (0 real changes made) . replace web_jahr=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . /* Halbjahr 2009 */ . . replace web_hj09=. if (web_hj09<0 | web_hj09>2) (3 real changes made, 3 to missing) . replace web_hj09=. if (web_jahr<2009 | web_jahr>2009) (0 real changes made) . replace web_hj09=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . replace web_hj09=. if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (0 real changes made) . . /* Nutzung Social Software */ . . replace ebene_mit=. if (ebene_mit<0 | ebene_mit>1) (5 real changes made, 5 to missing) . replace ebene_mit=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace ebene_mit=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace ebene_proj=. if (ebene_proj<0 | ebene_proj>1) (8 real changes made, 8 to missing) . replace ebene_proj=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace ebene_proj=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace ebene_abt=. if (ebene_abt<0 | ebene_abt>1) (10 real changes made, 10 to missing) . replace ebene_abt=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace ebene_abt=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace ebene_unt=. if (ebene_unt<0 | ebene_unt>1) (5 real changes made, 5 to missing) . replace ebene_unt=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace ebene_unt=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . /* Mitarbeiter mit aktiver Social Software-Nutzung */ . . replace web_bges_vh=. if web_bges_vh<0 (411 real changes made, 411 to missing) . replace web_bges_vh=web_bges_vh/100 web_bges_vh was byte now float (1001 real changes made) . replace web_bges_vh=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace web_bges_vh=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace web_bges_abs=. if (web_bges_abs<0 | web_bges_abs>bges09) (0 real changes made) . replace web_bges_abs=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace web_bges_abs=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . replace web_bges_vh=(web_bges_abs/bges09) if web_bges_vh==. (378 real changes made) . replace web_bges_vh=. if (web_bges_vh<0 | web_bges_vh>1) (0 real changes made) . . /* Social Software als Unternehmensstrategie */ . . replace web_strat=. if (web_strat<0 | web_strat>1) (8 real changes made, 8 to missing) . replace web_strat=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace web_strat=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . . /* Vernetzung von Social Software und Unternehmenssoftware */ . . replace web_net=. if (web_net<0 | web_net>1) (21 real changes made, 21 to missing) . replace web_net=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2913 real changes made) . replace web_net=. if (web_wiki==. & web_blog==. & web_socnet==. & web_koll==.) (0 real changes made) . replace web_net=0 if (sw_contr==0 & sw_crm==0 & sw_scm==0) (31 real changes made) . *replace web_net=. if (sw_contr==. & sw_crm==. & sw_scm==.) . . /* Hemmnisse für Social Software */ . . replace hem_inte=. if (hem_inte<0 | hem_inte>1) (234 real changes made, 234 to missing) . replace hem_sich=. if (hem_sich<0 | hem_sich>1) (200 real changes made, 200 to missing) . replace hem_kont=. if (hem_kont<0 | hem_kont>1) (321 real changes made, 321 to missing) . replace hem_kost=. if (hem_kost<0 | hem_kost>1) (390 real changes made, 390 to missing) . replace hem_bmit=. if (hem_bmit<0 | hem_bmit>1) (196 real changes made, 196 to missing) . replace hem_amit=. if (hem_amit<0 | hem_amit>1) (166 real changes made, 166 to missing) . replace hem_gf=. if (hem_gf<0 | hem_gf>1) (176 real changes made, 176 to missing) . replace hem_kv=. if (hem_kv<0 | hem_kv>1) (29 real changes made, 29 to missing) . . /* verschiedene IT- und Internet-Anwendungen */ . . replace anw_erecr=. if (anw_erecr<0 | anw_erecr>1) (59 real changes made, 59 to missing) . replace anw_anzeig=. if (anw_anzeig<0 | anw_anzeig>1) (74 real changes made, 74 to missing) . replace anw_werb=. if (anw_werb<0 | anw_werb>1) (29 real changes made, 29 to missing) . replace anw_profil=. if (anw_profil<0 | anw_profil>1) (35 real changes made, 35 to missing) . replace anw_blog=. if (anw_blog<0 | anw_blog>1) (44 real changes made, 44 to missing) . replace anw_befrag=. if (anw_befrag<0 | anw_befrag>1) (30 real changes made, 30 to missing) . replace anw_bewert=. if (anw_bewert<0 | anw_bewert>1) (30 real changes made, 30 to missing) . replace anw_inhalt=. if (anw_inhalt<0 | anw_inhalt>1) (80 real changes made, 80 to missing) . . /* Korrektur Social Software */ . . replace web_blog=1 if anw_profil==1 (198 real changes made) . replace web_socnet=1 if anw_profil==1 (141 real changes made) . . . /* Gesamtausgaben für IT und Personal im IT-Bereich */ . . replace cges=. if (cges<0 | cges==0) (1153 real changes made, 1153 to missing) . . gen acges=cges/bges09 (1154 missing values generated) . . gen lacges=ln(acges) (1154 missing values generated) . . /* Anteil Ausgaben externe Dienstleistungen */ . . replace out_vh=. if (out_vh<0 | cges==.) (566 real changes made, 566 to missing) . replace out_vh=0 if cges==0 (0 real changes made) . replace out_vh=out_vh/100 out_vh was byte now float (2293 real changes made) . replace out_abs=. if (out_abs<0 | cges==.) (3 real changes made, 3 to missing) . replace out_abs=0 if out_abs==0 (0 real changes made) . . replace out_vh=(out_abs/cges) if out_vh==. (524 real changes made) . replace out_vh=. if (out_vh<0 | out_vh>1) (4 real changes made, 4 to missing) . . /* Bezug von IT-Leistungen von externen Anbietern */ . . replace out_extern=. if (out_extern<0 | out_extern>1) (28 real changes made, 28 to missing) . replace out_extern=. if (out_vh ! =. | out_abs ! =.) (0 real changes made) . . /* Anteil IT-Ausgaben für externe Anbieter */ . . replace out_extern_vh=. if (out_extern_vh<0 | out_extern==.) (298 real changes made, 298 to missing) . replace out_extern_vh=0 if out_extern==0 (236 real changes made) . replace out_extern_vh=out_extern_vh/100 out_extern_vh was byte now float (489 real changes made) . replace out_extern_abs=. if (out_extern_abs<0 | out_extern==.) (3 real changes made, 3 to missing) . replace out_extern_abs=0 if out_extern==0 (236 real changes made) . replace out_extern_vh=(out_extern_abs/cges) if out_extern_vh==. (0 real changes made) . replace out_extern_vh=. if (out_extern_vh<0 | out_extern_vh>1) (0 real changes made) . . /* IT-Leistungen 2009 vollständig in Deutschland erbracht */ . . replace out_deutsch=. if (out_deutsch<0 | out_deutsch>1) (29 real changes made, 29 to missing) . replace out_deutsch=. if (out_vh==. & out_abs==.) (34 real changes made, 34 to missing) . replace out_deutsch=0 if (out_vh==0 & out_abs==0) (4 real changes made) . replace out_deutsch=0 if out_extern==0 (236 real changes made) . . /* Anteil ausgelagerte IT-Leistungen insgesamt nach Regionen */ . . replace out_de_vh=. if (out_de_vh<0 | out_deutsch==.) (16 real changes made, 16 to missing) . replace out_de_vh=100 if out_deutsch==1 (2589 real changes made) . replace out_de_vh=out_de_vh/100 out_de_vh was byte now float (2751 real changes made) . replace out_de_vh=. if (out_de_vh<0 | out_de_vh>1) (0 real changes made) . replace out_west_vh=. if (out_west_vh<0 |out_deutsch==.) (18 real changes made, 18 to missing) . replace out_west_vh=0 if out_deutsch==1 (2589 real changes made) . replace out_west_vh=out_west_vh/100 out_west_vh was byte now float (124 real changes made) . replace out_west_vh=. if (out_west_vh<0 | out_west_vh>1) (0 real changes made) . replace out_ost_vh=. if (out_ost_vh<0 | out_deutsch==.) (17 real changes made, 17 to missing) . replace out_ost_vh=0 if (out_deutsch==1) (2589 real changes made) . replace out_ost_vh=out_ost_vh/100 out_ost_vh was byte now float (32 real changes made) . replace out_ost_vh=. if (out_ost_vh<0 | out_ost_vh>1) (0 real changes made) . replace out_asien_vh=. if (out_asien_vh<0 | out_deutsch==.) (16 real changes made, 16 to missing) . replace out_asien_vh=0 if (out_deutsch==1) (2589 real changes made) . replace out_asien_vh=out_asien_vh/100 out_asien_vh was byte now float (28 real changes made) . replace out_asien_vh=. if (out_asien_vh<0 | out_asien_vh>1) (0 real changes made) . replace out_rest_vh=. if (out_rest_vh<0 | out_deutsch==.) (16 real changes made, 16 to missing) . replace out_rest_vh=0 if (out_deutsch==1) (2589 real changes made) . replace out_rest_vh=out_rest_vh/100 out_rest_vh was byte now float (19 real changes made) . replace out_rest_vh=. if (out_rest_vh<0 | out_rest_vh>1) (0 real changes made) . . /* Umsatz 2009 in Mio. */ . . replace ums09=. if ums09<0 (1145 real changes made, 1145 to missing) . . gen lums09=ln(ums09) (1146 missing values generated) . . replace umsren09=. if umsren09<0 (114 real changes made, 114 to missing) . replace umsren09=umsren09/100 umsren09 was int now float (4055 real changes made) . replace umsren09=. if (umsren09<0 | umsren09>1) (2437 real changes made, 2437 to missing) . . replace umsren09_kat=0. if umsren09_kat<1 (774 real changes made) . . /* Umsatz in Tsd */ . . gen ums09_tsd2=ums09*1000 (1145 missing values generated) . . gen lums09_tsd2=ln(ums09_tsd2) (1146 missing values generated) . . /* Produktinnovationen */ . . replace pd=. if (pd<0 | pd>1) (51 real changes made, 51 to missing) . replace pdanz=. if (pdanz<0 | pd==.) (330 real changes made, 330 to missing) . replace pdanz=0 if pd==0 (1971 real changes made) . . replace pd_ums_vh=. if (pd_ums_vh<0 | pd==.) (516 real changes made, 516 to missing) . replace pd_ums_vh=0 if (pd==0 | pdanz==0) (1971 real changes made) . . replace pd_ums_abs=. if (pd_ums_abs<0 | pd==.) (3 real changes made, 3 to missing) . replace pd_ums_abs=0 if (pd==0 | pdanz==0) (1971 real changes made) . . replace pd_ums_vh=(pd_ums_abs/ums09) if pd_ums_vh==. pd_ums_vh was byte now float (64 real changes made) . replace pd_ums_vh=pd_ums_vh/100 (1564 real changes made) . replace pd_ums_vh=. if (pd_ums_vh<0 | pd_ums_vh>1) (18 real changes made, 18 to missing) . . /* Prozessinnovationen */ . . replace pz=. if (pz<0 | pz>1) (52 real changes made, 52 to missing) . replace pzanz=. if (pzanz<0 | pz==.) (385 real changes made, 385 to missing) . replace pzanz=0 if pz==0 (1613 real changes made) . . replace pz_kost_vh=. if (pz_kost_vh<0 | pz==.) (765 real changes made, 765 to missing) . replace pz_kost_vh=0 if (pz==0 | pzanz==0) (1613 real changes made) . replace pz_kost_vh=pz_kost_vh/100 pz_kost_vh was byte now float (1295 real changes made) . replace pz_kost_vh=. if (pz_kost_vh<0 | pz_kost_vh>1) (0 real changes made) . . /* Anteil Forschungs- und Entwicklungsaufwendungen am Umsatz 2009 */ . . replace fue_vh=. if fue_vh<0 (720 real changes made, 720 to missing) . replace fue_vh=fue_vh/100 fue_vh was int now float (1520 real changes made) . replace fue_abs=. if fue_abs<0 (2 real changes made, 2 to missing) . . replace fue_vh=(fue_abs/ums09) if fue_vh==. (121 real changes made) . replace fue_vh=. if (fue_vh<0 | fue_vh>1) (113 real changes made, 113 to missing) . . replace fue_extern_vh=. if (fue_extern_vh<0 | fue_vh==.) (752 real changes made, 752 to missing) . replace fue_extern_vh=0 if fue_vh==0 (2168 real changes made) . . replace fue_bges=. if fue_bges<0 (156 real changes made, 156 to missing) . replace fue_bges=. if fue_bges>bges09 (1 real change made, 1 to missing) . replace fue_bges=. if (fue_vh==. & fue_abs==.) (451 real changes made, 451 to missing) . replace fue_bges=0 if (fue_vh==0 & fue_abs==0) (0 real changes made) . . /* Betriebsrat oder Personalrat */ . . replace rat=0. if (rat<0 | rat>1) (23 real changes made) . . /* Wechsel in der Geschäftsleitung */ . . replace wechselgf=. if (wechselgf<0 | wechselgf>1) (16 real changes made, 16 to missing) . . replace wechselgf_jahr=. if (wechselgf_jahr<0 | wechselgf==.) (17 real changes made, 17 to missing) . replace wechselgf_jahr=. if wechselgf==0 (0 real changes made) . . /* Bruttoinvestitionen 2009 in Mio. */ . . replace binv09=. if binv09<0 (1725 real changes made, 1725 to missing) . . . /* > /* Imputation Investitionen */ > > bys branche: egen median_binv09 = median(binv09) > bys branche: egen pc10_binv09= pctile(binv09), p(10) > > > replace binv09 = median_binv if binv09==. > replace binv09 = pc10_binv if binv09==0 > */ . . . gen lbinv09=ln(binv09) (1858 missing values generated) . . replace lbinv09=0.00001 if binv09==0 (133 real changes made) . . /* Bruttoinvestitionen pro Beschäftigte */ . . gen binv09em=binv09/bges09 (1725 missing values generated) . . gen lbinv09em=ln(binv09em) (1858 missing values generated) . . replace lbinv09em=0.00001 if binv09em==0 (133 real changes made) . . /* Bruttoinvestitionen in Tsd. */ . . gen binv09_tsd2=binv09*1000 (1725 missing values generated) . gen lbinv09_tsd2=ln(binv09_tsd2) (1858 missing values generated) . . /* IT-Investitionen 2009 */ . . replace itinv09=. if itinv09<0 (823 real changes made, 823 to missing) . . replace itinv_hw_vh=. if itinv_hw_vh<0 (574 real changes made, 574 to missing) . replace itinv_hw_vh=itinv_hw_vh/100 itinv_hw_vh was byte now float (3034 real changes made) . replace itinv_hw_vh=. if (itinv_hw_vh<0 | itinv_hw_vh>1) (0 real changes made) . replace itinv_hw_vh=0 if itinv09==0 (249 real changes made) . . replace itinv_sw_vh=. if itinv_sw_vh<0 (575 real changes made, 575 to missing) . replace itinv_sw_vh=itinv_sw_vh/100 itinv_sw_vh was byte now float (2736 real changes made) . replace itinv_sw_vh=. if (itinv_sw_vh<0 | itinv_sw_vh>1) (0 real changes made) . replace itinv_sw_vh=0 if itinv09==0 (240 real changes made) . . replace itinv_tk_vh=. if itinv_tk_vh<0 (569 real changes made, 569 to missing) . replace itinv_tk_vh=itinv_tk_vh/100 itinv_tk_vh was byte now float (2007 real changes made) . replace itinv_tk_vh=. if (itinv_tk_vh<0 | itinv_tk_vh>1) (0 real changes made) . replace itinv_tk_vh=0 if itinv09==0 (239 real changes made) . . /* Anteil Personalkosten am Umsatz */ . . replace pkost_vh=. if pkost_vh<0 (1427 real changes made, 1427 to missing) . replace pkost_vh=pkost_vh/100 pkost_vh was byte now float (2963 real changes made) . . replace pkost_abs=. if pkost_abs<0 (13 real changes made, 13 to missing) . replace pkost_vh=(pkost_abs/ums09) if pkost_vh==. (54 real changes made) . replace pkost_vh=. if (pkost_vh<0 | pkost_vh>1) (51 real changes made, 51 to missing) . . /* Anteil Materialaufwand und Vorleistungen am Umsatz */ . . replace mkost_vh=. if mkost_vh<0 (1370 real changes made, 1370 to missing) . replace mkost_vh=mkost_vh/100 mkost_vh was byte now float (2856 real changes made) . . replace mkost_abs=. if mkost_abs<0 (10 real changes made, 10 to missing) . replace mkost_vh=(mkost_abs/ums09) if mkost_vh==. (49 real changes made) . replace mkost_vh=. if (mkost_vh<0 | mkost_vh>1) (46 real changes made, 46 to missing) . . /* Exporte 2009 */ . . replace exp=. if (exp<0 | exp>1) (20 real changes made, 20 to missing) . . replace exp_vh=. if (exp_vh<0 | exp==.) (330 real changes made, 330 to missing) . replace exp_vh=0 if exp==0 (2274 real changes made) . replace exp_vh=exp_vh/100 exp_vh was byte now float (1780 real changes made) . replace exp_vh=. if (exp_vh<0 | exp_vh>1) (0 real changes made) . . /* Standort im Ausland */ . . replace standort=. if (standort<0 | standort>1) (6 real changes made, 6 to missing) . . /* Importe */ . . replace imp=. if (imp<0 | imp>1) (33 real changes made, 33 to missing) . . /* Bezug von Vorleistungen aus dem Ausland */ . . replace offs_vh=. if (offs_vh<0 | imp==.) (483 real changes made, 483 to missing) . replace offs_vh=0 if imp==0 (2443 real changes made) . replace offs_vh=offs_vh/100 offs_vh was byte now float (1438 real changes made) . replace offs_vh=. if (offs_vh<0 | offs_vh>1) (0 real changes made) . . /* Auslandsaktivität allgemein (Export und Import) */ . . gen ausland=. (4408 missing values generated) . replace ausland=1 if (exp==1 | imp==1) (2576 real changes made) . replace ausland=0 if (exp==0 | imp==0) (2911 real changes made) . . /* Innovation allgemein */ . . gen inno=. (4408 missing values generated) . replace inno=1 if (pd==1 | pz==1) (3428 real changes made) . replace inno=0 if (pd==0 & pz==0) (943 real changes made) . . /* Homepage */ . . replace homepage=. if (homepage<0 | homepage>1) (8 real changes made, 8 to missing) . . /* Arbeitsproduktivität in Mio. */ . . gen lp=ums09/bges09 (1145 missing values generated) . gen llp=ln(lp) (1146 missing values generated) . . /*Arbeitsproduktivität in Tsd. */ . . gen lp_tsd=lums09_tsd2/bges09 (1146 missing values generated) . gen llp_tsd=ln(lp_tsd) (1146 missing values generated) . . gen socsof1=. (4408 missing values generated) . replace socsof1=1 if (web_wiki==1 | web_blog==1 | web_socnet==1 | web_koll==1 | web_pod==1 | web_rss==1 | web_tag==1) (1705 real changes made) . replace socsof1=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0 & web_pod==0 & web_rss==0 & web_tag==0) (2655 real changes made) . . gen socsof2=. (4408 missing values generated) . replace socsof2=1 if (web_wiki==1 | web_blog==1 | web_socnet==1 | web_koll==1) (1529 real changes made) . replace socsof2=0 if (web_wiki==0 & web_blog==0 & web_socnet==0 & web_koll==0) (2841 real changes made) . replace socsof2=1 if web_jahr==2010 (0 real changes made) . . gen socsof3=. (4408 missing values generated) . replace socsof3=1 if (web_wiki==1 | web_blog==1 | web_socnet==1) (1185 real changes made) . replace socsof3=0 if (web_wiki==0 & web_blog==0 & web_socnet==0) (3187 real changes made) . . /* Social Software und mindestens eine Enterprise Software Application */ . . gen soces1=. (4408 missing values generated) . replace soces1=1 if (socsof1==1 & soft==1) (1571 real changes made) . replace soces1=0 if (socsof1==0 | soft==0) (2787 real changes made) . . gen soces2=. (4408 missing values generated) . replace soces2=1 if (socsof1==1 & soft==1) (1571 real changes made) . replace soces2=0 if (socsof1==0 | soft==0) (2787 real changes made) . . gen soces3=. (4408 missing values generated) . replace soces3=1 if (socsof1==1 & soft==1) (1571 real changes made) . replace soces3=0 if (socsof1==0 | soft==0) (2787 real changes made) . . /* Interaktionsterm Social Software und CRM */ . . gen soccrm=crm*socsof1 (110 missing values generated) . . *===============================================* . * Bandwagon-Effect bei web_net * . *===============================================* . . gen bandwagon1=. (4408 missing values generated) . replace bandwagon1=0.1627907 if branche==1 (549 real changes made) . replace bandwagon1=0.2191781 if branche==2 (177 real changes made) . replace bandwagon1=0.1685393 if branche==3 (301 real changes made) . replace bandwagon1=0.1747573 if branche==4 (274 real changes made) . replace bandwagon1=0.2163743 if branche==5 (326 real changes made) . replace bandwagon1=0.1505376 if branche==6 (292 real changes made) . replace bandwagon1=0.2352941 if branche==7 (174 real changes made) . replace bandwagon1=0.1075269 if branche==8 (261 real changes made) . replace bandwagon1=0.2051282 if branche==9 (189 real changes made) . replace bandwagon1=0.1880342 if branche==10 (254 real changes made) . replace bandwagon1=0.3589744 if branche==11 (190 real changes made) . replace bandwagon1=0.4142857 if branche==12 (283 real changes made) . replace bandwagon1=0.2 if branche==13 (229 real changes made) . replace bandwagon1=0.1621622 if branche==14 (136 real changes made) . replace bandwagon1=0.2380952 if branche==15 (154 real changes made) . replace bandwagon1=0.2711864 if branche==16 (255 real changes made) . replace bandwagon1=0.1388889 if branche==17 (169 real changes made) . . *===============================================* . * Bandwagon-Effect bei sw_net * . *===============================================* . . gen bandwagon2=. (4408 missing values generated) . replace bandwagon2=0.5448276 if branche==1 (549 real changes made) . replace bandwagon2=0.7307692 if branche==2 (177 real changes made) . replace bandwagon2=0.5981308 if branche==3 (301 real changes made) . replace bandwagon2=0.661157 if branche==4 (274 real changes made) . replace bandwagon2=0.7164948 if branche==5 (326 real changes made) . replace bandwagon2=0.7196262 if branche==6 (292 real changes made) . replace bandwagon2=0.6923077 if branche==7 (174 real changes made) . replace bandwagon2=0.5614035 if branche==8 (261 real changes made) . replace bandwagon2=0.6 if branche==9 (189 real changes made) . replace bandwagon2=0.5294118 if branche==10 (254 real changes made) . replace bandwagon2=0.6808511 if branche==11 (190 real changes made) . replace bandwagon2=0.66 if branche==12 (283 real changes made) . replace bandwagon2=0.6608696 if branche==13 (229 real changes made) . replace bandwagon2=0.75 if branche==14 (136 real changes made) . replace bandwagon2=0.5869565 if branche==15 (154 real changes made) . replace bandwagon2=0.6538462 if branche==16 (255 real changes made) . replace bandwagon2=0.5365854 if branche==17 (169 real changes made) . . *====================================* . * Bandwagon-Effekt bei IT-Beratung * . *====================================* . . gen bandwagon_ber=. (4408 missing values generated) . replace bandwagon_ber=0.3694268 if branche==1 (549 real changes made) . replace bandwagon_ber=0.6144578 if branche==2 (177 real changes made) . replace bandwagon_ber=0.5044248 if branche==3 (301 real changes made) . replace bandwagon_ber=0.432 if branche==4 (274 real changes made) . replace bandwagon_ber=0.4371859 if branche==5 (326 real changes made) . replace bandwagon_ber=0.4955752 if branche==6 (292 real changes made) . replace bandwagon_ber=0.4814815 if branche==7 (174 real changes made) . replace bandwagon_ber=0.3813559 if branche==8 (261 real changes made) . replace bandwagon_ber=0.4086022 if branche==9 (189 real changes made) . replace bandwagon_ber=0.3410853 if branche==10 (254 real changes made) . replace bandwagon_ber=0.5217391 if branche==11 (190 real changes made) . replace bandwagon_ber=0.3290323 if branche==12 (283 real changes made) . replace bandwagon_ber=0.5128205 if branche==13 (229 real changes made) . replace bandwagon_ber=0.6046512 if branche==14 (136 real changes made) . replace bandwagon_ber=0.4680851 if branche==15 (154 real changes made) . replace bandwagon_ber=0.4264706 if branche==16 (255 real changes made) . replace bandwagon_ber=0.3571429 if branche==17 (169 real changes made) . . *====================================* . * Bandwagon-Effekt bei IT-Beratung * . *====================================* . . gen bandwagon_weiter=. (4408 missing values generated) . replace bandwagon_weiter=0.0523529 if branche==1 (549 real changes made) . replace bandwagon_weiter=0.1165385 if branche==2 (177 real changes made) . replace bandwagon_weiter=0.0775676 if branche==3 (301 real changes made) . replace bandwagon_weiter=0.0704959 if branche==4 (274 real changes made) . replace bandwagon_weiter=0.1326203 if branche==5 (326 real changes made) . replace bandwagon_weiter=0.1186111 if branche==6 (292 real changes made) . replace bandwagon_weiter=0.1139241 if branche==7 (174 real changes made) . replace bandwagon_weiter=0.1306087 if branche==8 (261 real changes made) . replace bandwagon_weiter=0.098913 if branche==9 (189 real changes made) . replace bandwagon_weiter=0.0782677 if branche==10 (254 real changes made) . replace bandwagon_weiter=0.1452273 if branche==11 (190 real changes made) . replace bandwagon_weiter=0.3203947 if branche==12 (283 real changes made) . replace bandwagon_weiter=0.1823853 if branche==13 (229 real changes made) . replace bandwagon_weiter=0.22725 if branche==14 (136 real changes made) . replace bandwagon_weiter=0.2682222 if branche==15 (154 real changes made) . replace bandwagon_weiter=0.1471875 if branche==16 (255 real changes made) . replace bandwagon_weiter=0.06 if branche==17 (169 real changes made) . . *Branchendummies generieren* . . gen id1=1 if branche==1 (3859 missing values generated) . replace id1=0 if (branche!=1 & branche!=.) (3859 real changes made) . gen id2=1 if branche==2 (4231 missing values generated) . replace id2=0 if (branche!=2 & branche!=.) (4231 real changes made) . gen id3=1 if branche==3 (4107 missing values generated) . replace id3=0 if (branche!=3 & branche!=.) (4107 real changes made) . gen id4=1 if branche==4 (4134 missing values generated) . replace id4=0 if (branche!=4 & branche!=.) (4134 real changes made) . gen id5=1 if branche==5 (4082 missing values generated) . replace id5=0 if (branche!=5 & branche!=.) (4082 real changes made) . gen id6=1 if branche==6 (4116 missing values generated) . replace id6=0 if (branche!=6 & branche!=.) (4116 real changes made) . gen id7=1 if branche==7 (4234 missing values generated) . replace id7=0 if (branche!=7 & branche!=.) (4234 real changes made) . gen id8=1 if branche==8 (4147 missing values generated) . replace id8=0 if (branche!=8 & branche!=.) (4147 real changes made) . gen id9=1 if branche==9 (4219 missing values generated) . replace id9=0 if (branche!=9 & branche!=.) (4219 real changes made) . gen id10=1 if branche==10 (4154 missing values generated) . replace id10=0 if (branche!=10 & branche!=.) (4154 real changes made) . gen id11=1 if branche==11 (4218 missing values generated) . replace id11=0 if (branche!=11 & branche!=.) (4218 real changes made) . gen id12=1 if branche==12 (4125 missing values generated) . replace id12=0 if (branche!=12 & branche!=.) (4125 real changes made) . gen id13=1 if branche==13 (4179 missing values generated) . replace id13=0 if (branche!=13 & branche!=.) (4179 real changes made) . gen id14=1 if branche==14 (4272 missing values generated) . replace id14=0 if (branche!=14 & branche!=.) (4272 real changes made) . gen id15=1 if branche==15 (4254 missing values generated) . replace id15=0 if (branche!=15 & branche!=.) (4254 real changes made) . gen id16=1 if branche==16 (4153 missing values generated) . replace id16=0 if (branche!=16 & branche!=.) (4153 real changes made) . gen id17=1 if branche==17 (4239 missing values generated) . replace id17=0 if (branche!=17 & branche!=.) (4239 real changes made) . drop if branche==0 (195 observations deleted) . . /* Verarbeitendes Gewerbe */ . . gen verarb=. (4213 missing values generated) . replace verarb=1 if (branche==1 | branche==2 | branche==3 | branche==4 | branche==5 | branche==6 | branche==7) (2093 real changes made) . replace verarb=0 if (branche==8 | branche==9 | branche==10 | branche==11 | branche==12 | branche==13 | branche==14 |branche==15 | branche==16 | branche==17) (2120 real changes made) . . gen dl=. (4213 missing values generated) . replace dl=1 if (branche==8 | branche==9 | branche==10 | branche==11 | branche==12 | branche==13 | branche==14 |branche==15 | branche==16 | branche==17) (2120 real changes made) . replace dl=0 if (branche==1 | branche==2 | branche==3 | branche==4 | branche==5 | branche==6 | branche==7) (2093 real changes made) . . /* Ostdummy */ . . replace ost=. if (ost<0 | ost>1) (0 real changes made) . . /* Interaktion Ost-Dummy und Investitionen/Arbeit */ . . . gen ostbges09=ost*lbges09 . . gen ostbinv09=ost*lbinv09 (1664 missing values generated) . . . sort lfdnr . . save "H:\Produktivität_SOCSOF\Daten_2010", replace file H:\Produktivität_SOCSOF\Daten_2010.dta saved . . **************************************************************** . * Aufbereitung IKT-Umfrage 2007 * . **************************************************************** . . use "H:\Produktivität_SOCSOF\!ikt2007_end", clear . . /* Variablen umbenennen */ . . rename nace_manuell nace_manuell07 . rename pers100_1 pers100_1_07 . rename pers100_2 pers100_2_07 . rename pers100_3 pers100_3_07 . rename pers100_4 pers100_4_07 . rename pers100_5 pers100_5_07 . rename pers100_6 pers100_6_07 . rename pers100_7 pers100_7_07 . rename pers100_8 pers100_8_07 . rename pers100_9 pers100_9_07 . rename pers100_10 pers100_10_07 . rename pers100_11 pers100_11_07 . rename pers100_12 pers100_12_07 . rename pers100_open pers100_open_07 . rename ugruppe ugruppe07 . rename angaben angaben07 . rename standort standort07 . rename typ typ07 . rename typ_open typ_open07 . rename konkanz konkanz07 . rename konkmehr konkmehr07 . rename tz_vh tz_vh07 . rename e_bges e_bges07 . rename quali_start quali_start07 . rename buni_vh buni_vh07 . rename bfs_vh bfs_vh07 . rename boa_vh boa_vh07 . rename baz_vh baz_vh07 . rename buni_abs buni_abs07 . rename bfs_abs bfs_abs07 . rename boa_abs boa_abs07 . rename baz_abs baz_abs07 . rename bu30 bu3007 . rename bu50 bu5007 . rename weiter weiter07 . rename it_weiter_vh it_weiter_vh07 . rename nit_weiter_vh nit_weiter_vh07 . rename pc pc07 . rename net net07 . rename pcwork pcwork07 . rename www_zug www_zug07 . rename www_bges www_bges07 . rename www_modem www_modem07 . rename www_kabel www_kabel07 . rename www_dsl www_dsl07 . rename www_stand www_stand07 . rename www_power www_power07 . rename www_sat www_sat07 . rename www_wimax www_wimax07 . rename www_umts www_umts07 . rename www_werb www_werb07 . rename www_voip www_voip07 . rename www_b2c www_b2c07 . rename www_b2b www_b2b07 . rename www_best www_best07 . rename sw_edi sw_edi07 . rename sw_contr sw_contr07 . rename sw_crm sw_crm07 . rename sw_scm sw_scm07 . rename sw_elearn sw_elearn07 . rename out_vh out_vh07 . rename out_deutsch out_deutsch07 . rename out_de_vh out_de_vh07 . rename out_eu_vh out_eu_vh07 . rename out_welt_vh out_welt_vh07 . rename out_bp out_bp07 . rename out_hardsoft out_hardsoft07 . rename out_infra out_infra07 . rename out_programm out_programm07 . rename out_asp out_asp07 . rename out_bp_vh out_bp_vh07 . rename out_hardsoft_vh out_hardsoft_vh07 . rename out_infra_vh out_infra_vh07 . rename out_programm_vh out_programm_vh07 . rename out_asp_vh out_asp_vh07 . rename out_bp_jahr out_bp_jahr07 . rename out_hardsoft_jahr out_hardsoft_jahr07 . rename out_infra_jahr out_infra_jahr07 . rename out_programm_jahr out_programm_jahr07 . rename out_asp_jahr out_asp_jahr07 . rename bpo_pers bpo_pers07 . rename bpo_buch bpo_buch07 . rename bpo_besch bpo_besch07 . rename bpo_vertr bpo_vertr07 . rename bpo_mark bpo_mark07 . rename bpo_serv bpo_serv07 . rename bpo_pers_jahr bpo_pers_jahr07 . rename bpo_buch_jahr bpo_buch_jahr07 . rename bpo_besch_jahr bpo_besch_jahr07 . rename bpo_vertr_jahr bpo_vertr_jahr07 . rename bpo_mark_jahr bpo_mark_jahr07 . rename bpo_serv_jahr bpo_serv_jahr07 . rename zielbpo_kost zielbpo_kost07 . rename zielbpo_proz zielbpo_proz07 . rename zielbpo_kern zielbpo_kern07 . rename beratung beratung07 . rename ber_art_it ber_art_it07 . rename ber_art_org ber_art_org07 . rename ber_art_strat ber_art_strat07 . rename ber_art_hr ber_art_hr07 . rename ber_it ber_it07 . rename berkost_vh berkost_vh07 . rename berkost_abs berkost_abs07 . rename binno_pz binno_pz07 . rename binno_org binno_org07 . rename binno_pd binno_pd07 . rename binno_strat binno_strat07 . rename ber_neunotw ber_neunotw07 . rename pd pd07 . rename pdanz pdanz07 . rename pd_ums_vh pd_ums_vh07 . rename pd_ums_abs pd_ums_abs07 . rename pz pz07 . rename pzanz pzanz07 . rename pz_kost_vh pz_kost_vh07 . rename fue_vh fue_vh07 . rename fue_abs fue_abs07 . rename fue_bges fue_bges07 . rename rat rat07 . rename tarif tarif07 . rename wechselgf wechselgf07 . rename e_ums e_ums07 . rename e_ums_vh e_ums_vh07 . rename lage lage07 . rename binv_abs binv_abs07 . rename pkost_vh pkost_vh07 . rename mkost_vh mkost_vh07 . rename exp exp07 . rename exp_vh exp_vh07 . rename imp imp07 . rename imp_vh imp_vh07 . rename homepage_adr homepage_adr07 . rename ost ost07 . rename branche branche07 . . /* Unternehmensgruppe 2007 */ . . replace ugruppe07=. if (ugruppe07<0 < ugruppe07>1) (0 real changes made) . . /* Angaben 2007 */ . . replace angaben07=. if (angaben07<0 | angaben07>1) (499 real changes made, 499 to missing) . replace angaben07=1 if ugruppe07==0 (2787 real changes made) . . /* Standort im Ausland 2007 */ . . replace standort07=. if (standort07<0 | standort07>1) (0 real changes made) . . /* Konkurrenzsituation 2007 */ . . replace konkanz07=. if konkanz07<0 (857 real changes made, 857 to missing) . . replace konkmehr07=. if (konkmehr07<0 | konkmehr07>1) (38 real changes made, 38 to missing) . replace konkmehr=. if konkanz ! =. (0 real changes made) . . /* Beschäftigentzahlen 2007 */ . . replace bges06=. if bges06<0 (38 real changes made, 38 to missing) . . replace tz_vh07=. if tz_vh07<0 (297 real changes made, 297 to missing) . replace tz_vh07=tz_vh07/100 tz_vh07 was int now float (3138 real changes made) . replace tz_vh07=. if (tz_vh07<0 | tz_vh07>1) (0 real changes made) . . /* Erwartung Personalbestand 2007 */ . . replace e_bges=. if (e_bges<0 | e_bges>2) (52 real changes made, 52 to missing) . . /* Qualifikationsstruktur 2007 */ . . replace buni_vh07=. if buni_vh07<0 (38 real changes made, 38 to missing) . replace buni_vh07=buni_vh07/100 buni_vh07 was int now float (1629 real changes made) . replace buni_abs07=. if buni_abs07<0 (13 real changes made, 13 to missing) . replace buni_vh07=(buni_abs07/bges06) if buni_vh07==. (2163 real changes made) . replace buni_vh07=. if (buni_vh07<0 | buni_vh07>1) (4 real changes made, 4 to missing) . . replace bfs_vh07=. if bfs_vh07<0 (43 real changes made, 43 to missing) . replace bfs_vh07=bfs_vh07/100 bfs_vh07 was int now float (1813 real changes made) . replace bfs_abs07=. if bfs_abs07<0 (18 real changes made, 18 to missing) . replace bfs_vh07=(bfs_abs07/bges06) if bfs_vh07==. (2158 real changes made) . replace bfs_vh07=. if (bfs_vh07<0 | bfs_vh07>1) (7 real changes made, 7 to missing) . . replace boa_vh07=. if boa_vh07<0 (40 real changes made, 40 to missing) . replace boa_vh07=boa_vh07/100 boa_vh07 was int now float (1118 real changes made) . replace boa_abs07=. if boa_abs07<0 (17 real changes made, 17 to missing) . replace boa_vh07=(boa_abs07/bges06) if boa_vh07==. (2159 real changes made) . replace boa_vh07=. if (boa_vh07<0 | boa_vh07>1) (0 real changes made) . . replace baz_vh07=. if baz_vh07<0 (32 real changes made, 32 to missing) . replace baz_vh07=baz_vh07/100 baz_vh07 was int now float (1206 real changes made) . replace baz_abs07=. if baz_abs07<0 (6 real changes made, 6 to missing) . replace baz_vh07=(baz_abs07/bges06) if baz_vh07==. (2170 real changes made) . replace baz_vh07=. if (baz_vh07<0 | baz_vh07>1) (0 real changes made) . . /* Altersstruktur 2007 */ . . replace bu3007=. if bu3007<0 (318 real changes made, 318 to missing) . replace bu3007=bu3007/100 bu3007 was int now float (3634 real changes made) . replace bu3007=. if (bu3007<0 | bu3007>1) (0 real changes made) . . replace bu5007=. if bu5007<0 (288 real changes made, 288 to missing) . replace bu5007=bu5007/100 bu5007 was int now float (3745 real changes made) . replace bu5007=. if (bu5007<0 | bu5007>1) (0 real changes made) . . gen b30u5007=1-bu3007-bu5007 (330 missing values generated) . . /* Weiterbildungsmaßnahmen 2007 */ . . replace weiter07=. if (weiter07<0 | weiter07>1) (60 real changes made, 60 to missing) . . replace it_weiter_vh07=. if it_weiter_vh07<0 (152 real changes made, 152 to missing) . replace it_weiter_vh07=it_weiter_vh07/100 it_weiter_vh07 was int now float (2485 real changes made) . replace it_weiter_vh07=. if (it_weiter_vh07<0 | it_weiter_vh07>1) (0 real changes made) . replace it_weiter_vh07=. if weiter07==. (0 real changes made) . replace it_weiter_vh07=0 if weiter07==0 (823 real changes made) . . replace nit_weiter_vh07=. if nit_weiter_vh07<0 (221 real changes made, 221 to missing) . replace nit_weiter_vh07=nit_weiter_vh07/100 nit_weiter_vh07 was int now float (2541 real changes made) . replace nit_weiter_vh07=. if (nit_weiter_vh07<0 | nit_weiter_vh07>1) (0 real changes made) . replace nit_weiter_vh07=. if weiter07==. (0 real changes made) . replace nit_weiter_vh07=0 if weiter07==0 (823 real changes made) . . /* IT im Unternehmen */ . . replace pc07=. if pc07<0 (23 real changes made, 23 to missing) . . /* intern vernetzte Computer im Unternehmen */ . . replace net07=. if net07<0 (20 real changes made, 20 to missing) . replace net07=. if pc07==. (20 real changes made, 20 to missing) . replace net07=0 if pc07==0 (7 real changes made) . . /* Anteil Beschäftigte am PC 2007 */ . . replace pcwork07=. if pcwork07<0 (17 real changes made, 17 to missing) . replace pcwork07=pcwork07/100 pcwork07 was int now float (4275 real changes made) . replace pcwork07=. if (pcwork07<0 | pcwork07>1) (0 real changes made) . replace pcwork07=. if pc07==. (21 real changes made, 21 to missing) . replace pcwork07=0 if pc07==0 (7 real changes made) . . /* Internetzugang 2007 */ . . replace www_zug07=. if (www_zug07<0 | www_zug07>1) (1 real change made, 1 to missing) . replace www_zug07=. if pc07==. (23 real changes made, 23 to missing) . replace www_zug07=0 if pc07==0 (7 real changes made) . . /* Beschäftigte mit Internetzugang 2007 */ . . replace www_bges07=. if www_bges07<0 (24 real changes made, 24 to missing) . replace www_bges07=www_bges07/100 www_bges07 was int now float (4300 real changes made) . replace www_bges07=. if (www_bges07<0 | www_bges07>1) (0 real changes made) . replace www_bges07=. if www_zug07==. (21 real changes made, 21 to missing) . replace www_bges07=0 if www_zug07==0 (38 real changes made) . . /* externer Internetzugang 2007 */ . . replace www_modem07=. if (www_modem07<0 | www_modem07>1) (0 real changes made) . replace www_modem07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_modem07=0 if www_zug07==0 (38 real changes made) . . replace www_kabel07=. if (www_kabel07<0 | www_kabel07>1) (0 real changes made) . replace www_kabel07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_kabel07=0 if www_zug07==0 (38 real changes made) . . replace www_dsl07=. if (www_dsl07<0 | www_dsl07>1) (0 real changes made) . replace www_dsl07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_dsl07=0 if www_zug07==0 (38 real changes made) . . replace www_stand07=. if (www_stand07<0 | www_stand07>1) (0 real changes made) . replace www_stand07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_stand07=0 if www_zug07==0 (38 real changes made) . . replace www_power07=. if (www_power07<0 | www_power07>1) (0 real changes made) . replace www_power07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_power07=0 if www_zug07==0 (38 real changes made) . . replace www_sat07=. if (www_sat07<0 | www_sat07>1) (0 real changes made) . replace www_sat07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_sat07=0 if www_zug07==0 (38 real changes made) . . replace www_wimax07=. if (www_wimax07<0 | www_wimax07>1) (0 real changes made) . replace www_wimax07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_wimax07=0 if www_zug07==0 (38 real changes made) . . replace www_umts07=. if (www_umts07<0 | www_umts07>1) (0 real changes made) . replace www_umts07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_umts07=0 if www_zug07==0 (38 real changes made) . . /* Zwecke der Internetnutzung 2007 */ . . replace www_werb07=. if (www_werb07<0 | www_werb07>2) (15 real changes made, 15 to missing) . replace www_werb07=. if www_zug07==. (22 real changes made, 22 to missing) . replace www_werb07=0 if www_zug07==0 (38 real changes made) . . replace www_voip07=. if (www_voip07<0 | www_voip07>2) (13 real changes made, 13 to missing) . replace www_voip07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_voip07=0 if www_zug07==0 (38 real changes made) . . replace www_b2c07=. if (www_b2c07<0 | www_b2c07>2) (5 real changes made, 5 to missing) . replace www_b2c07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_b2c07=0 if www_zug07==0 (38 real changes made) . . replace www_b2b07=. if (www_b2b07<0 | www_b2b07>2) (7 real changes made, 7 to missing) . replace www_b2b07=. if www_zug07==. (23 real changes made, 23 to missing) . replace www_b2b07=0 if www_zug07==0 (38 real changes made) . . replace www_best07=. if (www_best07<0 | www_best07>2) (7 real changes made, 7 to missing) . replace www_best07=. if www_zug07==. (22 real changes made, 22 to missing) . replace www_best07=0 if www_zug07==0 (38 real changes made) . . /* E-commerce 2007 */ . . gen b2b07=. (4434 missing values generated) . replace b2b07=1 if (www_b2b07==1 | www_b2b07==2) (2318 real changes made) . replace b2b07=0 if www_b2b07==0 (2085 real changes made) . . gen b2c07=. (4434 missing values generated) . replace b2c07=1 if (www_b2c07==1 | www_b2c07==2) (1168 real changes made) . replace b2c07=0 if www_b2c07==0 (3237 real changes made) . . gen ecom07=. (4434 missing values generated) . replace ecom07=1 if (b2b07==1 | b2c07==1) (2608 real changes made) . replace ecom07=0 if (b2b07==0 & b2c07==0) (1795 real changes made) . . /* Unternehmenssoftware 2007 */ . . replace sw_contr07=. if (sw_contr07<0 | sw_contr07>2) (34 real changes made, 34 to missing) . replace sw_contr07=. if pc07==. (23 real changes made, 23 to missing) . replace sw_contr07=0 if pc07==0 (7 real changes made) . replace sw_crm07=. if (sw_crm07<0 | sw_crm07>2) (27 real changes made, 27 to missing) . replace sw_crm07=. if www_zug07==. (24 real changes made, 24 to missing) . replace sw_crm07=0 if www_zug07==0 (38 real changes made) . replace sw_scm07=. if (sw_scm07<0 | sw_scm07>2) (42 real changes made, 42 to missing) . replace sw_scm07=. if www_zug07==. (22 real changes made, 22 to missing) . replace sw_scm07=0 if www_zug07==0 (38 real changes made) . replace sw_edi07=. if (sw_edi07<0 | sw_edi07>2) (193 real changes made, 193 to missing) . replace sw_edi07=. if pc07==. (19 real changes made, 19 to missing) . replace sw_edi07=0 if pc07==0 (7 real changes made) . replace sw_elearn07=. if (sw_elearn07<0 | sw_elearn07>2) (8 real changes made, 8 to missing) . replace sw_elearn07=. if www_zug07==. (24 real changes made, 24 to missing) . replace sw_elearn07=0 if www_zug07==0 (38 real changes made) . . /* Softwarevariablen 2007 generieren */ . . gen erp07=. (4434 missing values generated) . replace erp07=1 if (sw_contr07==1 | sw_contr07==2) (2578 real changes made) . replace erp07=0 if sw_contr07==0 (1799 real changes made) . . gen crm07=. (4434 missing values generated) . replace crm07=1 if (sw_crm07==1 | sw_crm07==2) (2068 real changes made) . replace crm07=0 if sw_crm07==0 (2315 real changes made) . . gen scm07=. (4434 missing values generated) . replace scm07=1 if (sw_scm07==1 | sw_scm07==2) (1614 real changes made) . replace scm07=0 if sw_scm07==0 (2756 real changes made) . . gen edi07=. (4434 missing values generated) . replace edi07=1 if (sw_edi07==1 | sw_edi07==2) (1485 real changes made) . replace edi07=0 if sw_edi07==0 (2737 real changes made) . . gen elearn07=. (4434 missing values generated) . replace elearn07=1 if (sw_elearn07==1 | sw_elearn07==2) (1917 real changes made) . replace elearn07=0 if sw_elearn07==0 (2485 real changes made) . . /* teilweise Software-Nutzung 2007 */ . . gen erp_min07=. (4434 missing values generated) . replace erp_min07=1 if sw_contr07==1 (722 real changes made) . replace erp_min07=0 if (sw_contr07==0 | sw_contr07==2) (3655 real changes made) . gen erp_max07=. (4434 missing values generated) . replace erp_max07=1 if sw_contr07==2 (1856 real changes made) . replace erp_max07=0 if (sw_contr07==0 | sw_contr07==1) (2521 real changes made) . . gen crm_min07=. (4434 missing values generated) . replace crm_min07=1 if sw_crm07==1 (1141 real changes made) . replace crm_min07=0 if (sw_crm07==0 | sw_crm07==2) (3242 real changes made) . gen crm_max07=. (4434 missing values generated) . replace crm_max07=1 if sw_crm07==2 (927 real changes made) . replace crm_max07=0 if (sw_crm07==0 | sw_crm07==1) (3456 real changes made) . . gen scm_min07=. (4434 missing values generated) . replace scm_min07=1 if sw_scm07==1 (995 real changes made) . replace scm_min07=0 if (sw_scm07==0 | sw_scm07==2) (3375 real changes made) . gen scm_max07=. (4434 missing values generated) . replace scm_max07=1 if sw_scm07==2 (619 real changes made) . replace scm_max07=0 if (sw_scm07==0 | sw_scm07==1) (3751 real changes made) . . gen edi_min07=. (4434 missing values generated) . replace edi_min07=1 if sw_edi07==1 (875 real changes made) . replace edi_min07=0 if (sw_edi07==0 | sw_edi07==2) (3347 real changes made) . gen edi_max07=. (4434 missing values generated) . replace edi_max07=1 if sw_edi07==2 (610 real changes made) . replace edi_max07=0 if (sw_edi07==0 | sw_edi07==1) (3612 real changes made) . . gen elearn_min07=. (4434 missing values generated) . replace elearn_min07=1 if sw_elearn07==1 (1537 real changes made) . replace elearn_min07=0 if (sw_elearn07==0 | sw_elearn07==2) (2865 real changes made) . gen elearn_max07=. (4434 missing values generated) . replace elearn_max07=1 if sw_elearn07==2 (380 real changes made) . replace elearn_max07=0 if (sw_elearn07==0 | sw_elearn07==1) (4022 real changes made) . . /* Interaction terms 2007 */ . . gen erpscm07=erp07*scm07 (90 missing values generated) . gen erpcrm07=erp07*crm07 (78 missing values generated) . gen scmcrm07=scm07*crm07 (80 missing values generated) . gen erpcrmscm07=erp07*scm07*crm07 (104 missing values generated) . . gen soft07=. (4434 missing values generated) . replace soft07=1 if (erp07==1 | crm07==1 | scm07==1) (3187 real changes made) . replace soft07=0 if (erp07==0 & crm07==0 & scm07==0) (1189 real changes made) . . /* IT-Fachkräfte 2007 */ . . replace itges06=. if (itges06<0 | itges06>bges06) (33 real changes made, 33 to missing) . replace itges06=. if pc07==. (18 real changes made, 18 to missing) . replace itges06=0 if pc07==0 (7 real changes made) . . gen litges06=ln(itges06) (1664 missing values generated) . . gen ant_itges06=itges06/bges06 (81 missing values generated) . . /* Dummies für IT-Fachkräfte */ . . gen it1=. (4434 missing values generated) . replace it1=1 if ant_itges06<=0.3 (4034 real changes made) . replace it1=0 if ant_itges06>0.3 (400 real changes made) . . gen it2=. (4434 missing values generated) . replace it2=1 if (ant_itges06>0.3 & ant_itges06<=0.6) (123 real changes made) . replace it2=0 if (ant_itges06<=0.3 & ant_itges06>0.6) (0 real changes made) . . gen it3=. (4434 missing values generated) . replace it3=1 if (ant_itges06>0.6 & ant_itges06<=1) (196 real changes made) . replace it3=0 if ant_itges06<=0.6 (4157 real changes made) . . /* Anteil Ausgaben externe Dienstleistungen 2007 */ . . replace out_vh07=. if out_vh07<0 (95 real changes made, 95 to missing) . replace out_vh07=out_vh07/100 out_vh07 was int now float (3088 real changes made) . replace out_vh07=. if (out_vh07<0 | out_vh07>1) (0 real changes made) . replace out_vh07=. if pc07==. (17 real changes made, 17 to missing) . replace out_vh07=0 if pc07==0 (7 real changes made) . . /* IT-Leistungen 2007 vollständig in Deutschland erbracht */ . . replace out_deutsch07=. if (out_deutsch07<0 | out_deutsch07>1) (39 real changes made, 39 to missing) . replace out_deutsch07=. if out_vh07==. (79 real changes made, 79 to missing) . replace out_deutsch07=0 if out_vh07==0 (1245 real changes made) . . /* Anteil ausgelagerte IT-Leistungen insgesamt nach Regionen 2007 */ . . replace out_de_vh07=. if out_de_vh07<0 (21 real changes made, 21 to missing) . replace out_de_vh07=. if out_deutsch07==. (8 real changes made, 8 to missing) . replace out_de_vh07=100 if out_deutsch07==1 (2786 real changes made) . replace out_de_vh07=out_de_vh07/100 out_de_vh07 was int now float (3009 real changes made) . replace out_de_vh07=. if (out_de_vh07<0 | out_de_vh07>1) (0 real changes made) . replace out_eu_vh07=. if out_eu_vh07<0 (23 real changes made, 23 to missing) . replace out_eu_vh07=. if out_deutsch07==. (8 real changes made, 8 to missing) . replace out_eu_vh07=0 if out_deutsch07==1 (2786 real changes made) . replace out_eu_vh07=out_eu_vh07/100 out_eu_vh07 was int now float (198 real changes made) . replace out_eu_vh07=. if (out_eu_vh07<0 | out_eu_vh07>1) (0 real changes made) . replace out_welt_vh07=. if out_welt_vh07<0 (22 real changes made, 22 to missing) . replace out_welt_vh07=. if out_deutsch07==. (8 real changes made, 8 to missing) . replace out_welt_vh07=0 if out_deutsch07==1 (2786 real changes made) . replace out_welt_vh07=out_welt_vh07/100 out_welt_vh07 was int now float (83 real changes made) . replace out_welt_vh07=. if (out_welt_vh07<0 | out_welt_vh07>1) (0 real changes made) . . /* Grad des Outscourcings 2007 */ . . replace out_bp07=. if (out_bp07<0 | out_bp07>3) (32 real changes made, 32 to missing) . replace out_bp07=. if out_vh07==. (93 real changes made, 93 to missing) . replace out_bp07=0 if out_vh07==0 (1245 real changes made) . . replace out_hardsoft07=. if (out_hardsoft07<0 | out_hardsoft07>3) (38 real changes made, 38 to missing) . replace out_hardsoft07=. if out_vh07==. (91 real changes made, 91 to missing) . replace out_hardsoft07=0 if out_vh07==0 (1245 real changes made) . . replace out_infra07=. if (out_infra07<0 | out_infra07>3) (62 real changes made, 62 to missing) . replace out_infra07=. if out_vh07==. (92 real changes made, 92 to missing) . replace out_infra07=0 if out_vh07==0 (1245 real changes made) . . replace out_programm07=. if (out_programm07<0 | out_programm07>3) (20 real changes made, 20 to missing) . replace out_programm07=. if out_vh07==. (95 real changes made, 95 to missing) . replace out_programm07=0 if out_vh07==0 (1245 real changes made) . . replace out_asp07=. if (out_asp07<0 | out_asp07>3) (133 real changes made, 133 to missing) . replace out_asp07=. if out_vh07==. (76 real changes made, 76 to missing) . replace out_asp07=0 if out_vh07==0 (1245 real changes made) . . /* Anteil teilweiser Auslagerung 2007 */ . . replace out_bp_vh07=. if out_bp_vh07<0 (50 real changes made, 50 to missing) . replace out_bp_vh07=. if out_bp07==. (19 real changes made, 19 to missing) . replace out_bp_vh07=0 if (out_bp07==1 | out_bp07==0) (2190 real changes made) . replace out_bp_vh07=100 if out_bp07==3 (802 real changes made) . replace out_bp_vh07=out_bp_vh07/100 out_bp_vh07 was int now float (2072 real changes made) . replace out_bp_vh07=. if (out_bp_vh07<0 | out_bp_vh07>1) (0 real changes made) . . replace out_hardsoft_vh07=. if out_hardsoft_vh07<0 (27 real changes made, 27 to missing) . replace out_hardsoft_vh07=. if out_hardsoft07==. (24 real changes made, 24 to missing) . replace out_hardsoft_vh07=0 if (out_hardsoft07==1 | out_hardsoft07==0) (1961 real changes made) . replace out_hardsoft_vh07=100 if out_hardsoft07==3 (894 real changes made) . replace out_hardsoft_vh07=out_hardsoft_vh07/100 out_hardsoft_vh07 was int now float (2321 real changes made) . replace out_hardsoft_vh07=. if (out_hardsoft_vh07<0 | out_hardsoft_vh07>1) (0 real changes made) . . replace out_infra_vh07=. if out_infra_vh07<0 (16 real changes made, 16 to missing) . replace out_infra_vh07=. if out_infra07==. (13 real changes made, 13 to missing) . replace out_infra_vh07=0 if (out_infra07==1 | out_infra07==0) (2916 real changes made) . replace out_infra_vh07=100 if out_infra07==3 (589 real changes made) . replace out_infra_vh07=out_infra_vh07/100 out_infra_vh07 was int now float (1346 real changes made) . replace out_infra_vh07=. if (out_infra_vh07<0 | out_infra_vh07>1) (0 real changes made) . . replace out_programm_vh07=. if out_programm_vh07<0 (35 real changes made, 35 to missing) . replace out_programm_vh07=. if out_programm07==. (23 real changes made, 23 to missing) . replace out_programm_vh07=0 if (out_programm07==1 | out_programm07==0) (2028 real changes made) . replace out_programm_vh07=100 if out_programm07==3 (1194 real changes made) . replace out_programm_vh07=out_programm_vh07/100 out_programm_vh07 was int now float (2262 real changes made) . replace out_programm_vh07=. if (out_programm_vh07<0 | out_programm_vh07>1) (0 real changes made) . . /* seit wann Auslagerung 2007 */ . . replace out_bp_jahr07=. if out_bp_jahr07<0 (104 real changes made, 104 to missing) . replace out_bp_jahr07=. if (out_bp07==0 | out_bp07==1) (0 real changes made) . . replace out_hardsoft_jahr07=. if out_hardsoft_jahr07<0 (89 real changes made, 89 to missing) . replace out_hardsoft_jahr07=. if (out_hardsoft07==0 | out_hardsoft07==1) (0 real changes made) . . replace out_infra_jahr07=. if out_infra_jahr07<0 (42 real changes made, 42 to missing) . replace out_infra_jahr07=. if (out_infra07==0 | out_infra07==1) (0 real changes made) . . replace out_programm_jahr07=. if out_programm_jahr07<0 (80 real changes made, 80 to missing) . replace out_programm_jahr07=. if (out_programm07==0 | out_programm07==1) (0 real changes made) . . replace out_asp_jahr07=. if out_asp_jahr07<0 (28 real changes made, 28 to missing) . replace out_asp_jahr07=. if (out_asp07==0 | out_asp07==1) (0 real changes made) . . /* Business Process Outsourcing 2007 */ . . replace bpo_pers07=. if (bpo_pers07<0 | bpo_pers07>2) (11 real changes made, 11 to missing) . replace bpo_buch07=. if (bpo_buch07<0 | bpo_buch07>2) (10 real changes made, 10 to missing) . replace bpo_besch07=. if (bpo_besch07<0 | bpo_besch07>2) (27 real changes made, 27 to missing) . replace bpo_vertr07=. if (bpo_vertr07<0 | bpo_vertr07>2) (3 real changes made, 3 to missing) . replace bpo_mark07=. if (bpo_mark07<0 | bpo_mark07>2) (7 real changes made, 7 to missing) . replace bpo_serv07=. if (bpo_serv07<0 | bpo_serv07>2) (5 real changes made, 5 to missing) . . replace bpo_pers_jahr07=. if bpo_pers_jahr07<0 (42 real changes made, 42 to missing) . replace bpo_pers_jahr07=. if (bpo_pers07==0 | bpo_pers07==2) (0 real changes made) . replace bpo_buch_jahr07=. if bpo_buch_jahr07<0 (38 real changes made, 38 to missing) . replace bpo_buch_jahr07=. if (bpo_buch07==0 | bpo_buch07==2) (0 real changes made) . replace bpo_besch_jahr07=. if bpo_besch_jahr07<0 (11 real changes made, 11 to missing) . replace bpo_besch_jahr07=. if (bpo_besch07==0 | bpo_besch07==2) (0 real changes made) . replace bpo_vertr_jahr07=. if bpo_vertr_jahr07<0 (7 real changes made, 7 to missing) . replace bpo_vertr_jahr07=. if (bpo_vertr07==0 | bpo_vertr07==2) (0 real changes made) . replace bpo_mark_jahr07=. if bpo_mark_jahr07<0 (19 real changes made, 19 to missing) . replace bpo_mark_jahr07=. if (bpo_mark07==0 | bpo_mark07==2) (0 real changes made) . replace bpo_serv_jahr07=. if bpo_serv_jahr07<0 (10 real changes made, 10 to missing) . replace bpo_serv_jahr07=. if (bpo_serv07==0 | bpo_serv07==2) (0 real changes made) . . replace zielbpo_kost07=. if (zielbpo_kost07<0 | zielbpo_kost07>3) (35 real changes made, 35 to missing) . replace zielbpo_kost07=. if (bpo_pers07==. & bpo_buch07==. & bpo_besch07==. & bpo_vertr07==. & bpo_mark07==. & bpo_serv07==.) (0 real changes made) . replace zielbpo_proz07=. if (zielbpo_proz07<0 | zielbpo_proz07>3) (19 real changes made, 19 to missing) . replace zielbpo_proz07=. if (bpo_pers07==. & bpo_buch07==. & bpo_besch07==. & bpo_vertr07==. & bpo_mark07==. & bpo_serv07==.) (0 real changes made) . replace zielbpo_kern07=. if (zielbpo_kern07<0 | zielbpo_kern07>3) (10 real changes made, 10 to missing) . replace zielbpo_kern07=. if (bpo_pers07==. & bpo_buch07==. & bpo_besch07==. & bpo_vertr07==. & bpo_mark07==. & bpo_serv07==.) (0 real changes made) . . /* Beratungsdientleistungen 2007 */ . . replace beratung07=. if (beratung07<0 | beratung07>1) (29 real changes made, 29 to missing) . . replace ber_art_it07=. if (ber_art_it07<0 | ber_art_it07>1) (0 real changes made) . replace ber_art_it07=. if beratung07==. (0 real changes made) . replace ber_art_it07=0 if beratung07==0 (1577 real changes made) . . replace ber_art_org07=. if (ber_art_org07<0 | ber_art_org07>1) (0 real changes made) . replace ber_art_org07=. if beratung07==. (0 real changes made) . replace ber_art_org07=0 if beratung07==0 (1577 real changes made) . . replace ber_art_strat07=. if (ber_art_strat07<0 | ber_art_strat07>1) (0 real changes made) . replace ber_art_strat07=. if beratung07==. (0 real changes made) . replace ber_art_strat07=0 if beratung07==0 (1577 real changes made) . . replace ber_art_hr07=. if (ber_art_hr07<0 | ber_art_hr07>1) (0 real changes made) . replace ber_art_hr07=. if beratung07==. (0 real changes made) . replace ber_art_hr07=0 if beratung07==0 (1577 real changes made) . . replace ber_it07=. if (ber_it07<0 | ber_it07>1) (4 real changes made, 4 to missing) . replace ber_it07=. if (ber_art_it07==. & ber_art_org07==. & ber_art_strat07==. & ber_art_hr07==.) (0 real changes made) . replace ber_it07=0 if (ber_art_it07==0 & ber_art_org07==0 & ber_art_strat07==0 & ber_art_hr07==0) (1822 real changes made) . . replace berkost_vh07=. if berkost_vh07<0 (0 real changes made) . replace berkost_vh07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace berkost_vh07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . replace berkost_vh07=berkost_vh07/100 berkost_vh07 was byte now float (1297 real changes made) . replace berkost_abs07=. if berkost_abs07<0 (0 real changes made) . replace berkost_abs07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace berkost_abs07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . replace berkost_vh07=. if (berkost_vh07<0 | berkost_vh07>1) (0 real changes made) . . replace binno_pz07=. if (binno_pz07<0 | binno_pz07>2) (26 real changes made, 26 to missing) . replace binno_pz07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace binno_pz07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . . replace binno_org07=. if (binno_org07<0 | binno_org07>2) (18 real changes made, 18 to missing) . replace binno_org07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace binno_org07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . . replace binno_pd07=. if (binno_pd07<0 | binno_pd07>2) (21 real changes made, 21 to missing) . replace binno_pd07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace binno_pd07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . . replace binno_strat07=. if (binno_strat07<0 | binno_strat07>2) (21 real changes made, 21 to missing) . replace binno_strat07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace binno_strat07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . . /* Interaktion IT-Beratung und IT-Weiterbildung 2007 */ . . gen ber_weiter_07=ber_art_it07*it_weiter_vh07 (233 missing values generated) . . /* entweder Beratung oder Weiterbildung in IT 2007 */ . . gen ber_weiter_07_2=. (4434 missing values generated) . replace ber_weiter_07_2=1 if (ber_art_it07==1 | it_weiter_vh07>0) (3140 real changes made) . replace ber_weiter_07_2=1 if (ber_art_it07==0 & it_weiter_vh07<0.0000000001) (1284 real changes made) . . /* nicht vorgesehene Beratungsdienstleistungen */ . . replace ber_neunotw07=. if (ber_neunotw07<0 | ber_neunotw07>1) (46 real changes made, 46 to missing) . replace ber_neunotw07=. if (ber_it07==. & ber_art_it07==.) (0 real changes made) . replace ber_neunotw07=0 if (ber_it07==0 & ber_art_it07==0) (2407 real changes made) . . /* log. IT-Weiterbildung 2007 */ . . gen lit_weiter_vh07=ln(it_weiter_vh07) (1949 missing values generated) . . /* IT-Weiterbildung 2007 als Dummy */ . . gen dit_weiter_vh07=. (4434 missing values generated) . replace dit_weiter_vh07=1 if it_weiter_vh07>0 (2697 real changes made) . replace dit_weiter_vh07=0 if it_weiter_vh07<0.00000000000001 (1737 real changes made) . . /* Umsatz 2006 */ . . replace ums06=. if ums06<0 (0 real changes made) . . /* Produktinnovationen 2007 */ . . replace pd07=. if (pd07<0 | pd07>1) (25 real changes made, 25 to missing) . replace pdanz07=. if (pdanz07<0 | pd07==.) (368 real changes made, 368 to missing) . replace pdanz07=0 if pd07==0 (1893 real changes made) . . replace pd_ums_vh07=. if (pd_ums_vh07<0 | pd07==.) (532 real changes made, 532 to missing) . replace pd_ums_vh07=0 if (pd07==0 | pdanz07==0) (1893 real changes made) . . replace pd_ums_abs07=. if (pd_ums_abs07<0 | pd07==.) (0 real changes made) . replace pd_ums_abs07=0 if (pd07==0 | pdanz07==0) (1893 real changes made) . . replace pd_ums_vh07=(pd_ums_abs07/ums06) if pd_ums_vh07==. pd_ums_vh07 was int now float (41 real changes made) . replace pd_ums_vh07=pd_ums_vh07/100 (1964 real changes made) . replace pd_ums_vh07=. if (pd_ums_vh07<0 | pd_ums_vh07>1) (19 real changes made, 19 to missing) . . /* Prozessinnovationen 2007 */ . . replace pz07=. if (pz07<0 | pz07>1) (30 real changes made, 30 to missing) . replace pzanz07=. if (pzanz07<0 | pz07==.) (419 real changes made, 419 to missing) . replace pzanz07=0 if pz07==0 (1556 real changes made) . . replace pz_kost_vh07=. if (pz_kost_vh07<0 | pz07==.) (869 real changes made, 869 to missing) . replace pz_kost_vh07=0 if (pz07==0 | pzanz07==0) (1557 real changes made) . replace pz_kost_vh07=pz_kost_vh07/100 pz_kost_vh07 was int now float (1695 real changes made) . replace pz_kost_vh07=. if (pz_kost_vh07<0 | pz_kost_vh07>1) (0 real changes made) . . /* Innovation allgemein 2007 */ . . gen inno07=. (4434 missing values generated) . replace inno07=1 if (pd07==1 | pz07==1) (3518 real changes made) . replace inno07=0 if (pd07==0 & pz07==0) (896 real changes made) . . /* Anteil Forschungs- und Entwicklungsaufwendungen am Umsatz 2007 */ . . replace fue_vh07=. if fue_vh<0 (717 real changes made, 717 to missing) . replace fue_abs07=. if fue_abs07<0 (0 real changes made) . . replace fue_vh07=(fue_abs07/ums06) if fue_vh07==. fue_vh07 was int now float (518 real changes made) . replace fue_vh07=fue_vh07/100 (2347 real changes made) . replace fue_vh07=. if (fue_vh07<0 | fue_vh07>1) (74 real changes made, 74 to missing) . . replace fue_bges07=. if fue_bges07<0 (177 real changes made, 177 to missing) . replace fue_bges07=. if (fue_vh07==. & fue_abs07==.) (566 real changes made, 566 to missing) . replace fue_bges07=0 if (fue_vh07==0 & fue_abs07==0) (0 real changes made) . . /* Betriebsrat oder Personalrat 2007 */ . . replace rat07=. if (rat07<0 | rat07>1) (16 real changes made, 16 to missing) . . /* Tarifvertrag 2007 */ . . replace tarif07=0. if (tarif07<0 | tarif07>1) (63 real changes made) . . /* Wechsel in der Geschäftsleitung 2007 */ . . replace wechselgf07=. if (wechselgf07<0 | wechselgf07>1) (12 real changes made, 12 to missing) . . /* erwarteter Umsatz für 2007 */ . . replace e_ums07=. if (e_ums07<0 | e_ums07>2) (100 real changes made, 100 to missing) . . replace e_ums_vh07=. if e_ums_vh07<0 (169 real changes made, 169 to missing) . replace e_ums_vh07=. if e_ums07==. (0 real changes made) . replace e_ums_vh07=0 if e_ums07==1 (1671 real changes made) . . /* Geschäftslage 2007*/ . . replace lage07=. if (lage07<0 | lage07>3) (60 real changes made, 60 to missing) . . /* Bruttoinvestitionen 2007 */ . . replace binv_abs07=. if binv_abs07<0 (0 real changes made) . . gen lbinv_abs07=ln(binv_abs07) (1668 missing values generated) . . replace lbinv_abs07=0.00001 if binv_abs07==0 (231 real changes made) . . /* Bruttoinvestitionen per Arbeit */ . . gen binv07em=binv_abs07/bges06 (1450 missing values generated) . . gen lbinv07em=ln(binv07em) (1677 missing values generated) . replace lbinv07em=0.00001 if binv07em==0 (227 real changes made) . . /* log. Beschäftigte 2007 */ . . gen lbges06=ln(bges06) (41 missing values generated) . . /* Arbeitsproduktivität in Mio. */ . . gen lp07=ums06/bges06 (1226 missing values generated) . gen llp07=ln(lp07) (1232 missing values generated) . . /* Anteil Personalkosten am Umsatz 2007 */ . . replace pkost_vh07=. if pkost_vh07<0 (1113 real changes made, 1113 to missing) . replace pkost_vh07=pkost_vh07/100 pkost_vh07 was int now float (3312 real changes made) . replace pkost_vh07=. if (pkost_vh07<0 | pkost_vh07>1) (0 real changes made) . . /* Anteil Materialaufwand und Vorleistungen am Umsatz 2007 */ . . replace mkost_vh07=. if mkost_vh07<0 (1073 real changes made, 1073 to missing) . replace mkost_vh07=mkost_vh07/100 mkost_vh07 was int now float (3285 real changes made) . replace mkost_vh07=. if (mkost_vh07<0 | mkost_vh07>1) (0 real changes made) . . /* Exporte 2007 */ . . replace exp07=. if (exp07<0 | exp07>1) (17 real changes made, 17 to missing) . . replace exp_vh07=. if exp_vh07<0 (206 real changes made, 206 to missing) . replace exp_vh07=. if exp07==. (0 real changes made) . replace exp_vh07=0 if exp07==0 (2293 real changes made) . replace exp_vh07=exp_vh07/100 exp_vh07 was int now float (1913 real changes made) . replace exp_vh07=. if (exp_vh07<0 | exp_vh07>1) (0 real changes made) . . /* Importe 2007 */ . . replace imp07=. if (imp07<0 | imp07>1) (35 real changes made, 35 to missing) . . replace imp_vh07=. if imp_vh07<0 (296 real changes made, 296 to missing) . replace imp_vh07=. if imp07==. (0 real changes made) . replace imp_vh07=0 if imp07==0 (2567 real changes made) . replace imp_vh07=imp_vh07/100 imp_vh07 was int now float (1530 real changes made) . replace imp_vh07=. if (imp_vh07<0 | imp_vh07>1) (0 real changes made) . . /* Auslandsaktivität allgemein (Export und Import) 2007 */ . . gen ausland07=. (4434 missing values generated) . replace ausland07=1 if (exp07==1 | imp07==1) (2571 real changes made) . replace ausland07=0 if (exp07==0 | imp07==0) (3021 real changes made) . . /* Homepage 2007 */ . . replace homepage_adr07=. if (homepage_adr07<0 | homepage_adr07>1) (41 real changes made, 41 to missing) . . *Branchendummies 2007 generieren* . . gen id1_07=1 if branche07==1 (4133 missing values generated) . replace id1_07=0 if (branche07!=1 & branche07!=.) (4133 real changes made) . gen id2_07=1 if branche07==2 (4226 missing values generated) . replace id2_07=0 if (branche07!=2 & branche07!=.) (4226 real changes made) . gen id3_07=1 if branche07==3 (4050 missing values generated) . replace id3_07=0 if (branche07!=3 & branche07!=.) (4050 real changes made) . gen id4_07=1 if branche07==4 (3991 missing values generated) . replace id4_07=0 if (branche07!=4 & branche07!=.) (3991 real changes made) . gen id5_07=1 if branche07==5 (4096 missing values generated) . replace id5_07=0 if (branche07!=5 & branche07!=.) (4096 real changes made) . gen id6_07=1 if branche07==6 (4114 missing values generated) . replace id6_07=0 if (branche07!=6 & branche07!=.) (4114 real changes made) . gen id7_07=1 if branche07==7 (4213 missing values generated) . replace id7_07=0 if (branche07!=7 & branche07!=.) (4213 real changes made) . gen id8_07=1 if branche07==8 (4207 missing values generated) . replace id8_07=0 if (branche07!=8 & branche07!=.) (4207 real changes made) . gen id9_07=1 if branche07==9 (4097 missing values generated) . replace id9_07=0 if (branche07!=9 & branche07!=.) (4097 real changes made) . gen id10_07=1 if branche07==10 (4081 missing values generated) . replace id10_07=0 if (branche07!=10 & branche07!=.) (4081 real changes made) . gen id11_07=1 if branche07==11 (4159 missing values generated) . replace id11_07=0 if (branche07!=11 & branche07!=.) (4159 real changes made) . gen id12_07=1 if branche07==12 (4135 missing values generated) . replace id12_07=0 if (branche07!=12 & branche07!=.) (4135 real changes made) . gen id13_07=1 if branche07==13 (4141 missing values generated) . replace id13_07=0 if (branche07!=13 & branche07!=.) (4141 real changes made) . gen id14_07=1 if branche07==14 (4121 missing values generated) . replace id14_07=0 if (branche07!=14 & branche07!=.) (4121 real changes made) . drop if branche==0 (122 observations deleted) . . /* Ostdummy 2007 */ . . replace ost07=. if (ost07<0 | ost07>1) (0 real changes made) . . sort lfdnr . . save "H:\Produktivität_SOCSOF\Daten_2007", replace file H:\Produktivität_SOCSOF\Daten_2007.dta saved . . ******************************************************* . * Wellen mergen * . ******************************************************* . . use "H:\Produktivität_SOCSOF\Daten_2007", clear . . merge lfdnr using "H:\Produktivität_SOCSOF\Daten_2010", unique (note: you are using old merge syntax; see [D] merge for new syntax) (label lb_internet_nutz already defined) (label lb_quali_start already defined) (label lb_angaben already defined) (label lb_neinja already defined) (label lb_branche already defined) . . keep if _merge==3 (4909 observations deleted) . . . . /*Interaktionsterme */ . . gen int1=socsof1*exp_vh07 (103 missing values generated) . . gen int2=socsof2*b2b07 (25 missing values generated) . . gen int3=socsof2*b2c07 (24 missing values generated) . . /* Interaktion Social Software und junge Arbeitnehmer */ . . gen socsof2jung=socsof2*bu3007 (112 missing values generated) . . /* Produktivitätsveränderung über die Zeit */ . . gen diff=llp-llp07 (617 missing values generated) . . sort lfdnr . . log close . exit