save commands

[Narong Kul]

Can someone show me
how do you use the saved commands that vary by one variable (e.g. facilitykey), see below? Thank you

sum iss if facilitykey==, detail
tab iss_15 if facilitykey==
tab died if facilitykey==
tab died if iss_15==1 & facilitykey==
sum hlos if facilitykey==, detail
sum age if facilitykey==, detail
tab age_65 if facilitykey==
tab gender if facilitykey==
tab penetr if facilitykey==
tab gcs_8 if facilitykey==
tab eddispo if iss_15==1 & facilitykey==
tab level if facilitykey==
tab teachingstatus if facilitykey==
tab bedsize if facilitykey==
tab transfu if facilitykey==
tab hcontrol if facilitykey==
tab hhcontrol if facilitykey==
tab angio if facilitykey==

[Clyde Schechter]

I assume what you want to do is to run each of these commands, separately, for each level of facilitykey. The simplest way to code this would be:

by facility: sum iss, detail
by facility: tab iss_15
by facility: tab died if iss_15==1
by facility: sum hlos, detail
by facility: sum age, detail
by facility: tab age_65
by facility: tab gender
by facility: tab penetr
by facility: tab gcs_8
by facility: tab eddispo if iss_15==1
by facility: tab teachingstatus
by facility: tab bedsize
by facility: tab transfu
by facility: tab hcontrol
by facility: tab hhcontrol
by facility: tab angio

This will run each command separately for each value of facilitykey, and then run the next command for each value of facility key, etc.

If you want the output organized differently, so that all of the commands are run for one value of facilitykey, and then it moves on to run to run them all for the next value of facilitykey, then you could do it this way:

levels of facilitykey, local(facilities)
foreach f of local facilities {
    sum iss if facilitykey==`f', detail
    tab iss_15 if facilitykey==`f'
    tab died if facilitykey==`f'
    tab died if iss_15==1 & facilitykey==`f'
    sum hlos if facilitykey==`f', detail
    sum age if facilitykey==`f', detail
    tab age_65 if facilitykey==`f'
    tab gender if facilitykey==`f'
    tab penetr if facilitykey==`f'
    tab gcs_8 if facilitykey==`f'
    tab eddispo if iss_15==1 & facilitykey==`f'
    tab level if facilitykey==`f'
    tab teachingstatus if facilitykey==`f'
    tab bedsize if facilitykey==`f'
    tab transfu if facilitykey==`f'
    tab hcontrol if facilitykey==`f'
    tab hhcontrol if facilitykey==`f'
    tab angio if facilitykey==`f'
}

By the way, before you do this, you should sort the data on facilitykey.

Finally, instead of getting one dimensional table output for single values of facilitykey, you might consider going up a dimension and making facilitykey part of the output. For example:

tabstat iss, by(facilitykey) statistics(N mean sd min max p05 p10 p25 p50 p75 p90 p95)
tab facilitykey hiss_15
tab facilitykey died
tab facilitykey died if iss_15==1 & facilitykey==
tabstat hlos, by(facilitykey) statistics(N mean sd min max p05 p10 p25 p50 p75 p90 p95)
tabstat age , detail
tab facilitykey age_65
tab facilitykey gender
tab facilitykey penetr
tab facilitykey gcs_8
tab facilitykey eddispo if iss_15==1 & facilitykey==
tab facilitykey level
tab facilitykey teachingstatus
tab facilitykey bedsize
tab facilitykey transfu
tab facilitykey hcontrol
tab facilitykey hhcontrol
tab facilitykey angio