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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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