cap log close set varabbrev on local date: di %d date(c(current_date),"DMY") log using "log/LPP_descriptives_`date.log'.log", replace ********************* *** Establishments *** ********************* replace bbeurt_fk=bbeurt_fk1 if jahr==2016 replace bvargehalt_pers=0 if bvargehalt_pers==2 & jahr==2016 recode bvargehalt_pers (0=1 "auch MA") (1=2 "nur FK"), gen(bvar_pers) replace bvar_pers=0 if bvargehalt==0 replace bbeurt_ma=0 if bbeurt==0 & (bbeurt_ma==. | bbeurt_ma1==.) replace bbeurt_fk=0 if bbeurt==0 & (bbeurt_fk==. | bbeurt_fk1==.) replace bmagespr_ma=0 if bmagespr==0 & (bmagespr_ma==. | bmagespr_ma1==.) replace bmagespr_fk=0 if bmagespr==0 & (bmagespr_fk==. | bmagespr_fk1==.) gen zver=. replace zver=0 if bzv==0 | bzv_schriftl==0 | bzv1==0 replace zver=1 if (bzv==1 & bzv_schriftl==1) | bzv1==1 gen var_fk=. replace var_fk=0 if bvargehalt==0 replace var_fk=1 if bvargehalt==1 gen var_ma=. replace var_ma=0 if bvargehalt==0 | bvar_pers==2 replace var_ma=1 if bvargehalt==1 & bvar_pers==1 gen beurt_fk=. replace beurt_fk=0 if bbeurt==0 | (bbeurt_fk==0 & bbeurt_alle==0) | bbeurt_fk1==0 replace beurt_fk=1 if bbeurt==1 & (bbeurt_fk==1 | bbeurt_alle==1) replace beurt_fk=1 if bbeurt==1 & bbeurt_fk1==1 gen beurt_ma=. replace beurt_ma=0 if bbeurt==0 | (bbeurt_ma==0 & bbeurt_alle==0) | bbeurt_ma1==0 replace beurt_ma=1 if bbeurt==1 & (bbeurt_ma==1 | bbeurt_alle==1) replace beurt_ma=1 if bbeurt==1 & bbeurt_ma1==1 gen mgespr_fk=. replace mgespr_fk=0 if bmagespr==0 | (bmagespr_fk==0) | bmagespr_fk1==0 replace mgespr_fk=1 if bmagespr==1 & (bmagespr_fk==1 | bmagespr_alle==1) replace mgespr_fk=1 if bmagespr==1 & bmagespr_fk1==1 gen mgespr_ma=. replace mgespr_ma=0 if bmagespr==0 | (bmagespr_ma==0 & bmagespr_alle==0) | bmagespr_ma1==0 replace mgespr_ma=1 if bmagespr==1 & (bmagespr_ma==1 | bmagespr_alle==1) replace mgespr_ma=1 if bmagespr==1 & bmagespr_ma1==1 *********************** * Descriptives Table 2 * *********************** * Distribution of HR measures: table jahr [aw=hrf], c(mean bvargehalt mean bbeurt mean bmagespr mean zver) table jahr [aw=hrf], c(N bvargehalt N bbeurt N bmagespr N zver) table jahr [aw=hrf], c(mean var_fk mean var_ma) table jahr [aw=hrf], c(mean beurt_fk mean beurt_ma) table jahr [aw=hrf], c(mean mgespr_fk mean mgespr_ma) table jahr [aw=hrf], c(mean bmabefr mean zver mean bentwplan) table jahr [aw=hrf], c(mean bpersplan mean bwbabschluss mean bffk) table jahr [aw=hrf], c(N var_fk N var_ma) *______________________________________________________________________________* ********************** * Individuals * ********************** drop if iab_id==. replace mgesund_prestage=0 if mgesund_prestage==996 replace mgesund_prestage=. if inlist(mgesund_prestage,997,998) ************************* * Descriptives Figure 3: ************************* * Sick days and HRM: table msonderz [aw=mweight_quer] if jahr==2016, c(mean mgesund_kranktage) table mheim [aw=mweight_quer] if jahr==2016, c(mean mgesund_kranktage) table mmagespr [aw=mweight_quer] if jahr==2016, c(mean mgesund_kranktage) table mwb [aw=mweight_quer] if jahr==2016, c(mean mgesund_kranktage) * Presentismus and HRM: table msonderz [aw=mweight_quer] if jahr==2016, c(mean mgesund_prestage) table mheim [aw=mweight_quer] if jahr==2016, c(mean mgesund_prestage) table mmagespr [aw=mweight_quer ] if jahr==2016, c(mean mgesund_prestage) table mwb [aw=mweight_quer] if jahr==2016, c(mean mgesund_prestage) log close