BookmarkSubscribeRSS Feed
SMohanReddy
Obsidian | Level 7

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.

2 REPLIES 2
ballardw
Super User

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?

Cynthia_sas
SAS Super FREQ

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

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1121 views
  • 0 likes
  • 3 in conversation