I am using proc report to product the following report:   Here is the current output:   Market Region Branch Central Ohio Market Buckeye Central Region 02800105 Lane Ave BC Buckeye Central Region Buckeye Central Region 02800117C Northland BC Buckeye Central Region Buckeye Central Region 02800141C Worthington BC Buckeye Central Region Buckeye Central Region 02800142C Grandview BC Buckeye Central Region Buckeye Central Region 02800143C German Village BC Buckeye Central Region Buckeye Central Region 02800145C Upper Arlington BC Buckeye Central Region Buckeye Central Region 02800152C Clintonville BC Buckeye Central Region Buckeye Central Region 02800168C OSU Financial Center BC Buckeye Central Region Buckeye Central Region 02800683C State St BC Buckeye Central Region Buckeye Central Region 02800725C Bexley/Main St BC Buckeye Central Region Buckeye Central Region 02802917 Graceland BM Buckeye Central Region Central Ohio Market Admin NON-BRANCH Central Ohio Market Admin East C-Bus Region 02800130C Gahanna BC East C-Bus Region East C-Bus Region 02800132C Westerville South BC East C-Bus Region East C-Bus Region 02800157C New Albany BC East C-Bus Region East C-Bus Region 02800164 Schrock Rd BM East C-Bus Region East C-Bus Region 02800208 Newark BC East C-Bus Region East C-Bus Region 02800209C Westerville North BC East C-Bus Region East C-Bus Region 02800549 Stoneridge BC East C-Bus Region East C-Bus Region 02800719C Columbus Square BC East C-Bus Region East C-Bus Region 02800721C Linden BC East C-Bus Region East C-Bus Region 02801747C Polaris BC East C-Bus Region East C-Bus Region 02802924 Sunbury Rd BM East C-Bus Region East C-Bus Region 02806390C Lewis Ctr BC East C-Bus Region Northwest C-Bus Region 02800068C Dubin-Avery Rd BC Northwest C-Bus Region Northwest C-Bus Region 02800093C Delaware BC   Here is the code used to produce the above report: proc report data=reln_depth_branch_rank style(report)={BORDERCOLOR=black BORDERWIDTH=1} style(column)={BORDERCOLOR=black} style(header)={BORDERCOLOR=black background = #DBE5F1 foreground=black} style(summary)={font_weight=bold font_style=Roman}; options missing = ' '; columns (&mnth_title market region branch hh_count core_reln_depth core_rank ckg  sav cd a360 he dir_ind mort ccard ann brkg ins eax ida dcard obp dir_dep digi mdep alerts spc1 total_reln_depth total_rank spc2 single_svc_cnt five_svc_cnt); define market / Group left 'Market'; compute market; if market NE ' ' then hold=market; if market EQ ' ' then market=hold; endcomp; define region / Group left 'Region'; compute region; if region NE ' ' then hold=region; if region EQ ' ' then region=hold; endcomp; define branch / Group left 'Branch'; define hh_count / sum 'HH Count' format=comma12.0; define core_reln_depth / mean weight=hh_count 'Core Reln Depth' format=comma12.2; define core_rank / display 'Rank'; define ckg / mean weight=hh_count 'Checking' format=percent12.1; define sav / mean weight=hh_count 'Savings' format=percent12.1; define cd / mean weight=hh_count'CD' format=percent12.1; define a360 / mean weight=hh_count 'Access 360' format=percent12.1; define he / mean weight=hh_count 'Home Equity' format=percent12.1; define dir_ind / mean weight=hh_count 'Direct / Indirect Loan' format=percent12.1; define mort / mean weight=hh_count 'Mortgage' format=percent12.1; define ccard / mean weight=hh_count 'Credit Card' format=percent12.1; define ann / mean weight=hh_count 'Annuity' format=percent12.1; define brkg / mean weight=hh_count 'Brokerage' format=percent12.1; define ins / mean weight=hh_count 'Insurance' format=percent12.1; define eax / mean weight=hh_count 'Early Access' format=percent12.1; define ida / mean weight=hh_count 'ID Alert' format=percent12.1; define dcard / mean weight=hh_count 'Debit Card' format=percent12.1; define obp / mean weight=hh_count 'Online Bill Pay' format=percent12.1; define dir_dep / mean weight=hh_count 'Direct Deposit' format=percent12.1; define digi / mean weight=hh_count 'Digital Banking' format=percent12.1; define mdep / mean weight=hh_count 'Mobile Deposit' format=percent12.1; define alerts / mean weight=hh_count 'Alerts' format=percent12.1; define spc1 / display ''; define total_reln_depth / mean weight=hh_count 'Total Reln Depth' format=comma12.2; define total_rank / display 'Rank'; define spc2 / display ''; define single_svc_cnt / mean weight=hh_count 'Single Service' format=percent12.1; define five_svc_cnt / mean weight=hh_count 'Five+ Services' format=percent12.1; compute after; market='Totals'; region=''; endcomp; rbreak after / summarize; run;   What I actually need is for the Market value to repeat for each row in that column until a new Market value is encountered.  What it is doing is filling in the Region values in the Market column.  Here is an example I did in Excel to demonstrate what the report should look like.   Market Region Branch Central Ohio Market Buckeye Central Region 02800105 Lane Ave BC Central Ohio Market Buckeye Central Region 02800117C Northland BC Central Ohio Market Buckeye Central Region 02800141C Worthington BC Central Ohio Market Buckeye Central Region 02800142C Grandview BC Central Ohio Market Buckeye Central Region 02800143C German Village BC Central Ohio Market Buckeye Central Region 02800145C Upper Arlington BC Central Ohio Market Buckeye Central Region 02800152C Clintonville BC Central Ohio Market Buckeye Central Region 02800168C OSU Financial Center BC Central Ohio Market Buckeye Central Region 02800683C State St BC Central Ohio Market Buckeye Central Region 02800725C Bexley/Main St BC Central Ohio Market Buckeye Central Region 02802917 Graceland BM Central Ohio Market Central Ohio Market Admin NON-BRANCH Central Ohio Market East C-Bus Region 02800130C Gahanna BC Central Ohio Market East C-Bus Region 02800132C Westerville South BC Central Ohio Market East C-Bus Region 02800157C New Albany BC Central Ohio Market East C-Bus Region 02800164 Schrock Rd BM Central Ohio Market East C-Bus Region 02800208 Newark BC Central Ohio Market East C-Bus Region 02800209C Westerville North BC Central Ohio Market East C-Bus Region 02800549 Stoneridge BC Central Ohio Market East C-Bus Region 02800719C Columbus Square BC Central Ohio Market East C-Bus Region 02800721C Linden BC Central Ohio Market East C-Bus Region 02801747C Polaris BC Central Ohio Market East C-Bus Region 02802924 Sunbury Rd BM Central Ohio Market East C-Bus Region 02806390C Lewis Ctr BC Central Ohio Market Northwest C-Bus Region 02800068C Dubin-Avery Rd BC Central Ohio Market Northwest C-Bus Region 02800093C Delaware BC   Any help would be greatly appreciated.  Thanks!   Scott ... View more