BGP0PDL9 ; IHS/CMI/LAB - print ind ;
 ;;10.0;IHS CLINICAL REPORTING;;JUN 18, 2010
 ;
 ;
I1AGE ;EP
 D S(" ",1,1)
 ;S X="Age specific Diabetes Prevalence" D S(X,1,1) S Y=" " D S(Y,1,1) S X=BGPHD1 D S(X,1,1) S Y=" " D S(Y,1,1)
 I BGPINDT="E",BGPRTYPE=4 Q
 I BGPINDT="W",BGPRTYPE=4 G FEM
 S BGPHD1="TOTAL USER POPULATION",BGPHD2="Total # User Pop"
 S X=" " D S(X,1,1) D H3 S X=" " D S(X,1,1)
 K BGPDAC,BGPDAP,BGPDAB S (C,D)=0 F BGPX="TA","TB","TC","TD","TE","TF","TG","TH" D I1AGE1,I1AGE2
 D I1AGEP
 S BGPHD1="MALE USER POPULATION",BGPHD2="Total # MALE User Pop"
 ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 D H3
 K BGPDAC,BGPDAP,BGPDAB S (D,C)=0 F BGPX="D","E","F","G","H","I","J","K" D I1AGE1,I1AGE2
 D I1AGEP
FEM ;
 S BGPHD1="FEMALE USER POPULATION",BGPHD2="Total # FEMALE User Pop"
 ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 D H3
 K BGPDAC,BGPDAP,BGPDAB S (C,D)=0 F BGPX="L","M","N","O","P","Q","R","S" D I1AGE1,I1AGE2
 D I1AGEP
 Q
I1AGE1 ;
 S C=C+1
 S BGPF="001."_BGPX_".1" S BGPPC=$O(^BGPINDTC("C",BGPF,0))
 S BGPDF=$P(^BGPINDTC(BGPPC,0),U,8)
 S BGPNP=$P(^DD(90377.03,BGPDF,0),U,4),N=$P(BGPNP,";"),P=$P(BGPNP,";",2)
 S $P(BGPDAC(C),U)=$$V^BGP0DP1C(1,BGPRPT,N,P)
 S $P(BGPDAP(C),U)=$$V^BGP0DP1C(2,BGPRPT,N,P)
 S $P(BGPDAB(C),U)=$$V^BGP0DP1C(3,BGPRPT,N,P)
 ;set 2nd piece to numerator and 3rd to %
 S BGPNF=$P(^BGPINDTC(BGPPC,0),U,9)
 S BGPNP=$P(^DD(90377.03,BGPNF,0),U,4),N=$P(BGPNP,";"),P=$P(BGPNP,";",2)
 S $P(BGPDAC(C),U,2)=$$V^BGP0DP1C(1,BGPRPT,N,P),$P(BGPDAC(C),U,3)=$S($P(BGPDAC(C),U,1):($P(BGPDAC(C),U,2)/$P(BGPDAC(C),U)*100),1:"")
 S $P(BGPDAP(C),U,2)=$$V^BGP0DP1C(2,BGPRPT,N,P),$P(BGPDAP(C),U,3)=$S($P(BGPDAP(C),U,1):($P(BGPDAP(C),U,2)/$P(BGPDAP(C),U)*100),1:"")
 S $P(BGPDAB(C),U,2)=$$V^BGP0DP1C(3,BGPRPT,N,P),$P(BGPDAB(C),U,3)=$S($P(BGPDAB(C),U,1):($P(BGPDAB(C),U,2)/$P(BGPDAB(C),U)*100),1:"")
 Q
I1AGE2 ;
 S D=D+1
 S BGPF="001."_BGPX_".2" S BGPPC=$O(^BGPINDTC("C",BGPF,0))
 ;set 4th piece to numerator and 5th to %
 S BGPNF=$P(^BGPINDTC(BGPPC,0),U,9)
 S BGPNP=$P(^DD(90377.03,BGPNF,0),U,4),N=$P(BGPNP,";"),P=$P(BGPNP,";",2)
 S $P(BGPDAC(D),U,4)=$$V^BGP0DP1C(1,BGPRPT,N,P),$P(BGPDAC(D),U,5)=$S($P(BGPDAC(D),U,1):($P(BGPDAC(D),U,4)/$P(BGPDAC(D),U)*100),1:"")
 S $P(BGPDAP(D),U,4)=$$V^BGP0DP1C(2,BGPRPT,N,P),$P(BGPDAP(D),U,5)=$S($P(BGPDAP(D),U,1):($P(BGPDAP(D),U,4)/$P(BGPDAP(D),U)*100),1:"")
 S $P(BGPDAB(D),U,4)=$$V^BGP0DP1C(3,BGPRPT,N,P),$P(BGPDAB(D),U,5)=$S($P(BGPDAB(D),U,1):($P(BGPDAB(D),U,4)/$P(BGPDAB(D),U)*100),1:"")
 Q
I1AGEP ;
 S X=" " D S(X,1,1)
 S X="CURRENT REPORT PERIOD" D S(X,1,1) S X=" " D S(X,1,1)
 S X=BGPHD2 D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAC(X),U) S Y=V D S(Y,,X+1)
 S X="# w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAC(X),U,2) S Y=V D S(Y,,X+1)
 S X="% w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAC(X),U,3) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
 S X=" " D S(X,1,1) S X="# w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAC(X),U,4) S Y=V D S(Y,,X+1)
 S X="% w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAC(X),U,5) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
PR ; 
 ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 S X=" " D S(X,1,1) S X="PREVIOUS YEAR PERIOD" D S(X,1,1)
 S X=" " D S(X,1,1) S X=BGPHD2 D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAP(X),U) S Y=V D S(Y,,X+1)
 S X="# w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAP(X),U,2) S Y=V D S(Y,,X+1)
 S X="% w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAP(X),U,3) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
 S X=" " D S(X,1,1) S X="# w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAP(X),U,4) S Y=V D S(Y,,X+1)
 S X="% w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAP(X),U,5) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
 ;percentage changes
 S X=" " D S(X,1,1) S X="CHANGE FROM PREV YR %" D S(X,1,1)
 S X="w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S N=$P(BGPDAC(X),U,3),O=$P(BGPDAP(X),U,3) S Y=$$SB($J((N-O),6,1)) D S(Y,,X+1)
 S X="w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S N=$P(BGPDAC(X),U,5),O=$P(BGPDAP(X),U,5) S Y=$$SB($J((N-O),6,1)) D S(Y,,X+1)
BL ;
 ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 S X=" " D S(X,1,1) S X="BASELINE REPORT PERIOD" D S(X,1,1)
 S X=" " D S(X,1,1) S X=BGPHD2 D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAB(X),U) S Y=V D S(Y,,X+1)
 S X="# w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAB(X),U,2) S Y=V D S(Y,,X+1)
 S X="% w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAB(X),U,3) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
 S X=" " D S(X,1,1) S X="# w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAB(X),U,4) S Y=V D S(Y,,X+1)
 S X="% w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S V=$P(BGPDAB(X),U,5) S Y=$$SB($J(V,6,1)) D S(Y,,X+1)
 ;percentage changes
 S X=" " D S(X,1,1) S X="CHANGE FROM BASE YR %" D S(X,1,1)
 S X="w/ DM DX ever" D S(X,1,1)
 F X=1:1:8 S N=$P(BGPDAC(X),U,3),O=$P(BGPDAB(X),U,3) S Y=$$SB($J((N-O),6,1)) D S(Y,,X+1)
 S X="w/DM DX in past yr" D S(X,1,1)
 F X=1:1:8 S N=$P(BGPDAC(X),U,5),O=$P(BGPDAB(X),U,5) S Y=$$SB($J((N-O),6,1)) D S(Y,,X+1)
 Q
SETN ;set numerator fields
 S BGPCYN=$$V^BGP0DP1C(1,BGPRPT,N,P)
 S BGPPRN=$$V^BGP0DP1C(2,BGPRPT,N,P)
 S BGPBLN=$$V^BGP0DP1C(3,BGPRPT,N,P)
 S BGPCYP=$S(BGPCYD:((BGPCYN/BGPCYD)*100),1:"")
 S BGPPRP=$S(BGPPRD:((BGPPRN/BGPPRD)*100),1:"")
 S BGPBLP=$S(BGPBLD:((BGPBLN/BGPBLD)*100),1:"")
 Q
V(T,R,N,P) ;EP
 I $G(BGPAREAA) G VA
 NEW X
 I T=1 S X=$P($G(^BGPGPDCT(R,N)),U,P) Q $S(X]"":X,1:0)
 I T=2 S X=$P($G(^BGPGPDPT(R,N)),U,P) Q $S(X]"":X,1:0)
 I T=3 S X=$P($G(^BGPGPDBT(R,N)),U,P) Q $S(X]"":X,1:0)
 Q ""
VA ;
 NEW X,V,C S X=0,C="" F  S X=$O(BGPSUL(X)) Q:X'=+X  D
 .I T=1 S C=C+$P($G(^BGPGPDCT(X,N)),U,P)
 .I T=2 S C=C+$P($G(^BGPGPDPT(X,N)),U,P)
 .I T=3 S C=C+$P($G(^BGPGPDBT(X,N)),U,P)
 .Q
 Q $S(C:C,1:0)
C(X,X2,X3) ;
 D COMMA^%DTC
 Q X
S(Y,F,P) ;set up array
 I '$G(F) S F=0
 S %=$P(^TMP($J,"BGPDEL",0),U)+F,$P(^TMP($J,"BGPDEL",0),U)=%
 I '$D(^TMP($J,"BGPDEL",%)) S ^TMP($J,"BGPDEL",%)=""
 S $P(^TMP($J,"BGPDEL",%),U,P)=Y
 Q
CALC(N,O) ;
 NEW Z
 S Z=N-O,Z=$FN(Z,"+,",1)
 Q Z
H3 ;EP
 ;;S X="Age specific Diabetes Prevalence" D S(X,1,1) S Y=" " D S(Y,1,1) S X=BGPHD1 D S(X,1,1) S Y=" " D S(Y,1,1)
 S X="Age Distribution" D S(X,1,1) S X=" " D S(X,1,1)
 S Y="<15" D S(Y,1,2)
 S Y="15-19" D S(Y,,3)
 S Y="20-24" D S(Y,,4)
 S Y="25-34" D S(Y,,5)
 S Y="35-44" D S(Y,,6)
 S Y="45-54" D S(Y,,7)
 S Y="55-64" D S(Y,,8)
 S Y=">64 yrs" D S(Y,,9)
 Q
SB(X) ;EP - Strip leading and trailing blanks from X.
 X ^DD("FUNC",$O(^DD("FUNC","B","STRIPBLANKS",0)),1)
 Q X
H2 ;
 S BGPX="",BGPX=BGPCYN,$P(BGPX,U,2)=$$SB($J(BGPCYP,5,1)),$P(BGPX,U,3)=BGPPRN,$P(BGPX,U,4)=$$SB($J(BGPPRP,5,1)),$P(BGPX,U,5)=$$SB($J($$CALC(BGPCYP,BGPPRP),6)),$P(BGPX,U,6)=BGPBLN,$P(BGPX,U,7)=$$SB($J(BGPBLP,5,1))
 S $P(BGPX,U,8)=$$SB($J($$CALC(BGPCYP,BGPBLP),6))
 D S(BGPX,,2)
 Q
H1 ;EP
 S Y="REPORT" D S(Y,1,2)
 S Y="%" D S(Y,,3)
 S Y="PREV YR" D S(Y,,4)
 S Y="%" D S(Y,,5)
 S Y="CHG from" D S(Y,,6)
 S Y="BASE" D S(Y,,7)
 S Y="%" D S(Y,,8)
 S Y="CHG from" D S(Y,,9)
 S Y="PERIOD" D S(Y,1,2)
 S Y="PERIOD" D S(Y,,4)
 S Y="PREV YR %" D S(Y,,6)
 S Y="PERIOD" D S(Y,,7)
 S Y="BASE %" D S(Y,,9)
 Q
BGP0PDL9  ; IHS/CMI/LAB - print ind ;
 +1       ;;10.0;IHS CLINICAL REPORTING;;JUN 18, 2010
 +2       ;
 +3       ;
I1AGE     ;EP
 +1        DO S(" ",1,1)
 +2       ;S X="Age specific Diabetes Prevalence" D S(X,1,1) S Y=" " D S(Y,1,1) S X=BGPHD1 D S(X,1,1) S Y=" " D S(Y,1,1)
 +3        IF BGPINDT="E"
               IF BGPRTYPE=4
                   QUIT 
 +4        IF BGPINDT="W"
               IF BGPRTYPE=4
                   GOTO FEM
 +5        SET BGPHD1="TOTAL USER POPULATION"
           SET BGPHD2="Total # User Pop"
 +6        SET X=" "
           DO S(X,1,1)
           DO H3
           SET X=" "
           DO S(X,1,1)
 +7        KILL BGPDAC,BGPDAP,BGPDAB
           SET (C,D)=0
           FOR BGPX="TA","TB","TC","TD","TE","TF","TG","TH"
               DO I1AGE1
               DO I1AGE2
 +8        DO I1AGEP
 +9        SET BGPHD1="MALE USER POPULATION"
           SET BGPHD2="Total # MALE User Pop"
 +10      ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 +11       DO H3
 +12       KILL BGPDAC,BGPDAP,BGPDAB
           SET (D,C)=0
           FOR BGPX="D","E","F","G","H","I","J","K"
               DO I1AGE1
               DO I1AGE2
 +13       DO I1AGEP
FEM       ;
 +1        SET BGPHD1="FEMALE USER POPULATION"
           SET BGPHD2="Total # FEMALE User Pop"
 +2       ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 +3        DO H3
 +4        KILL BGPDAC,BGPDAP,BGPDAB
           SET (C,D)=0
           FOR BGPX="L","M","N","O","P","Q","R","S"
               DO I1AGE1
               DO I1AGE2
 +5        DO I1AGEP
 +6        QUIT 
I1AGE1    ;
 +1        SET C=C+1
 +2        SET BGPF="001."_BGPX_".1"
           SET BGPPC=$ORDER(^BGPINDTC("C",BGPF,0))
 +3        SET BGPDF=$PIECE(^BGPINDTC(BGPPC,0),U,8)
 +4        SET BGPNP=$PIECE(^DD(90377.03,BGPDF,0),U,4)
           SET N=$PIECE(BGPNP,";")
           SET P=$PIECE(BGPNP,";",2)
 +5        SET $PIECE(BGPDAC(C),U)=$$V^BGP0DP1C(1,BGPRPT,N,P)
 +6        SET $PIECE(BGPDAP(C),U)=$$V^BGP0DP1C(2,BGPRPT,N,P)
 +7        SET $PIECE(BGPDAB(C),U)=$$V^BGP0DP1C(3,BGPRPT,N,P)
 +8       ;set 2nd piece to numerator and 3rd to %
 +9        SET BGPNF=$PIECE(^BGPINDTC(BGPPC,0),U,9)
 +10       SET BGPNP=$PIECE(^DD(90377.03,BGPNF,0),U,4)
           SET N=$PIECE(BGPNP,";")
           SET P=$PIECE(BGPNP,";",2)
 +11       SET $PIECE(BGPDAC(C),U,2)=$$V^BGP0DP1C(1,BGPRPT,N,P)
           SET $PIECE(BGPDAC(C),U,3)=$SELECT($PIECE(BGPDAC(C),U,1):($PIECE(BGPDAC(C),U,2)/$PIECE(BGPDAC(C),U)*100),1:"")
 +12       SET $PIECE(BGPDAP(C),U,2)=$$V^BGP0DP1C(2,BGPRPT,N,P)
           SET $PIECE(BGPDAP(C),U,3)=$SELECT($PIECE(BGPDAP(C),U,1):($PIECE(BGPDAP(C),U,2)/$PIECE(BGPDAP(C),U)*100),1:"")
 +13       SET $PIECE(BGPDAB(C),U,2)=$$V^BGP0DP1C(3,BGPRPT,N,P)
           SET $PIECE(BGPDAB(C),U,3)=$SELECT($PIECE(BGPDAB(C),U,1):($PIECE(BGPDAB(C),U,2)/$PIECE(BGPDAB(C),U)*100),1:"")
 +14       QUIT 
I1AGE2    ;
 +1        SET D=D+1
 +2        SET BGPF="001."_BGPX_".2"
           SET BGPPC=$ORDER(^BGPINDTC("C",BGPF,0))
 +3       ;set 4th piece to numerator and 5th to %
 +4        SET BGPNF=$PIECE(^BGPINDTC(BGPPC,0),U,9)
 +5        SET BGPNP=$PIECE(^DD(90377.03,BGPNF,0),U,4)
           SET N=$PIECE(BGPNP,";")
           SET P=$PIECE(BGPNP,";",2)
 +6        SET $PIECE(BGPDAC(D),U,4)=$$V^BGP0DP1C(1,BGPRPT,N,P)
           SET $PIECE(BGPDAC(D),U,5)=$SELECT($PIECE(BGPDAC(D),U,1):($PIECE(BGPDAC(D),U,4)/$PIECE(BGPDAC(D),U)*100),1:"")
 +7        SET $PIECE(BGPDAP(D),U,4)=$$V^BGP0DP1C(2,BGPRPT,N,P)
           SET $PIECE(BGPDAP(D),U,5)=$SELECT($PIECE(BGPDAP(D),U,1):($PIECE(BGPDAP(D),U,4)/$PIECE(BGPDAP(D),U)*100),1:"")
 +8        SET $PIECE(BGPDAB(D),U,4)=$$V^BGP0DP1C(3,BGPRPT,N,P)
           SET $PIECE(BGPDAB(D),U,5)=$SELECT($PIECE(BGPDAB(D),U,1):($PIECE(BGPDAB(D),U,4)/$PIECE(BGPDAB(D),U)*100),1:"")
 +9        QUIT 
I1AGEP    ;
 +1        SET X=" "
           DO S(X,1,1)
 +2        SET X="CURRENT REPORT PERIOD"
           DO S(X,1,1)
           SET X=" "
           DO S(X,1,1)
 +3        SET X=BGPHD2
           DO S(X,1,1)
 +4        FOR X=1:1:8
               SET V=$PIECE(BGPDAC(X),U)
               SET Y=V
               DO S(Y,,X+1)
 +5        SET X="# w/ DM DX ever"
           DO S(X,1,1)
 +6        FOR X=1:1:8
               SET V=$PIECE(BGPDAC(X),U,2)
               SET Y=V
               DO S(Y,,X+1)
 +7        SET X="% w/ DM DX ever"
           DO S(X,1,1)
 +8        FOR X=1:1:8
               SET V=$PIECE(BGPDAC(X),U,3)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
 +9        SET X=" "
           DO S(X,1,1)
           SET X="# w/DM DX in past yr"
           DO S(X,1,1)
 +10       FOR X=1:1:8
               SET V=$PIECE(BGPDAC(X),U,4)
               SET Y=V
               DO S(Y,,X+1)
 +11       SET X="% w/DM DX in past yr"
           DO S(X,1,1)
 +12       FOR X=1:1:8
               SET V=$PIECE(BGPDAC(X),U,5)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
PR        ; 
 +1       ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 +2        SET X=" "
           DO S(X,1,1)
           SET X="PREVIOUS YEAR PERIOD"
           DO S(X,1,1)
 +3        SET X=" "
           DO S(X,1,1)
           SET X=BGPHD2
           DO S(X,1,1)
 +4        FOR X=1:1:8
               SET V=$PIECE(BGPDAP(X),U)
               SET Y=V
               DO S(Y,,X+1)
 +5        SET X="# w/ DM DX ever"
           DO S(X,1,1)
 +6        FOR X=1:1:8
               SET V=$PIECE(BGPDAP(X),U,2)
               SET Y=V
               DO S(Y,,X+1)
 +7        SET X="% w/ DM DX ever"
           DO S(X,1,1)
 +8        FOR X=1:1:8
               SET V=$PIECE(BGPDAP(X),U,3)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
 +9        SET X=" "
           DO S(X,1,1)
           SET X="# w/DM DX in past yr"
           DO S(X,1,1)
 +10       FOR X=1:1:8
               SET V=$PIECE(BGPDAP(X),U,4)
               SET Y=V
               DO S(Y,,X+1)
 +11       SET X="% w/DM DX in past yr"
           DO S(X,1,1)
 +12       FOR X=1:1:8
               SET V=$PIECE(BGPDAP(X),U,5)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
 +13      ;percentage changes
 +14       SET X=" "
           DO S(X,1,1)
           SET X="CHANGE FROM PREV YR %"
           DO S(X,1,1)
 +15       SET X="w/ DM DX ever"
           DO S(X,1,1)
 +16       FOR X=1:1:8
               SET N=$PIECE(BGPDAC(X),U,3)
               SET O=$PIECE(BGPDAP(X),U,3)
               SET Y=$$SB($JUSTIFY((N-O),6,1))
               DO S(Y,,X+1)
 +17       SET X="w/DM DX in past yr"
           DO S(X,1,1)
 +18       FOR X=1:1:8
               SET N=$PIECE(BGPDAC(X),U,5)
               SET O=$PIECE(BGPDAP(X),U,5)
               SET Y=$$SB($JUSTIFY((N-O),6,1))
               DO S(Y,,X+1)
BL        ;
 +1       ;S X=^BGPINDT(BGPIC,53,1,0) D S(X,1,1) D H3
 +2        SET X=" "
           DO S(X,1,1)
           SET X="BASELINE REPORT PERIOD"
           DO S(X,1,1)
 +3        SET X=" "
           DO S(X,1,1)
           SET X=BGPHD2
           DO S(X,1,1)
 +4        FOR X=1:1:8
               SET V=$PIECE(BGPDAB(X),U)
               SET Y=V
               DO S(Y,,X+1)
 +5        SET X="# w/ DM DX ever"
           DO S(X,1,1)
 +6        FOR X=1:1:8
               SET V=$PIECE(BGPDAB(X),U,2)
               SET Y=V
               DO S(Y,,X+1)
 +7        SET X="% w/ DM DX ever"
           DO S(X,1,1)
 +8        FOR X=1:1:8
               SET V=$PIECE(BGPDAB(X),U,3)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
 +9        SET X=" "
           DO S(X,1,1)
           SET X="# w/DM DX in past yr"
           DO S(X,1,1)
 +10       FOR X=1:1:8
               SET V=$PIECE(BGPDAB(X),U,4)
               SET Y=V
               DO S(Y,,X+1)
 +11       SET X="% w/DM DX in past yr"
           DO S(X,1,1)
 +12       FOR X=1:1:8
               SET V=$PIECE(BGPDAB(X),U,5)
               SET Y=$$SB($JUSTIFY(V,6,1))
               DO S(Y,,X+1)
 +13      ;percentage changes
 +14       SET X=" "
           DO S(X,1,1)
           SET X="CHANGE FROM BASE YR %"
           DO S(X,1,1)
 +15       SET X="w/ DM DX ever"
           DO S(X,1,1)
 +16       FOR X=1:1:8
               SET N=$PIECE(BGPDAC(X),U,3)
               SET O=$PIECE(BGPDAB(X),U,3)
               SET Y=$$SB($JUSTIFY((N-O),6,1))
               DO S(Y,,X+1)
 +17       SET X="w/DM DX in past yr"
           DO S(X,1,1)
 +18       FOR X=1:1:8
               SET N=$PIECE(BGPDAC(X),U,5)
               SET O=$PIECE(BGPDAB(X),U,5)
               SET Y=$$SB($JUSTIFY((N-O),6,1))
               DO S(Y,,X+1)
 +19       QUIT 
SETN      ;set numerator fields
 +1        SET BGPCYN=$$V^BGP0DP1C(1,BGPRPT,N,P)
 +2        SET BGPPRN=$$V^BGP0DP1C(2,BGPRPT,N,P)
 +3        SET BGPBLN=$$V^BGP0DP1C(3,BGPRPT,N,P)
 +4        SET BGPCYP=$SELECT(BGPCYD:((BGPCYN/BGPCYD)*100),1:"")
 +5        SET BGPPRP=$SELECT(BGPPRD:((BGPPRN/BGPPRD)*100),1:"")
 +6        SET BGPBLP=$SELECT(BGPBLD:((BGPBLN/BGPBLD)*100),1:"")
 +7        QUIT 
V(T,R,N,P) ;EP
 +1        IF $GET(BGPAREAA)
               GOTO VA
 +2        NEW X
 +3        IF T=1
               SET X=$PIECE($GET(^BGPGPDCT(R,N)),U,P)
               QUIT $SELECT(X]"":X,1:0)
 +4        IF T=2
               SET X=$PIECE($GET(^BGPGPDPT(R,N)),U,P)
               QUIT $SELECT(X]"":X,1:0)
 +5        IF T=3
               SET X=$PIECE($GET(^BGPGPDBT(R,N)),U,P)
               QUIT $SELECT(X]"":X,1:0)
 +6        QUIT ""
VA        ;
 +1        NEW X,V,C
           SET X=0
           SET C=""
           FOR 
               SET X=$ORDER(BGPSUL(X))
               IF X'=+X
                   QUIT 
               Begin DoDot:1
 +2                IF T=1
                       SET C=C+$PIECE($GET(^BGPGPDCT(X,N)),U,P)
 +3                IF T=2
                       SET C=C+$PIECE($GET(^BGPGPDPT(X,N)),U,P)
 +4                IF T=3
                       SET C=C+$PIECE($GET(^BGPGPDBT(X,N)),U,P)
 +5                QUIT 
               End DoDot:1
 +6        QUIT $SELECT(C:C,1:0)
C(X,X2,X3) ;
 +1        DO COMMA^%DTC
 +2        QUIT X
S(Y,F,P)  ;set up array
 +1        IF '$GET(F)
               SET F=0
 +2        SET %=$PIECE(^TMP($JOB,"BGPDEL",0),U)+F
           SET $PIECE(^TMP($JOB,"BGPDEL",0),U)=%
 +3        IF '$DATA(^TMP($JOB,"BGPDEL",%))
               SET ^TMP($JOB,"BGPDEL",%)=""
 +4        SET $PIECE(^TMP($JOB,"BGPDEL",%),U,P)=Y
 +5        QUIT 
CALC(N,O) ;
 +1        NEW Z
 +2        SET Z=N-O
           SET Z=$FNUMBER(Z,"+,",1)
 +3        QUIT Z
H3        ;EP
 +1       ;;S X="Age specific Diabetes Prevalence" D S(X,1,1) S Y=" " D S(Y,1,1) S X=BGPHD1 D S(X,1,1) S Y=" " D S(Y,1,1)
 +2        SET X="Age Distribution"
           DO S(X,1,1)
           SET X=" "
           DO S(X,1,1)
 +3        SET Y="<15"
           DO S(Y,1,2)
 +4        SET Y="15-19"
           DO S(Y,,3)
 +5        SET Y="20-24"
           DO S(Y,,4)
 +6        SET Y="25-34"
           DO S(Y,,5)
 +7        SET Y="35-44"
           DO S(Y,,6)
 +8        SET Y="45-54"
           DO S(Y,,7)
 +9        SET Y="55-64"
           DO S(Y,,8)
 +10       SET Y=">64 yrs"
           DO S(Y,,9)
 +11       QUIT 
SB(X)     ;EP - Strip leading and trailing blanks from X.
 +1        XECUTE ^DD("FUNC",$ORDER(^DD("FUNC","B","STRIPBLANKS",0)),1)
 +2        QUIT X
H2        ;
 +1        SET BGPX=""
           SET BGPX=BGPCYN
           SET $PIECE(BGPX,U,2)=$$SB($JUSTIFY(BGPCYP,5,1))
           SET $PIECE(BGPX,U,3)=BGPPRN
           SET $PIECE(BGPX,U,4)=$$SB($JUSTIFY(BGPPRP,5,1))
           SET $PIECE(BGPX,U,5)=$$SB($JUSTIFY($$CALC(BGPCYP,BGPPRP),6))
           SET $PIECE(BGPX,U,6)=BGPBLN
           SET $PIECE(BGPX,U,7)=$$SB($JUSTIFY(BGPBLP,5,1))
 +2        SET $PIECE(BGPX,U,8)=$$SB($JUSTIFY($$CALC(BGPCYP,BGPBLP),6))
 +3        DO S(BGPX,,2)
 +4        QUIT 
H1        ;EP
 +1        SET Y="REPORT"
           DO S(Y,1,2)
 +2        SET Y="%"
           DO S(Y,,3)
 +3        SET Y="PREV YR"
           DO S(Y,,4)
 +4        SET Y="%"
           DO S(Y,,5)
 +5        SET Y="CHG from"
           DO S(Y,,6)
 +6        SET Y="BASE"
           DO S(Y,,7)
 +7        SET Y="%"
           DO S(Y,,8)
 +8        SET Y="CHG from"
           DO S(Y,,9)
 +9        SET Y="PERIOD"
           DO S(Y,1,2)
 +10       SET Y="PERIOD"
           DO S(Y,,4)
 +11       SET Y="PREV YR %"
           DO S(Y,,6)
 +12       SET Y="PERIOD"
           DO S(Y,,7)
 +13       SET Y="BASE %"
           DO S(Y,,9)
 +14       QUIT