Sensory Evaluation  HOME CONTACT ABOUT US SUPPORT SENSORYTEST.COM
 
Sensory Evaluation  SIMS SOFTWARE QUESTION CHOICES CLIENT COMMENTS
 MARKETS VIEW REPORTS FREE EVALUATION
 TEST CHOICES GET DEMO SUPPORT
 
"Awesome, and we're saving money every year."

View More Reports
Top/Bottom 2 Boxes & 3 Boxes Advanced Analysis:

The Top/Bottom 2 Boxes & 3 Boxes Advanced Analysis Reports in SIMS Sensory Quality Panel Software Systems summarizes the extreme observations for Hedonic Attributes. Market research studies often refer to positive and negative rating measures using the Top/Bottom 2 Boxes & 3 Boxes percentages as indicators of consumer acceptance.

Special thanks to Mr. Thomas Carr who was instrumental in the development of the proper specifications for statistics that were incorporated in all Top/Bottom 2 Boxes & 3 Boxes reports. Some of these statistic specifications are discussed below.


Index of this Web Page:
  1. Print Screen of the Generated Excel Direct Report.
  2. Print Screen of the Generated Analysis Table - Ready for Sending to MS Word.
  3. Print Screen of Main Report Selection Form.
  4. Print Screen of Main Report Selection Form - Optional Hedonic Question Selection.
  5. Text Version of Analysis Table Report also showing with other selected options.
  6. Notes that will be available by Clicking the 'Notes' Button on Main Report Form.
  7. Example SAS Script file used to Generate the Top 2 Boxes Analysis Table.



1.   Print Screen of the Generated Excel Direct Report



2.   Print Screen of the Generated Analysis Table - Ready for Sending to MS Word.



3.   Print Screen of Main Report Selection Form.



4.   Print Screen of Main Report Selection Form - Optional Hedonic Question Selection.



SIMS software express package file: SCS-EXAMP1.SIMS2000ExpressPackage.sql.ZIP



4.   Text Version of Analysis Table Report also showing with other selected options.



SIMS:  Top 2 Boxes, Bottom 2 Boxes (Value) Analysis

Test Result Code: SCS-EXAMP1

Sample Definitions:
   S1 = Control Dessert
   S2 = Healthy Dessert
   S3 = Low Cal Dessert
   S4 = Low Fat Desset



Top 2 Boxes, Bottom 2 Boxes (Value)
Attribute                          S1        S2        S3        S4   P-val  Sig
============================ ========= ========= ========= =========  ====== ===

                                    a         b         a         b         
APPEARANCE LIKING T2          23(37%)    9(15%)   30(48%)   11(17%)   0.0001 ***

APPEARANCE LIKING B2            1(2%)     4(6%)     0(0%)     5(8%)   0.0620 NS

                                    b         a         a         ab        
SIZE JAR T2                     0(0%)     5(8%)    7(11%)     4(6%)   0.0257 *

                                    a         b         c         b         
SIZE JAR B2                   47(76%)   10(16%)     0(0%)    7(11%)   0.0001 ***

                                    b         b         a         b         
OVERALL LIKING T2             13(21%)   12(19%)   37(60%)    9(14%)   0.0001 ***

                                    a         ab        b         a         
OVERALL LIKING B2              8(13%)     4(6%)     0(0%)    7(11%)   0.0222 *

                                    b         b         a         b         
OVERALL FLAVOR LIKING T2      12(19%)   15(24%)   35(56%)    9(14%)   0.0001 ***

OVERALL FLAVOR LIKING B2       6(10%)     4(6%)     2(3%)     4(6%)   0.5185 NS

SWEET JAR T2                   8(13%)     4(6%)     3(5%)     3(5%)   0.1645 NS

                                    ab        b         c         a         
SWEET JAR B2                  30(48%)   28(45%)   15(24%)   40(65%)   0.0001 ***

                                    bc        b         c         a         
SOUR JAR T2                    6(10%)    7(11%)     0(0%)   17(27%)   0.0001 ***

SOUR JAR B2                   22(35%)   27(44%)   28(45%)   23(37%)   0.5862 NS

                                    a         a         b         a         
SALTINESS JAR T2              15(24%)   11(18%)     3(5%)   17(27%)   0.0013 **

SALTINESS JAR B2                3(5%)     5(8%)     2(3%)    6(10%)   0.3941 NS

                                    b         b         a         b         
OVERALL TEXTURE LIKING T2     11(18%)    6(10%)   29(47%)     3(5%)   0.0001 ***

                                    a         a         b         a         
OVERALL TEXTURE LIKING B2     12(19%)    9(15%)     1(2%)   10(16%)   0.0120 *

                                    a         c         c         b         
TENDERNESS JAR T2             41(66%)    9(15%)     4(6%)   20(32%)   0.0001 ***

                                    b         a         a         ab        
TENDERNESS JAR B2               3(5%)   16(26%)   14(23%)   11(18%)   0.0137 *

MOISTNESS JAR T2               6(10%)    9(15%)    6(10%)   13(21%)   0.1849 NS

                                    a         ab        c         bc        
MOISTNESS JAR B2              17(27%)   10(16%)     1(2%)    6(10%)   0.0002 ***

                                    a         b         a         b         
FILLING LIKING T2             24(39%)    6(10%)   22(35%)    6(10%)   0.0001 ***

                                    b         a         b         a         
FILLING LIKING B2               1(2%)   15(24%)     1(2%)   14(23%)   0.0001 ***

                                    c         a         b         a         
TEXTURE FILLING JAR T2         9(15%)   32(52%)   18(29%)   36(58%)   0.0001 ***

                                    b         a         b         b         
TEXTURE FILLING JAR B2          5(8%)   17(27%)     3(5%)     5(8%)   0.0001 ***

                                    b         b         b         a         
AMOUNT OF FILLING JAR T2       7(11%)   13(21%)   10(16%)   23(37%)   0.0014 **

AMOUNT OF FILLING JAR B2       6(10%)     4(6%)     1(2%)    6(10%)   0.1976 NS

                                    b         b         a         c         
AFTERTASTE T2                 32(52%)   38(61%)   50(81%)   21(34%)   0.0001 ***

                                    a         a         b         a         
AFTERTASTE B2                 24(39%)   15(24%)     4(6%)   22(35%)   0.0001 ***

                                    b         b         a         b         
OVERALL QUALITY T2            14(23%)   13(21%)   35(56%)    7(11%)   0.0001 ***

                                    a         a         b         a         
OVERALL QUALITY B2            38(61%)   35(56%)    8(13%)   42(68%)   0.0001 ***


------------------------------------------------------------

  Including Hedonic Attribute Details

    Hedonic Attribute Description(X1): APPEARANCE LIKING
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Like Extremely            (Ret value: 9)
            Label(2) = Like Very Much            (Ret value: 8)
            Label(3) = Like Moderately           (Ret value: 7)
            Label(4) = Like Slightly             (Ret value: 6)
            Label(5) = Neither Like nor Dislike  (Ret value: 5)
            Label(6) = Dislike Slightly          (Ret value: 4)
            Label(7) = Dislike Moderately        (Ret value: 3)
            Label(8) = Dislike Very Much         (Ret value: 2)
            Label(9) = Dislike Extremely         (Ret value: 1)


    Hedonic Attribute Description(X2): SIZE JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Big          (Ret value: 5)
            Label(2) = Somewhat Too Big      (Ret value: 4)
            Label(3) = Just About Right      (Ret value: 3)
            Label(4) = Somewhat Too Small    (Ret value: 2)
            Label(5) = Definitely Too Small  (Ret value: 1)


    Hedonic Attribute Description(X3): OVERALL LIKING
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Like Extremely            (Ret value: 9)
            Label(2) = Like Very Much            (Ret value: 8)
            Label(3) = Like Moderately           (Ret value: 7)
            Label(4) = Like Slightly             (Ret value: 6)
            Label(5) = Neither Like nor Dislike  (Ret value: 5)
            Label(6) = Dislike Slightly          (Ret value: 4)
            Label(7) = Dislike Moderately        (Ret value: 3)
            Label(8) = Dislike Very Much         (Ret value: 2)
            Label(9) = Dislike Extremely         (Ret value: 1)


    Hedonic Attribute Description(X4): OVERALL FLAVOR LIKING
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Like Extremely            (Ret value: 9)
            Label(2) = Like Very Much            (Ret value: 8)
            Label(3) = Like Moderately           (Ret value: 7)
            Label(4) = Like Slightly             (Ret value: 6)
            Label(5) = Neither Like nor Dislike  (Ret value: 5)
            Label(6) = Dislike Slightly          (Ret value: 4)
            Label(7) = Dislike Moderately        (Ret value: 3)
            Label(8) = Dislike Very Much         (Ret value: 2)
            Label(9) = Dislike Extremely         (Ret value: 1)


    Hedonic Attribute Description(X5): SWEET JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Strong      (Ret value: 5)
            Label(2) = Somewhat Too Strong  (Ret value: 4)
            Label(3) = Just About Right     (Ret value: 3)
            Label(4) = Somewhat Too Weak    (Ret value: 2)
            Label(5) = Much Too Weak        (Ret value: 1)


    Hedonic Attribute Description(X6): SOUR JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Strong      (Ret value: 5)
            Label(2) = Somewhat Too Strong  (Ret value: 4)
            Label(3) = Just About Right     (Ret value: 3)
            Label(4) = Somewhat Too Weak    (Ret value: 2)
            Label(5) = Much Too Weak        (Ret value: 1)


    Hedonic Attribute Description(X7): SALTINESS JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Salty               (Ret value: 5)
            Label(2) = Somewhat Too Salty           (Ret value: 4)
            Label(3) = Just About Right             (Ret value: 3)
            Label(4) = Not Quite Salty Enough       (Ret value: 2)
            Label(5) = Definitely Not Salty Enough  (Ret value: 1)


    Hedonic Attribute Description(X8): OVERALL TEXTURE LIKING
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Like Extremely            (Ret value: 9)
            Label(2) = Like Very Much            (Ret value: 8)
            Label(3) = Like Moderately           (Ret value: 7)
            Label(4) = Like Slightly             (Ret value: 6)
            Label(5) = Neither Like nor Dislike  (Ret value: 5)
            Label(6) = Dislike Slightly          (Ret value: 4)
            Label(7) = Dislike Moderately        (Ret value: 3)
            Label(8) = Dislike Very Much         (Ret value: 2)
            Label(9) = Dislike Extremely         (Ret value: 1)


    Hedonic Attribute Description(X9): TENDERNESS JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Tough/Chewy      (Ret value: 5)
            Label(2) = Somewhat Too Tough/Chewy  (Ret value: 4)
            Label(3) = Just About Right          (Ret value: 3)
            Label(4) = Somewhat Too Soft/Tender  (Ret value: 2)
            Label(5) = Much Too Soft/Tender      (Ret value: 1)


    Hedonic Attribute Description(X10): MOISTNESS JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Moist      (Ret value: 5)
            Label(2) = Somewhat Too Moist  (Ret value: 4)
            Label(3) = Just About Right    (Ret value: 3)
            Label(4) = Somewhat Too Dry    (Ret value: 2)
            Label(5) = Much Too Dry        (Ret value: 1)


    Hedonic Attribute Description(X11): FILLING LIKING
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Like Extremely            (Ret value: 9)
            Label(2) = Like Very Much            (Ret value: 8)
            Label(3) = Like Moderately           (Ret value: 7)
            Label(4) = Like Slightly             (Ret value: 6)
            Label(5) = Neither Like nor Dislike  (Ret value: 5)
            Label(6) = Dislike Slightly          (Ret value: 4)
            Label(7) = Dislike Moderately        (Ret value: 3)
            Label(8) = Dislike Very Much         (Ret value: 2)
            Label(9) = Dislike Extremely         (Ret value: 1)


    Hedonic Attribute Description(X12): TEXTURE FILLING JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Firm      (Ret value: 5)
            Label(2) = Somewhat Too Firm  (Ret value: 4)
            Label(3) = Just About Right   (Ret value: 3)
            Label(4) = Somewhat Too Soft  (Ret value: 2)
            Label(5) = Much Too Soft      (Ret value: 1)


    Hedonic Attribute Description(X13): AMOUNT OF FILLING JAR
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Much Too Much          (Ret value: 5)
            Label(2) = Somewhat Too Much      (Ret value: 4)
            Label(3) = Just About Right       (Ret value: 3)
            Label(4) = Somewhat Not Enough    (Ret value: 2)
            Label(5) = Definitley Not Enough  (Ret value: 1)


    Hedonic Attribute Description(X14): AFTERTASTE
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = A Strong, Pleasant Aftertaste    (Ret value: 5)
            Label(2) = A Mild, Pleasant Aftertaste      (Ret value: 4)
            Label(3) = No Aftertaste                    (Ret value: 3)
            Label(4) = A Mild, Unpleasant Aftertaste    (Ret value: 2)
            Label(5) = A Strong, Unpleasant Aftertaste  (Ret value: 1)


    Hedonic Attribute Description(X15): OVERALL QUALITY
          Hedonic Labels on Questionnaire are, by Seen Order in Label(n):
            Label(1) = Excellent  (Ret value: 5)
            Label(2) = Very Good  (Ret value: 4)
            Label(3) = Good       (Ret value: 3)
            Label(4) = Fair       (Ret value: 2)
            Label(5) = Poor       (Ret value: 1)





5.   Notes that will be available by Clicking the 'Notes' Button on Main Report Form.


 *****   SIMS:  Top/Bottom 2 Boxes & 3 Boxes - Basic Usage Notes   *****

  Purpose:
  --------

   The Top/Bottom 2 Boxes & 3 Boxes Report summarizes the extreme observations for Hedonic Attributes.
   Market research studies often refer to positive and negative rating measures
   using the Top/Bottom 2 Boxes & 3 Boxes percentages as indicators of consumer acceptance.

   Line Scales, new Top/Bottom Report support for Line Scales, effective update 2016. 
     Only those Line Scales which are Discrete Increments = 1 
     AND Max - Min  >= 4 (at least 5 categories) AND Max - Min <= 15 (looks like a category scale).
     The categories for Line Scales will be reported as the actual numeric values on your Line Scale. SIMS can't extract any captions.

   If you intend to use this report with your Hedonic Attributes, it is generally a good 
   idea to design your Questionnaire's Hedonic Attributes so that the return values assigned 
   to each Hedonic choice DESCEND from the top answer to the bottom answer.   The top answers 
   should be favorable (Like extremely, Like very much, etc.) while the bottom ones should 
   be unfavorable (Dislike extremely, Dislike very much, etc.).

   For Horizontal Hedonics, choices should DESCEND from the left answer to the right answer.
   The left answers should be favorable (Like extremely, Like very much, etc.) while the 
   right ones should be unfavorable (Dislike extremely, Dislike very much, etc.).

   The Top/Bottom 2 Boxes & 3 Boxes are commonly Ranked by the 'VISUAL' location of the Boxes, Top & Bottom.
           For Horizontal Hedonics,  Top 2 == Left 2  and  Bottom 2 == Right 2 

   The Top/Bottom 2 Boxes & 3 Boxes can also be Ranked by the Return 'VALUES' of the Boxes, High & Low.
           Top 2 == 2 Highest Return Values  and  Bottom 2 == 2 Lowest Return Values 

   If your Hedonic questions are already designed with Top/HighValue and Bottom/LowValue,
      the most common usage, then the report will produce same result with either rank option.

   Top/Bottom 3 Boxes follow same logic and notes.

   Top/Bottom 1 Box, and Middle 1 Box are used less often then T2/B2 & T3/B3.


   Here is an example:

      Using the scale below, how do you feel about the sample flavor?

      Like extremely 
      Like very much 
      Like slightly 
      Neither like nor dislike 
      Dislike slightly 
      Dislike very much 
      Dislike extremely 

        The values of each answer are assigned from 7 (Like Extremely)
            down to 1 (Dislike extremely).


   Your Report for Top 2 might look like this:

      Top 2 boxes
      Attribute		Sample 1		Sample 2		P-val	Sig

      Liking   		 9 (75%) 		 6 (50%)  		0.234	NS


      In this example Twelve respondents answered the question for each sample.
      Nine respondents (75%) selected either Like Extremely or Like very much 
      for Sample 1, while six (50%) selected either of those answers for Sample 2.


  Report Options:  
  ---------------
    Hedonic Attribute Selection.  By default, all Hedonic Attributes are included in report. 
      You have the option to select individual Hedonic Attributes, one, many, or all. 

    Include Statistics P-val & Significance - SAS Analysis
      This report option will include the superscripts, p-values, and significance levels
      as reported in normal Anova/(Duncan/LS) analysis for each of the hedonic attributes.

        SAS Analysis Specs:   (per B. Thomas Carr, M.S., Feb 2002) 
          Actual Attribute return data points are not exported to SAS, instead these actual
          values are compared with Top/Bottom 2 Values, and if inclusive then a data value
          of '100' is exported to SAS, otherwise a data value of '0' is exported to SAS.
          In other words, the SAS Data Sets, for each Hedonic question (X1-Xn),
            will always export either: 
                         a) 100,   b)0,   or  c).   ( . = null) 

          Top Two Boxes are defined as being the Top Two SEEN Boxes, Bottom is opposite. 


          Option: Use 'One-Way Model' Between Samples
              - Used in PROC GLM to calculate means and P-values based
                    on the Sample as the ONLY independent variable.
                    Otherwise the normal default independent variables are Judge and Sample (Two Variables).
              - When your Experimental Design is of the type n Samples Present 1, the One-Way
                    Model Between Samples may be an appropriate analysis option, especially
                    when there are different sets of respondents testing each sample.

                'One-Way Model'                          'Two-Way Model'
                 PROC GLM;                               PROC GLM;
                 CLASS SAMPLE;                           CLASS JUDGE SAMPLE;
                 MODEL X1-X10 = SAMPLE;                  MODEL X1-X10 = JUDGE SAMPLE;
                 MEANS SAMPLE / DUNCAN ALPHA = 0.05;     MEANS SAMPLE / DUNCAN ALPHA = 0.05;


  Column Designations Format Market Research
      - An alternative method sometimes utilized by Market Research professionals.
      - An alternative method for the analysis reporting 'Letters' for Mean Separations and Column Designation.
      - Within an Attribute row, a letter indicates the sample is significantly different than the designated column.
      - Column header for each Sample description is appended with an (a), (b), (c), (etc).
             Example:  Table Header:  S1 (a)   S2 (b)   S3 (c)  
                Attribute Sweetness:  S1       S2 (c)   S3 (b)  
                     Interpretation:  S2 and S3 differ, while S1 and S2, and S1 and S3 do not differ.

      - As a review, the above alternative MR method *differs* from the common sensory usage, which is:
           Where any two sample means that do not share a common letter will differ at some significance level.
             Example:  Table Header:  S1       S2       S3      
                Attribute Sweetness:  S1 (ab)  S2 (a)   S3 (b)  
                     Interpretation:  S2 and S3 differ, while S1 and S2, and S1 and S3 do not differ.


      - Option:  High Only, Column Designations Format Market Research
          Only shows the *higher value* cell for Each Pair which is significantly different.
          Within an Attribute row, a letter indicates the sample is significantly different *higher value* than the designated column.
             Example:  Table Header:  S1 (a)   S2 (b)   S3 (c)  
                Attribute Sweetness:  S1       S2 (c)   S3      
                     Interpretation:  S2 and S3 differ, S2 is higher value then S3, while S1 and S2, and S1 and S3 do not differ.


      - A more complex example, where all samples are significantly different from each other: 
                                    S1=38    S2=48    S3=42   P-Value=0.0001  ***   
             Common Sensory Usage:  S1 (c)   S2 (a)   S3 (b)   
                         MR Usage:  S1 (bc)  S2 (ac)  S3 (ab)  
               MR High Only Usage:  S1       S2 (ac)  S3 (a)  


    Include Hedonic Attribute Details
      This report option will include, for every Hedonic Attribute on your report,
      details about the Hedonic's  a) choice labels  b) Seen Order  c) actual return values
      Selecting this report option could add a few additional pages to your report.

    Include SAS Data Set Details
      This report option will include ALL the Hedonics SAS Data set Details, Actual and SAS.
      Selecting this report option could add a few additional pages to your report.

    Drop Counts, Show Only Percentages
      This report option will drop the count of panelists (n) who answered within the Top/Bottom 2 Boxes
      for each Attribute/Sample, and only display the Percentages of panelists.

    Include Means Rows
      Will include rows of mean score calculations for each Attribute/Sample.
      These are the means for *ALL* of the data, not just the Top/Bottom Boxes.

          Include Stats Mean Separations, p-values, and Sig:  
            If this option is desired, you need to run statistical analysis PRIOR to Top/Bottom Boxes, see SIMS Main Menu | Statistical Analysis.
            The values used for the extra Means Row are from the most previously performed statistical analysis.
            The mean separation letters will be displayed EXACTLY as it was from the most previous statistical analysis.
            The mean separation letters will appear next to the Mean in the Mean Rows, example 7.16ab

            Note about mean separation letters consistency, for the Tn/Bn stats and this optional Means Row: 
              Consistent options selections:  If you're selecting the option for:  Column Designations Format Market Research,
                it is quite likely that you will want the mean separation letter handling to be consistent.
                What statistical options did you select for this test in SIMS Main Menu | Statistical Analysis?  Be consistent.
                If in doubt, go rerun SIMS Main Menu | Statistical Analysis with your desired options.


  Report Destination Excel Direct:  
  --------------------------------
    Significant Cells Colors refers to row cells where the Significance Levels are either '*' or '**' or '***', typically 95% confidance or more.
    The separation letters will be lower case when Significance Levels are '*', and UPPER case when '**' or '***'.

    [ ] Include Columns P-val & Sig
             Example:  PVal = .001    Sig = " *** "

    [ ] Drop 'Bottom' stats
             Optionaly omit the Bottom 3 & Bottom 2 & Bottom 1 stats from appearing on the report.

    [ ] Merge/Rollup the Tn/Bn choices text
             Example:  5pt Overall Liking:   Like Very Much    Like Moderately    Neither Like nor Dislike    Dislike Moderately    Dislike Very Much  
             If not selected the minimal choice text label will be displayed;   Top 2 example:  Like Moderately
             If selected the Merge/Rollup choices text labels will be displayed;   Top 2 example:  Like Very Much/Like Moderately
             If selected SIMS will attempt smart text merge, where the 'common' ending choice text words for choices will not be repeated when possible.
                 Top 2 example:  Very satisfied , Quite satisfied  -- >  Very/Quite satisfied 


  Rounding Notes:  
  ---------------
    SIMS adheres to ASTM standards for Rounding Test Data. 

    ASTM E29-93a
      'Standard Practice for Using Significant Digits in Test Data
       to Determine Conformance with Specifications'.
     Clause 6.4 of E29 covers the rounding rules, which go beyond the 5/4 rule.

     Here is a brief summary: 
       - When the digit beyond the one you want to keep is less than 5,
             do not change the digit you are keeping.
       - When the digit beyond the one you want to keep is greater than 5,
             increase the digit you are keeping by 1.
       - When the digit beyond the one you want to keep is equal to 5, 
            And there are non-zero digits beyond it, increase the digit you are keeping by 1.
       - When the digit beyond the one you want to keep is equal to 5 exactly, 
            And the digit you are keeping is odd, increase the digit you are keeping by 1.
            If the digit you are keeping is even, keep it unchanged.
            (this odd vs even rule is also commonly known as the bankers rounding) 


  Viewing Analysis Files Notes:  
  -----------------------------
    Optionally use these files to review what occurred within SAS Statistics. 

    You can not Re Export/Analyze your TOP2/BOTTOM2 SAS file from Viewing Analysis Files,   
      because of the formatting and inclusion of means and percentages included on the final table.
      Analysis is only available from the Main Tab on TOP2/BOTTOM2 Analysis Screens.


  File Names:  
  -----------
    SAS Export/Import Files Names will be named similar to
      MyTestT2.* , MyTestB2.* , MyTestT3.* , MyTestB3.* , etc.  Or MyTestTBM.*
        where the T2 or B2 in file name indicates Top 2 or Bottom 2 Analysis.
        where the T3 or B3 in file name indicates Top 3 or Bottom 3 Analysis.
        where the T1 or B1 or M1 in file name indicates Top, Bottom, or Middle 1 Analysis.
        or TBM if multiple Top Bottom check box report options are selected. 
      File name will always start with the first SIX characters of your Result Code name,
        followed by the Tn Bn TBM which applies.


  Test Combine:  
  -------------
    Test Combine is not currently supported in the Top/Bottom reports of SIMS2000.
    It may be possible to combine manually with some time and effort.
      Export each test report individually to Excel.  Use one of the excel spreadsheets to manually edit.
      Are the Tests Sample numbers Static (2+2=2) or do they Increment Sequentially (2+2=4)?
        Static, manually combine the Top/Bottom frequencies, recalc the % percentages.
        Increment, manually copy-n-paste combine insert additional columns.
      SAS statistics, if needed for Top/Bottom p-value and mean separations.
        Combine the .dat files, copy/combine .dat file rows into one .dat file.
          Static, sample #s should already be aok, ex. 2+2=2
          Increment, some .dat file rows will need to have the sample #s corrected where needed, ex. 2+2=4
        Load and run .sas file using your local PC SAS program natively, i.e. not from SIMS2000.
          You may need to change the .dat file source name in the .sas file, see /*Read the Data*/ area.
        Manually locate p-values and mean separations letters from GLM SAS listing file output.