IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SAS - highlight cells in ODS


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Mon Jan 18, 2016 11:43 pm
Reply with quote

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,
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts SAS cells within a output report All Other Mainframe Topics 6
No new posts How to highlight only a certain secti... CICS 2
No new posts DB2 Trimming option - highlight trimm... DB2 6
No new posts color, highlight option not working CICS 6
No new posts How to highlight a field in a Map ? CICS 1
Search our Forums:

Back to Top