I have two columns in SAS (Current ranking, previous ranking). IF the difference (Previous-current) ex: 5 (P) -1 (C) =4 between the two columns in postive, then an arrow mark (Green) poing upwards show and then if it is negative, red color arrow downards, if the difference is zero then yellow arrow (pointing 180 degrees). could you please provide a code or any source I can exactly look into.
1) On this forum please only post a question in one place. If it should be in another section someone will usually provide some hints and which section to post in.
Are you writing a report? Which procedure have you attempted to use?
Can you provide a screen capture of what you want this to look like as this request may be interpreted in several ways.
Also, what is the destination? Data set (not going to happen), html, rtf, pdf, Excel?
HI:
The posting was answer (with code) here https://communities.sas.com/message/233901#233901. To reinforce what Ballardw recommended -- it is not a good idea to post this in 2 places. Because your report uses images (like arrows) in a tabular report, the correct place to post this question was the ODS and Reporting forum. And an answer has been posted there.
cynthia
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.