==============================================================================
probe_1978_1988_drops � Flag 3: characterize ~32% row drops
==============================================================================

--------------------------------------------------
Pair: FY 1977 (baseline) vs FY 1978 (drop)
--------------------------------------------------

FY 1977:
  (a) Stage 1 raw rows (after unified projection):     17,514
      distinct institution_id (raw):                      535
  (b) Stage 2 in-scope rows (era-A filter):             8,629
      question='Expenditures by S&E field'                                  n= 8,629 (100.0%)
  (b') Stage 2 distinct columns observed:
      column='Total'              n= 4,718 ( 54.7%)
      column='Federal'            n= 3,911 ( 45.3%)
  (c) Stage 4 panel rows (column='Total'):              4,718
      distinct institution_id (panel):                    535

FY 1978:
  (a) Stage 1 raw rows (after unified projection):      7,602
      distinct institution_id (raw):                      316
  (b) Stage 2 in-scope rows (era-A filter):             6,007
      question='Expenditures by S&E field'                                  n= 6,007 (100.0%)
  (b') Stage 2 distinct columns observed:
      column='Total'              n= 3,194 ( 53.2%)
      column='Federal'            n= 2,813 ( 46.8%)
  (c) Stage 4 panel rows (column='Total'):              3,194
      distinct institution_id (panel):                    316

Delta analysis (FY 1978 vs FY 1977):
  Stage 1 raw     :    17,514 ->     7,602   delta=-9,912  (-56.6%)
  Stage 2 in-scope:     8,629 ->     6,007   delta=-2,622  (-30.4%)
  Stage 4 panel   :     4,718 ->     3,194   delta=-1,524  (-32.3%)

--------------------------------------------------
Pair: FY 1987 (baseline) vs FY 1988 (drop)
--------------------------------------------------

FY 1987:
  (a) Stage 1 raw rows (after unified projection):     52,106
      distinct institution_id (raw):                      554
  (b) Stage 2 in-scope rows (era-A filter):            45,721
      question='Expenditures by S&E field'                                  n=23,478 ( 51.4%)
      question='Equipment expenditures by S&E field'                        n=22,243 ( 48.6%)
  (b') Stage 2 distinct columns observed:
      column='Total'              n=23,478 ( 51.4%)
      column='Federal'            n=22,243 ( 48.6%)
  (c) Stage 4 panel rows (column='Total'):             23,478
      distinct institution_id (panel):                    554

FY 1988:
  (a) Stage 1 raw rows (after unified projection):     36,852
      distinct institution_id (raw):                      554
  (b) Stage 2 in-scope rows (era-A filter):            29,950
      question='Expenditures by S&E field'                                  n=16,110 ( 53.8%)
      question='Equipment expenditures by S&E field'                        n=13,840 ( 46.2%)
  (b') Stage 2 distinct columns observed:
      column='Total'              n=15,970 ( 53.3%)
      column='Federal'            n=13,980 ( 46.7%)
  (c) Stage 4 panel rows (column='Total'):             15,970
      distinct institution_id (panel):                    554

Delta analysis (FY 1988 vs FY 1987):
  Stage 1 raw     :    52,106 ->    36,852   delta=-15,254  (-29.3%)
  Stage 2 in-scope:    45,721 ->    29,950   delta=-15,771  (-34.5%)
  Stage 4 panel   :    23,478 ->    15,970   delta=-7,508  (-32.0%)
