Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SAS - highlight cells in ODS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1522
Location: Chennai

PostPosted: Mon Jan 18, 2016 11:43 pm    Post subject: SAS - highlight cells in ODS
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    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SAS cells within a output report vasanthz All Other Mainframe Topics 6 Thu Aug 14, 2014 11:48 pm
No new posts How to highlight only a certain secti... Akshay Pande CICS 2 Fri Dec 28, 2012 1:13 am
No new posts DB2 Trimming option - highlight trimm... vina2010 DB2 6 Wed Apr 25, 2012 4:27 am
No new posts color, highlight option not working chanti CICS 6 Sat Jan 23, 2010 11:03 pm
No new posts How to highlight a field in a Map ? Devindra Pratap Singh CICS 1 Sat Dec 26, 2009 4:47 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us