Hi, I have a problem with the assigment to a value. Thank you so much!     TABLE A:  Categorical Variable + Cumulative (from 0 to 1)   VAR_A_1     VAR_A_2 A                    0,5 B                    0,7 C                    0,9 D                    1   TABLE B: Categorical variable + Random Variable (from 0 to 1)   VAR_B_1     VAR_B_2 X1                 0,43 X2                 0,76 X1                 0,98 X1                 0,23       TABLE C: Result from table B : Categorial Variable, Random Variable, from Table A: Categorical variable that corresponds to the upper of the class within which is the value of VAR_B_2 VAR_B_1     VAR_B_2           VAR_A_1     VAR_A_2       X1                 0,43                    A                        0,5  X2                 0,76                    C                        0,9 X1                 0,98                    D                          1 X1                 0,23                    A                        0,5      I tried with 2 Macros but is very slow because Table A and Table B are very long. I thought to use formats but do not know how.   Thank you   ... View more

Hi, I Have this problem with SAS Visual Analytics 7.2 in a crosstab   Situation: Category Group   Month January January February February Category Month   Group Contact Sell Contact Sell Measure Contact   Group1 10 4 7 2 Measure  Sell   Group2 15 5 8 3     Situation Desired Category Group   Month Contact Contact Sell Sell Category Month   Group January February January February Measure Contact   Group1 10 7 4 2 Measure  Sell   Group2 15 8 5 3 ... View more