vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
Hi,
I have a SAS dataset in the below layout with 4 variables.
Code: |
DESCR SNAPSHOT1 SNAPSHOT2 SNAPSHOT3
======= ========= ========= =========
NAME WELLS WELLS WELLS
AGE 95 94 94
DISTANC 5 2
MASS 23 23 23 |
The requirement is to highlight cells in PROC REPORT or any other way, if there is a change in the value from the previous snapshot.
The number of SNAPSHOTS to compare and the number of ROWS are dynamic.
I am not sure of the logic to approach this requirement.
Could you please help me with the logic.
Example: in the 2nd row, The age value from SNAPSHOT2 is different from SNAPSHOT1, so the cell in SNAPSHOT2 has to be highlighted.
Required output:
The pointed cells needs to be highlighted.
Code: |
DESCR SNAPSHOT1 SNAPSHOT2 SNAPSHOT3
======= ========= ========= =========
NAME WELLS WELLS WELLS
AGE 95 94<--- 94
DISTANC 5 <--- 2<---
MASS 23 23 23 |
Please let me know if you need more information.
Regards, |
|