*pbp_b14c_b19b_preventive_vbid_uf.sas;

libname out '.\sas_data_sets\PBP';
options pageno=1 linesize = 200 nocenter;

data pbp_b14c_vbid;

length
	pbp_a_hnumber                    $5
	pbp_a_plan_identifier            $3
	pbp_a_ben_cov                    $1
	pbp_a_plan_type                  $2
	orgtype                          $2
	bid_id                           $13
	pbp_vbid_group_id                $2
	pbp_b14c_bendesc_yn              $1
	pbp_b14c_bendesc_ehc             $255
	pbp_b14c_bendesc_amo_hec         $1
	pbp_b14c_bendesc_amo_ntb         $1
	pbp_b14c_bendesc_lim_ntb         $1
	pbp_b14c_bendesc_dur_ntb         $1
	pbp_b14c_bendesc_amo_sc          $1
	pbp_b14c_bendesc_amo_mhc         $1
	pbp_b14c_bendesc_typ_mhc         $3
	pbp_b14c_bendesc_amo_edm         $1
	pbp_b14c_bendesc_amo_tm          $1
	pbp_b14c_bendesc_amo_rat         $1
	pbp_b14c_rat_bendesc_ehc         $2
	pbp_b14c_bendesc_amo_bsd         $1
	pbp_b14c_bendesc_amo_cs          $1
	pbp_b14c_bendesc_lim_cs          $1
	pbp_b14c_bendesc_dur_cs          $1
	pbp_b14c_bendesc_amo_isa         $1
	pbp_b14c_bendesc_amo_prs         $1
	pbp_b14c_bendesc_amo_mnt         $1
	pbp_b14c_mnt_mcd_yn              $1
	pbp_b14c_mnt_mcd_unit            $1
	pbp_b14c_mnt_nmcd_yn             $1
	pbp_b14c_mnt_nmcd_unit           $1
	pbp_b14c_bendesc_amo_imr         $1
	pbp_b14c_bendesc_amo_rp          $1
	pbp_b14c_rp_bendesc_ehc          $4
	pbp_b14c_rp_bendesc_other        $72
	pbp_b14c_bendesc_amo_wig         $1
	pbp_b14c_bendesc_amo_wm          $1
	pbp_b14c_bendesc_amo_at          $1
	pbp_b14c_bendesc_lim_at          $1
	pbp_b14c_combined_ben            $1
	pbp_b14c_bendesc_thp_msg         $1
	pbp_b14c_bendesc_adcs            $1
	pbp_b14c_bendesc_hbpc            $1
	pbp_b14c_bendesc_ihss            $1
	pbp_b14c_bendesc_sce             $1
	pbp_b14c_maxplan_yn              $1
	pbp_b14c_maxplan_ehc             $255
	pbp_b14c_maxplan_per_hec         $1
	pbp_b14c_maxplan_per_ntb         $1
	pbp_b14c_maxplan_per_sc          $1
	pbp_b14c_maxplan_per_mhc         $1
	pbp_b14c_maxplan_per_edm         $1
	pbp_b14c_maxplan_per_tm          $1
	pbp_b14c_maxplan_per_rat         $1
	pbp_b14c_maxplan_per_bsd         $1
	pbp_b14c_maxplan_per_cs          $1
	pbp_b14c_maxplan_per_isa         $1
	pbp_b14c_maxplan_per_prs         $1
	pbp_b14c_maxplan_per_mnt         $1
	pbp_b14c_maxplan_per_imr         $1
	pbp_b14c_maxplan_per_rp          $1
	pbp_b14c_maxplan_per_wig         $1
	pbp_b14c_maxplan_per_wm          $1
	pbp_b14c_maxplan_per_at          $1
	pbp_b14c_maxplan_per_thms        $1
	pbp_b14c_maxplan_per_adcs        $1
	pbp_b14c_maxplan_per_hbpc        $1
	pbp_b14c_maxplan_per_ihss        $1
	pbp_b14c_maxplan_per_sce         $1
	pbp_b14c_maxenr_yn               $1
	pbp_b14c_maxenr_ehc              $255
	pbp_b14c_maxenr_per_hec          $1
	pbp_b14c_maxenr_per_ntb          $1
	pbp_b14c_maxenr_per_sc           $1
	pbp_b14c_maxenr_per_mhc          $1
	pbp_b14c_maxenr_per_edm          $1
	pbp_b14c_maxenr_per_tm           $1
	pbp_b14c_maxenr_per_rat          $1
	pbp_b14c_maxenr_per_bsd          $1
	pbp_b14c_maxenr_per_cs           $1
	pbp_b14c_maxenr_per_isa          $1
	pbp_b14c_maxenr_per_prs          $1
	pbp_b14c_maxenr_per_mnt          $1
	pbp_b14c_maxenr_per_imr          $1
	pbp_b14c_maxenr_per_rp           $1
	pbp_b14c_maxenr_per_wig          $1
	pbp_b14c_maxenr_per_wm           $1
	pbp_b14c_maxenr_per_at           $1
	pbp_b14c_maxenr_per_thmg         $1
	pbp_b14c_maxenr_per_adcs         $1
	pbp_b14c_maxenr_per_hbpc         $1
	pbp_b14c_maxenr_per_ihss         $1
	pbp_b14c_maxenr_per_sce          $1
	pbp_b14c_coins_yn                $1
	pbp_b14c_coins_ehc               $255
	pbp_b14c_ded_yn                  $1
	pbp_b14c_copay_yn                $1
	pbp_b14c_copay_ehc               $255
	pbp_b14c_auth_yn                 $1
	pbp_b14c_refer_yn                $1
;

infile '.\pbp\pbp_b14c_b19b_preventive_vbid_uf.txt' delimiter = '09'x
dsd lrecl = 30000 firstobs=2 missover;


input
	pbp_a_hnumber
	pbp_a_plan_identifier
	segment_id
	pbp_a_ben_cov
	pbp_a_plan_type
	orgtype
	bid_id
	version
	pbp_vbid_group_id
	pbp_b14c_bendesc_yn
	pbp_b14c_bendesc_ehc
	pbp_b14c_bendesc_amo_hec
	pbp_b14c_bendesc_amo_ntb
	pbp_b14c_bendesc_lim_ntb
	pbp_b14c_bendesc_num_ntb
	pbp_b14c_bendesc_dur_ntb
	pbp_b14c_bendesc_amo_sc
	pbp_b14c_bendesc_visit_num_sc
	pbp_b14c_bendesc_amo_mhc
	pbp_b14c_bendesc_typ_mhc
	pbp_b14c_bendesc_amo_edm
	pbp_b14c_bendesc_amo_tm
	pbp_b14c_bendesc_amo_rat
	pbp_b14c_rat_bendesc_ehc
	pbp_b14c_bendesc_amo_bsd
	pbp_b14c_bendesc_amo_cs
	pbp_b14c_bendesc_lim_cs
	pbp_b14c_bendesc_num_cs
	pbp_b14c_bendesc_dur_cs
	pbp_b14c_bendesc_dur_num_cs
	pbp_b14c_bendesc_amo_isa
	pbp_b14c_bendesc_amo_prs
	pbp_b14c_bendesc_amo_mnt
	pbp_b14c_mnt_mcd_yn
	pbp_b14c_mnt_mcd_unit
	pbp_b14c_mnt_mcd_num
	pbp_b14c_mnt_nmcd_yn
	pbp_b14c_mnt_nmcd_unit
	pbp_b14c_mnt_nmcd_num
	pbp_b14c_bendesc_amo_imr
	pbp_b14c_bendesc_amo_rp
	pbp_b14c_rp_bendesc_ehc
	pbp_b14c_rp_bendesc_other
	pbp_b14c_rp_days
	pbp_b14c_rp_max_meals
	pbp_b14c_bendesc_amo_wig
	pbp_b14c_bendesc_amo_wm
	pbp_b14c_bendesc_amo_at
	pbp_b14c_bendesc_lim_at
	pbp_b14c_at_visits
	pbp_b14c_combined_ben
	pbp_b14c_bendesc_thp_msg
	pbp_b14c_bendesc_adcs
	pbp_b14c_bendesc_hbpc
	pbp_b14c_bendesc_ihss
	pbp_b14c_bendesc_sce
	pbp_b14c_maxplan_yn
	pbp_b14c_maxplan_ehc
	pbp_b14c_maxplan_amt_hec
	pbp_b14c_maxplan_per_hec
	pbp_b14c_maxplan_amt_ntb
	pbp_b14c_maxplan_per_ntb
	pbp_b14c_maxplan_amt_sc
	pbp_b14c_maxplan_per_sc
	pbp_b14c_maxplan_amt_mhc
	pbp_b14c_maxplan_per_mhc
	pbp_b14c_maxplan_amt_edm
	pbp_b14c_maxplan_per_edm
	pbp_b14c_maxplan_amt_tm
	pbp_b14c_maxplan_per_tm
	pbp_b14c_maxplan_amt_rat
	pbp_b14c_maxplan_per_rat
	pbp_b14c_maxplan_amt_bsd
	pbp_b14c_maxplan_per_bsd
	pbp_b14c_maxplan_amt_cs
	pbp_b14c_maxplan_per_cs
	pbp_b14c_maxplan_amt_isa
	pbp_b14c_maxplan_per_isa
	pbp_b14c_maxplan_amt_prs
	pbp_b14c_maxplan_per_prs
	pbp_b14c_maxplan_amt_mnt
	pbp_b14c_maxplan_per_mnt
	pbp_b14c_maxplan_amt_imr
	pbp_b14c_maxplan_per_imr
	pbp_b14c_maxplan_amt_rp
	pbp_b14c_maxplan_per_rp
	pbp_b14c_maxplan_amt_wig
	pbp_b14c_maxplan_per_wig
	pbp_b14c_maxplan_amt_wm
	pbp_b14c_maxplan_per_wm
	pbp_b14c_maxplan_amt_at
	pbp_b14c_maxplan_per_at
	pbp_b14c_maxplan_amt_thms
	pbp_b14c_maxplan_per_thms
	pbp_b14c_maxplan_amt_adcs
	pbp_b14c_maxplan_per_adcs
	pbp_b14c_maxplan_amt_hbpc
	pbp_b14c_maxplan_per_hbpc
	pbp_b14c_maxplan_amt_ihss
	pbp_b14c_maxplan_per_ihss
	pbp_b14c_maxplan_amt_sce
	pbp_b14c_maxplan_per_sce
	pbp_b14c_maxenr_yn
	pbp_b14c_maxenr_ehc
	pbp_b14c_maxenr_amt_hec
	pbp_b14c_maxenr_per_hec
	pbp_b14c_maxenr_amt_ntb
	pbp_b14c_maxenr_per_ntb
	pbp_b14c_maxenr_amt_sc
	pbp_b14c_maxenr_per_sc
	pbp_b14c_maxenr_amt_mhc
	pbp_b14c_maxenr_per_mhc
	pbp_b14c_maxenr_amt_edm
	pbp_b14c_maxenr_per_edm
	pbp_b14c_maxenr_amt_tm
	pbp_b14c_maxenr_per_tm
	pbp_b14c_maxenr_amt_rat
	pbp_b14c_maxenr_per_rat
	pbp_b14c_maxenr_amt_bsd
	pbp_b14c_maxenr_per_bsd
	pbp_b14c_maxenr_amt_cs
	pbp_b14c_maxenr_per_cs
	pbp_b14c_maxenr_amt_isa
	pbp_b14c_maxenr_per_isa
	pbp_b14c_maxenr_amt_prs
	pbp_b14c_maxenr_per_prs
	pbp_b14c_maxenr_amt_mnt
	pbp_b14c_maxenr_per_mnt
	pbp_b14c_maxenr_amt_imr
	pbp_b14c_maxenr_per_imr
	pbp_b14c_maxenr_amt_rp
	pbp_b14c_maxenr_per_rp
	pbp_b14c_maxenr_amt_wig
	pbp_b14c_maxenr_per_wig
	pbp_b14c_maxenr_amt_wm
	pbp_b14c_maxenr_per_wm
	pbp_b14c_maxenr_amt_at
	pbp_b14c_maxenr_per_at
	pbp_b14c_maxenr_amt_thmg
	pbp_b14c_maxenr_per_thmg
	pbp_b14c_maxenr_amt_adcs
	pbp_b14c_maxenr_per_adcs
	pbp_b14c_maxenr_amt_hbpc
	pbp_b14c_maxenr_per_hbpc
	pbp_b14c_maxenr_amt_ihss
	pbp_b14c_maxenr_per_ihss
	pbp_b14c_maxenr_amt_sce
	pbp_b14c_maxenr_per_sce
	pbp_b14c_coins_yn
	pbp_b14c_coins_ehc
	pbp_b14c_coins_pct_min_hec
	pbp_b14c_coins_pct_max_hec
	pbp_b14c_coins_pct_min_ntb
	pbp_b14c_coins_pct_max_ntb
	pbp_b14c_coins_pct_min_sc
	pbp_b14c_coins_pct_max_sc
	pbp_b14c_coins_pct_min_mhc
	pbp_b14c_coins_pct_max_mhc
	pbp_b14c_coins_pct_min_edm
	pbp_b14c_coins_pct_max_edm
	pbp_b14c_coins_pct_min_tm
	pbp_b14c_coins_pct_max_tm
	pbp_b14c_coins_pct_min_rat_wp
	pbp_b14c_coins_pct_max_rat_wp
	pbp_b14c_coins_pct_min_rat_nh
	pbp_b14c_coins_pct_max_rat_nh
	pbp_b14c_coins_pct_min_bsd
	pbp_b14c_coins_pct_max_bsd
	pbp_b14c_coins_pct_min_cs
	pbp_b14c_coins_pct_max_cs
	pbp_b14c_coins_pct_min_isa
	pbp_b14c_coins_pct_max_isa
	pbp_b14c_coins_pct_min_prs
	pbp_b14c_coins_pct_max_prs
	pbp_b14c_coins_pct_min_mnt
	pbp_b14c_coins_pct_max_mnt
	pbp_b14c_coins_pct_min_imr
	pbp_b14c_coins_pct_max_imr
	pbp_b14c_coins_pct_min_rp
	pbp_b14c_coins_pct_max_rp
	pbp_b14c_coins_pct_min_wig
	pbp_b14c_coins_pct_max_wig
	pbp_b14c_coins_pct_min_wm
	pbp_b14c_coins_pct_max_wm
	pbp_b14c_coins_pct_min_at
	pbp_b14c_coins_pct_max_at
	pbp_b14c_coins_pct_min_thmg
	pbp_b14c_coins_pct_max_thmg
	pbp_b14c_coins_pct_min_adcs
	pbp_b14c_coins_pct_max_adcs
	pbp_b14c_coins_pct_min_hbpc
	pbp_b14c_coins_pct_max_hbpc
	pbp_b14c_coins_pct_min_ihss
	pbp_b14c_coins_pct_max_ihss
	pbp_b14c_coins_pct_min_sce
	pbp_b14c_coins_pct_max_sce
	pbp_b14c_ded_yn
	pbp_b14c_ded_amt
	pbp_b14c_copay_yn
	pbp_b14c_copay_ehc
	pbp_b14c_copay_hec_min_amt
	pbp_b14c_copay_hec_max_amt
	pbp_b14c_copay_ntb_min_amt
	pbp_b14c_copay_ntb_max_amt
	pbp_b14c_copay_sc_min_amt
	pbp_b14c_copay_sc_max_amt
	pbp_b14c_copay_mhc_min_amt
	pbp_b14c_copay_mhc_max_amt
	pbp_b14c_copay_edm_min_amt
	pbp_b14c_copay_edm_max_amt
	pbp_b14c_copay_tm_min_amt
	pbp_b14c_copay_tm_max_amt
	pbp_b14c_copay_rat_wp_min_amt
	pbp_b14c_copay_rat_wp_max_amt
	pbp_b14c_copay_rat_nh_min_amt
	pbp_b14c_copay_rat_nh_max_amt
	pbp_b14c_copay_bsd_min_amt
	pbp_b14c_copay_bsd_max_amt
	pbp_b14c_copay_cs_min_amt
	pbp_b14c_copay_cs_max_amt
	pbp_b14c_copay_isa_min_amt
	pbp_b14c_copay_isa_max_amt
	pbp_b14c_copay_prs_min_amt
	pbp_b14c_copay_prs_max_amt
	pbp_b14c_copay_mnt_min_amt
	pbp_b14c_copay_mnt_max_amt
	pbp_b14c_copay_imr_min_amt
	pbp_b14c_copay_imr_max_amt
	pbp_b14c_copay_rp_min_amt
	pbp_b14c_copay_rp_max_amt
	pbp_b14c_copay_wig_min_amt
	pbp_b14c_copay_wig_max_amt
	pbp_b14c_copay_wm_min_amt
	pbp_b14c_copay_wm_max_amt
	pbp_b14c_copay_at_min_amt
	pbp_b14c_copay_at_max_amt
	pbp_b14c_copay_min_amt_thmg
	pbp_b14c_copay_max_amt_thmg
	pbp_b14c_copay_min_amt_adcs
	pbp_b14c_copay_max_amt_adcs
	pbp_b14c_copay_min_amt_hbpc
	pbp_b14c_copay_max_amt_hbpc
	pbp_b14c_copay_min_amt_ihss
	pbp_b14c_copay_max_amt_ihss
	pbp_b14c_copay_min_amt_sce
	pbp_b14c_copay_max_amt_sce
	pbp_b14c_auth_yn
	pbp_b14c_refer_yn	
;


label
	pbp_a_hnumber                    = 'H Number'
	pbp_a_plan_identifier            = 'Plan ID'
	segment_id                       = 'Segment ID'
	pbp_a_ben_cov                    = 'Coverage Criteria'
	pbp_a_plan_type                  = 'Plan Type'
	orgtype                          = 'Organization Type'
	bid_id                           = 'Bid ID'
	version                          = 'Version Number'
	pbp_vbid_group_id                = 'B19 VBID Group (Package) ID'
	pbp_b14c_bendesc_yn              = 'EligSuppBen Desc YN'
	pbp_b14c_bendesc_ehc             = 'EligSuppBen Desc Cats'
	pbp_b14c_bendesc_amo_hec         = 'Health Ed HEC Ben Desc MO'
	pbp_b14c_bendesc_amo_ntb         = 'Health Ed NTB Ben Desc MO'
	pbp_b14c_bendesc_lim_ntb         = '14C Nut Ben Desc Lim'
	pbp_b14c_bendesc_num_ntb         = '14C Nut Ben Desc Num'
	pbp_b14c_bendesc_dur_ntb         = '14C Nut Ben Desc Dur'
	pbp_b14c_bendesc_amo_sc          = 'Health Ed SC Ben Desc MO'
	pbp_b14c_bendesc_visit_num_sc    = '14C SC Num Visits'
	pbp_b14c_bendesc_amo_mhc         = '14C FB Ben Desc MO'
	pbp_b14c_bendesc_typ_mhc         = '14C Fitness Ben Type'
	pbp_b14c_bendesc_amo_edm         = 'Health Ed EDM AMO'
	pbp_b14c_bendesc_amo_tm          = 'Health Ed TM AMO'
	pbp_b14c_bendesc_amo_rat         = 'Health Ed RAT AMO'
	pbp_b14c_rat_bendesc_ehc         = 'b14c RAT benefit select'
	pbp_b14c_bendesc_amo_bsd         = 'BSD BENDESC_AMO Label'
	pbp_b14c_bendesc_amo_cs          = 'CS BENDESC_AMO Label'
	pbp_b14c_bendesc_lim_cs          = '14C CS Ben Desc Lim'
	pbp_b14c_bendesc_num_cs          = '14C CS Ben Desc Num'
	pbp_b14c_bendesc_dur_cs          = '14C CS Ben Desc Dur'
	pbp_b14c_bendesc_dur_num_cs      = '14C CS Dur Num'
	pbp_b14c_bendesc_amo_isa         = 'ISA BENDESC_AMO Label'
	pbp_b14c_bendesc_amo_prs         = 'PRS BENDESC_AMO Label'
	pbp_b14c_bendesc_amo_mnt         = 'MNT BENDESC_AMO Label'
	pbp_b14c_mnt_mcd_yn              = 'AdtlSess MC diseases yn'
	pbp_b14c_mnt_mcd_unit            = 'AdtlSess MC diseases unit'
	pbp_b14c_mnt_mcd_num             = 'AdtlSess MC diseases num'
	pbp_b14c_mnt_nmcd_yn             = 'Coverage NMC diseases'
	pbp_b14c_mnt_nmcd_unit           = 'Coverage NMC diseases unit'
	pbp_b14c_mnt_nmcd_num            = 'Coverage NMC diseases num'
	pbp_b14c_bendesc_amo_imr         = 'IMR BENDESC_AMO Label'
	pbp_b14c_bendesc_amo_rp          = 'RP BENDESC_AMO Label'
	pbp_b14c_rp_bendesc_ehc          = 'B14C RP Benefit List'
	pbp_b14c_rp_bendesc_other        = 'Other RP Service Name'
	pbp_b14c_rp_days                 = 'How many days does your Meal'
	pbp_b14c_rp_max_meals            = 'Max Meals'
	pbp_b14c_bendesc_amo_wig         = 'WIG BENDESC_AMO Label'
	pbp_b14c_bendesc_amo_wm          = 'Weight Mngmt Ben Desc MO'
	pbp_b14c_bendesc_amo_at          = 'AltTherapy Ben Desc MO'
	pbp_b14c_bendesc_lim_at          = '14C AT Ben Desc Lim'
	pbp_b14c_at_visits               = 'B14C Visits AT'
	pbp_b14c_combined_ben            = 'B14c combined ben yn'
	pbp_b14c_bendesc_thp_msg         = 'Ther Mssg Ben Desc MO'
	pbp_b14c_bendesc_adcs            = 'Adult Day Care Svc Ben Desc'
	pbp_b14c_bendesc_hbpc            = 'Home Bsd Pal Care Ben Desc'
	pbp_b14c_bendesc_ihss            = 'In Hme Sppt Svc Ben Desc'
	pbp_b14c_bendesc_sce             = 'Spt Cre Give Enr Ben Desc'
	pbp_b14c_maxplan_yn              = 'Max Plan YN'
	pbp_b14c_maxplan_ehc             = '14C Maxplan enhanced bens'
	pbp_b14c_maxplan_amt_hec         = 'HEC Max Plan Amt'
	pbp_b14c_maxplan_per_hec         = 'HEC Max Plan Per'
	pbp_b14c_maxplan_amt_ntb         = 'NTB Max Plan Amt'
	pbp_b14c_maxplan_per_ntb         = 'NTB Max Plan Per'
	pbp_b14c_maxplan_amt_sc          = 'SC Max Plan Amt'
	pbp_b14c_maxplan_per_sc          = 'SC Max Plan Per'
	pbp_b14c_maxplan_amt_mhc         = 'FB Max Plan Amt'
	pbp_b14c_maxplan_per_mhc         = 'FB Max Plan Per'
	pbp_b14c_maxplan_amt_edm         = 'EDM Max Plan Amt'
	pbp_b14c_maxplan_per_edm         = 'EDM Max Plan Per'
	pbp_b14c_maxplan_amt_tm          = 'TM Max Plan Amt'
	pbp_b14c_maxplan_per_tm          = 'TM Max Plan Per'
	pbp_b14c_maxplan_amt_rat         = 'RAT Max Plan Amt'
	pbp_b14c_maxplan_per_rat         = 'RAT Max Plan Per'
	pbp_b14c_maxplan_amt_bsd         = 'BSD Max Plan Amt'
	pbp_b14c_maxplan_per_bsd         = 'BSD Max Plan Per'
	pbp_b14c_maxplan_amt_cs          = 'CS Max Plan Amt'
	pbp_b14c_maxplan_per_cs          = 'CS Max Plan Per'
	pbp_b14c_maxplan_amt_isa         = 'ISA Max Plan Amt'
	pbp_b14c_maxplan_per_isa         = 'ISA Max Plan Per'
	pbp_b14c_maxplan_amt_prs         = 'PRS Max Plan Amt'
	pbp_b14c_maxplan_per_prs         = 'PRS Max Plan Per'
	pbp_b14c_maxplan_amt_mnt         = 'MNT Max Plan Amt'
	pbp_b14c_maxplan_per_mnt         = 'MNT Max Plan Per'
	pbp_b14c_maxplan_amt_imr         = 'IMR Max Plan Amt'
	pbp_b14c_maxplan_per_imr         = 'IMR Max Plan Per'
	pbp_b14c_maxplan_amt_rp          = 'RP Max Plan Amt'
	pbp_b14c_maxplan_per_rp          = 'RP Max Plan Per'
	pbp_b14c_maxplan_amt_wig         = 'WIG Max Plan Amt'
	pbp_b14c_maxplan_per_wig         = 'WIG Max Plan Per'
	pbp_b14c_maxplan_amt_wm          = 'WMP Max Plan Amt'
	pbp_b14c_maxplan_per_wm          = 'WMP Max Plan Per'
	pbp_b14c_maxplan_amt_at          = 'ALT Max Plan Amt'
	pbp_b14c_maxplan_per_at          = 'ALT Max Plan Per'
	pbp_b14c_maxplan_amt_thms        = 'TM Max Plan Amt'
	pbp_b14c_maxplan_per_thms        = 'THMS Max Plan Per'
	pbp_b14c_maxplan_amt_adcs        = 'ADCS Max Plan Amt'
	pbp_b14c_maxplan_per_adcs        = 'ADCS Max Plan Per'
	pbp_b14c_maxplan_amt_hbpc        = 'HBPC Max Plan Amt'
	pbp_b14c_maxplan_per_hbpc        = 'HBPC Max Plan Per'
	pbp_b14c_maxplan_amt_ihss        = 'IHSS Max Plan Amt'
	pbp_b14c_maxplan_per_ihss        = 'IHSS Max Plan Per'
	pbp_b14c_maxplan_amt_sce         = 'SCE Max Plan Amt'
	pbp_b14c_maxplan_per_sce         = 'SCE Max Plan Per'
	pbp_b14c_maxenr_yn               = 'EligSuppBen Max Enr YN'
	pbp_b14c_maxenr_ehc              = '14C Max Enr enhanced bens'
	pbp_b14c_maxenr_amt_hec          = 'B14c HEC Max Enr Amt'
	pbp_b14c_maxenr_per_hec          = 'B14c HEC Max Enr Per'
	pbp_b14c_maxenr_amt_ntb          = 'B14c NTB Max Enr Amt'
	pbp_b14c_maxenr_per_ntb          = 'B14c NTB Max Enr Per'
	pbp_b14c_maxenr_amt_sc           = 'B14c SC Max Enr Amt'
	pbp_b14c_maxenr_per_sc           = 'B14c SC Max Enr Per'
	pbp_b14c_maxenr_amt_mhc          = 'B14c FB Max Enr Amt'
	pbp_b14c_maxenr_per_mhc          = 'B14c FB Max Enr Per'
	pbp_b14c_maxenr_amt_edm          = 'B14c EDM Max Enr Amt'
	pbp_b14c_maxenr_per_edm          = 'B14c EDM Max Enr Per'
	pbp_b14c_maxenr_amt_tm           = 'B14c TM Max Enr Amt'
	pbp_b14c_maxenr_per_tm           = 'B14c TM Max Enr Per'
	pbp_b14c_maxenr_amt_rat          = 'B14c RAT Max Enr Amt'
	pbp_b14c_maxenr_per_rat          = 'B14c RAT Max Enr Per'
	pbp_b14c_maxenr_amt_bsd          = 'B14c BSD Max Enr Amt'
	pbp_b14c_maxenr_per_bsd          = 'B14c BSD Max Enr Per'
	pbp_b14c_maxenr_amt_cs           = 'B14c CS Max Enr Amt'
	pbp_b14c_maxenr_per_cs           = 'B14c CS Max Enr Per'
	pbp_b14c_maxenr_amt_isa          = 'B14c ISA Max Enr Amt'
	pbp_b14c_maxenr_per_isa          = 'B14c ISA Max Enr Per'
	pbp_b14c_maxenr_amt_prs          = 'B14c PRS Max Enr Amt'
	pbp_b14c_maxenr_per_prs          = 'B14c PRS Max Enr Per'
	pbp_b14c_maxenr_amt_mnt          = 'B14c MNT Max Enr Amt'
	pbp_b14c_maxenr_per_mnt          = 'B14c MNT Max Enr Per'
	pbp_b14c_maxenr_amt_imr          = 'B14c IMR Max Enr Amt'
	pbp_b14c_maxenr_per_imr          = 'B14c IMR Max Enr Per'
	pbp_b14c_maxenr_amt_rp           = 'B14c RP Max Enr Amt'
	pbp_b14c_maxenr_per_rp           = 'B14c RP Max Enr Per'
	pbp_b14c_maxenr_amt_wig          = 'B14c WIG Max Enr Amt'
	pbp_b14c_maxenr_per_wig          = 'B14c WIG Max Enr Per'
	pbp_b14c_maxenr_amt_wm           = 'B14c WM Max Enr Amt'
	pbp_b14c_maxenr_per_wm           = 'B14c WM Max Enr Per'
	pbp_b14c_maxenr_amt_at           = 'B14c AT Max Enr Amt'
	pbp_b14c_maxenr_per_at           = 'B14c AT Max Enr Per'
	pbp_b14c_maxenr_amt_thmg         = 'B14c THMG Max Enr Amt'
	pbp_b14c_maxenr_per_thmg         = 'B14c THMG Max Enr Per'
	pbp_b14c_maxenr_amt_adcs         = 'B14c ADCS Max Enr Amt'
	pbp_b14c_maxenr_per_adcs         = 'B14c ADCS Max Enr Per'
	pbp_b14c_maxenr_amt_hbpc         = 'B14c HBPC Max Enr Amt'
	pbp_b14c_maxenr_per_hbpc         = 'B14c HBPC Max Enr Per'
	pbp_b14c_maxenr_amt_ihss         = 'B14c IHSS Max Enr Amt'
	pbp_b14c_maxenr_per_ihss         = 'B14c IHSS Max Enr Per'
	pbp_b14c_maxenr_amt_sce          = 'B14c SCE Max Enr Amt'
	pbp_b14c_maxenr_per_sce          = 'B14c SCE Max Enr Per'
	pbp_b14c_coins_yn                = 'EligSuppBen Coinsurance YN'
	pbp_b14c_coins_ehc               = 'B14C Coins Enhance Bens'
	pbp_b14c_coins_pct_min_hec       = 'Health Ed HEC Min Coins Pct'
	pbp_b14c_coins_pct_max_hec       = 'Health Ed HEC Max Coins Pct'
	pbp_b14c_coins_pct_min_ntb       = 'Health Ed NTB Coins min Pct'
	pbp_b14c_coins_pct_max_ntb       = 'Health Ed NTB Coins max Pct'
	pbp_b14c_coins_pct_min_sc        = 'Health Ed SC Coins min Pct'
	pbp_b14c_coins_pct_max_sc        = 'Health Ed SC Coins max Pct'
	pbp_b14c_coins_pct_min_mhc       = '14C FB Min Coins Pct'
	pbp_b14c_coins_pct_max_mhc       = '14C FB Max Coins Pct'
	pbp_b14c_coins_pct_min_edm       = 'B14C EDM Coinsurance min Pct'
	pbp_b14c_coins_pct_max_edm       = 'B14C EDM Coinsurance max Pct'
	pbp_b14c_coins_pct_min_tm        = 'B14C TM Coinsurance min Pct'
	pbp_b14c_coins_pct_max_tm        = 'B14C TM Coinsurance max Pct'
	pbp_b14c_coins_pct_min_rat_wp    = 'B14C RAT WP Coins min Pct'
	pbp_b14c_coins_pct_max_rat_wp    = 'B14C RAT WP Coins max Pct'
	pbp_b14c_coins_pct_min_rat_nh    = 'B14C RAT NH Coins min Pct'
	pbp_b14c_coins_pct_max_rat_nh    = 'B14C RAT NH Coins min Pct'
	pbp_b14c_coins_pct_min_bsd       = 'BSD COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_bsd       = 'BSD COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_cs        = 'CS COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_cs        = 'CS COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_isa       = 'ISA COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_isa       = 'ISA COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_prs       = 'PRS COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_prs       = 'PRS COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_mnt       = 'MNT COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_mnt       = 'MNT COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_imr       = 'IMR COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_imr       = 'IMR COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_rp        = 'RP COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_rp        = 'RP COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_wig       = 'WIG COINS_PCT_MIN Label'
	pbp_b14c_coins_pct_max_wig       = 'WIG COINS_PCT_MAX Label'
	pbp_b14c_coins_pct_min_wm        = 'WeightManage Min Coins Pct'
	pbp_b14c_coins_pct_max_wm        = 'WeightManage Max Coins Pct'
	pbp_b14c_coins_pct_min_at        = 'AltTherapy Min Coins Pct'
	pbp_b14c_coins_pct_max_at        = 'AltTherapy Max Coins Pct'
	pbp_b14c_coins_pct_min_thmg      = 'THMG Min Coins Pct'
	pbp_b14c_coins_pct_max_thmg      = 'THMG Max Coins Pct'
	pbp_b14c_coins_pct_min_adcs      = 'ADCS Min Coins Pct'
	pbp_b14c_coins_pct_max_adcs      = 'ADCS Max Coins Pct'
	pbp_b14c_coins_pct_min_hbpc      = 'HBPC Min Coins Pct'
	pbp_b14c_coins_pct_max_hbpc      = 'HBPC Max Coins Pct'
	pbp_b14c_coins_pct_min_ihss      = 'IHSS Min Coins Pct'
	pbp_b14c_coins_pct_max_ihss      = 'IHSS Max Coins Pct'
	pbp_b14c_coins_pct_min_sce       = 'SCE Min Coins Pct'
	pbp_b14c_coins_pct_max_sce       = 'SCE Max Coins Pct'
	pbp_b14c_ded_yn                  = 'EligSuppBen Deductible YN'
	pbp_b14c_ded_amt                 = 'EligSuppBen Deductible Amt'
	pbp_b14c_copay_yn                = 'EligSuppBen Copayment YN'
	pbp_b14c_copay_ehc               = '14C Copay Enhanced Bens'
	pbp_b14c_copay_hec_min_amt       = 'Health Ed HEC Copay Min Amt'
	pbp_b14c_copay_hec_max_amt       = 'Health Ed HEC Copay Max Amt'
	pbp_b14c_copay_ntb_min_amt       = 'Health Ed NTB Copay min Amt'
	pbp_b14c_copay_ntb_max_amt       = 'Health Ed NTB Copay max Amt'
	pbp_b14c_copay_sc_min_amt        = 'Health Ed SC Copay min Amt'
	pbp_b14c_copay_sc_max_amt        = 'Health Ed SC Copay max Amt'
	pbp_b14c_copay_mhc_min_amt       = '14C FB Min Copay Amt'
	pbp_b14c_copay_mhc_max_amt       = '14C FB Max Copay Amt'
	pbp_b14c_copay_edm_min_amt       = 'B14C EDM Copayment min Amt'
	pbp_b14c_copay_edm_max_amt       = 'B14C EDM Copayment max Amt'
	pbp_b14c_copay_tm_min_amt        = 'B14C TM Copayment min Amt'
	pbp_b14c_copay_tm_max_amt        = 'B14C TM Copayment max Amt'
	pbp_b14c_copay_rat_wp_min_amt    = 'B14C RAT WP Copay min Amt'
	pbp_b14c_copay_rat_wp_max_amt    = 'B14C RAT WP Copay max Amt'
	pbp_b14c_copay_rat_nh_min_amt    = 'B14C RAT NH Copay min Amt'
	pbp_b14c_copay_rat_nh_max_amt    = 'B14C RAT NH Copay min Amt'
	pbp_b14c_copay_bsd_min_amt       = 'BSD COPAY_MIN Label'
	pbp_b14c_copay_bsd_max_amt       = 'BSD COPAY_MAX Label'
	pbp_b14c_copay_cs_min_amt        = 'CS COPAY_MIN Label'
	pbp_b14c_copay_cs_max_amt        = 'CS COPAY_MAX Label'
	pbp_b14c_copay_isa_min_amt       = 'ISA COPAY_MIN Label'
	pbp_b14c_copay_isa_max_amt       = 'ISA COPAY_MAX Label'
	pbp_b14c_copay_prs_min_amt       = 'PRS COPAY_MIN Label'
	pbp_b14c_copay_prs_max_amt       = 'PRS COPAY_MAX Label'
	pbp_b14c_copay_mnt_min_amt       = 'MNT COPAY_MIN Label'
	pbp_b14c_copay_mnt_max_amt       = 'MNT COPAY_MAX Label'
	pbp_b14c_copay_imr_min_amt       = 'IMR COPAY_MIN Label'
	pbp_b14c_copay_imr_max_amt       = 'IMR COPAY_MAX Label'
	pbp_b14c_copay_rp_min_amt        = 'RP COPAY_MIN Label'
	pbp_b14c_copay_rp_max_amt        = 'RP COPAY_MAX Label'
	pbp_b14c_copay_wig_min_amt       = 'WIG COPAY_MIN Label'
	pbp_b14c_copay_wig_max_amt       = 'WIG COPAY_MAX Label'
	pbp_b14c_copay_wm_min_amt        = 'WeightManage Copay Min Amt'
	pbp_b14c_copay_wm_max_amt        = 'WeightManage Copay Max Amt'
	pbp_b14c_copay_at_min_amt        = 'AltTherapy Copay Min Amt'
	pbp_b14c_copay_at_max_amt        = 'AltTherapy Copay Max Amt'
	pbp_b14c_copay_min_amt_thmg      = 'THMG Copay Min Amt'
	pbp_b14c_copay_max_amt_thmg      = 'THMG Copay Max Amt'
	pbp_b14c_copay_min_amt_adcs      = 'ADCS Copay Min Amt'
	pbp_b14c_copay_max_amt_adcs      = 'ADCS Copay Max Amt'
	pbp_b14c_copay_min_amt_hbpc      = 'HBPC Copay Min Amt'
	pbp_b14c_copay_max_amt_hbpc      = 'HBPC Copay Max Amt'
	pbp_b14c_copay_min_amt_ihss      = 'IHSS Copay Min Amt'
	pbp_b14c_copay_max_amt_ihss      = 'IHSS Copay Max Amt'
	pbp_b14c_copay_min_amt_sce       = 'SCE Copay Min Amt'
	pbp_b14c_copay_max_amt_sce       = 'SCE Copay Max Amt'
	pbp_b14c_auth_yn                 = 'EligSuppBen Enrollee Auth YN'
	pbp_b14c_refer_yn                = 'EligSuppBen Referral YN'
;

run;

proc sort data = pbp_b14c_vbid out=out.pbp_b14c_vbid;
  by Pbp_a_hnumber pbp_a_plan_identifier segment_id;
run;

proc print data = out.pbp_b14c_vbid(obs = 10);
  title 'pbp_b14c_b19b_preventive_vbid_uf file ';
run;

proc means data = out.pbp_b14c_vbid;
  title 'pbp_b14c_b19b_preventive_vbid_uf file ';
run;

proc freq data = out.pbp_b14c_vbid;
table
	pbp_a_ben_cov
	pbp_a_plan_type
	orgtype
	pbp_vbid_group_id
	pbp_b14c_bendesc_yn
	pbp_b14c_bendesc_amo_hec
	pbp_b14c_bendesc_amo_ntb
	pbp_b14c_bendesc_lim_ntb
	pbp_b14c_bendesc_dur_ntb
	pbp_b14c_bendesc_amo_sc
	pbp_b14c_bendesc_amo_mhc
	pbp_b14c_bendesc_typ_mhc
	pbp_b14c_bendesc_amo_edm
	pbp_b14c_bendesc_amo_tm
	pbp_b14c_bendesc_amo_rat
	pbp_b14c_rat_bendesc_ehc
	pbp_b14c_bendesc_amo_bsd
	pbp_b14c_bendesc_amo_cs
	pbp_b14c_bendesc_lim_cs
	pbp_b14c_bendesc_dur_cs
	pbp_b14c_bendesc_amo_isa
	pbp_b14c_bendesc_amo_prs
	pbp_b14c_bendesc_amo_mnt
	pbp_b14c_mnt_mcd_yn
	pbp_b14c_mnt_mcd_unit
	pbp_b14c_mnt_nmcd_yn
	pbp_b14c_mnt_nmcd_unit
	pbp_b14c_bendesc_amo_imr
	pbp_b14c_bendesc_amo_rp
	pbp_b14c_rp_bendesc_ehc
	pbp_b14c_bendesc_amo_wig
	pbp_b14c_bendesc_amo_wm
	pbp_b14c_bendesc_amo_at
	pbp_b14c_bendesc_lim_at
	pbp_b14c_combined_ben
	pbp_b14c_bendesc_thp_msg
	pbp_b14c_bendesc_adcs
	pbp_b14c_bendesc_hbpc
	pbp_b14c_bendesc_ihss
	pbp_b14c_bendesc_sce
	pbp_b14c_maxplan_yn
	pbp_b14c_maxplan_per_hec
	pbp_b14c_maxplan_per_ntb
	pbp_b14c_maxplan_per_sc
	pbp_b14c_maxplan_per_mhc
	pbp_b14c_maxplan_per_edm
	pbp_b14c_maxplan_per_tm
	pbp_b14c_maxplan_per_rat
	pbp_b14c_maxplan_per_bsd
	pbp_b14c_maxplan_per_cs
	pbp_b14c_maxplan_per_isa
	pbp_b14c_maxplan_per_prs
	pbp_b14c_maxplan_per_mnt
	pbp_b14c_maxplan_per_imr
	pbp_b14c_maxplan_per_rp
	pbp_b14c_maxplan_per_wig
	pbp_b14c_maxplan_per_wm
	pbp_b14c_maxplan_per_at
	pbp_b14c_maxplan_per_thms
	pbp_b14c_maxplan_per_adcs
	pbp_b14c_maxplan_per_hbpc
	pbp_b14c_maxplan_per_ihss
	pbp_b14c_maxplan_per_sce
	pbp_b14c_maxenr_yn
	pbp_b14c_maxenr_per_hec
	pbp_b14c_maxenr_per_ntb
	pbp_b14c_maxenr_per_sc
	pbp_b14c_maxenr_per_mhc
	pbp_b14c_maxenr_per_edm
	pbp_b14c_maxenr_per_tm
	pbp_b14c_maxenr_per_rat
	pbp_b14c_maxenr_per_bsd
	pbp_b14c_maxenr_per_cs
	pbp_b14c_maxenr_per_isa
	pbp_b14c_maxenr_per_prs
	pbp_b14c_maxenr_per_mnt
	pbp_b14c_maxenr_per_imr
	pbp_b14c_maxenr_per_rp
	pbp_b14c_maxenr_per_wig
	pbp_b14c_maxenr_per_wm
	pbp_b14c_maxenr_per_at
	pbp_b14c_maxenr_per_thmg
	pbp_b14c_maxenr_per_adcs
	pbp_b14c_maxenr_per_hbpc
	pbp_b14c_maxenr_per_ihss
	pbp_b14c_maxenr_per_sce
	pbp_b14c_coins_yn
	pbp_b14c_ded_yn
	pbp_b14c_copay_yn
	pbp_b14c_auth_yn
	pbp_b14c_refer_yn
/ missing;
run;

proc contents data = out.pbp_b14c_vbid;
  title 'pbp_b14c_vbid data';
run;