BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
akash1088
Obsidian | Level 7

Hi All,

I want to create a ppt in which i want to show a numbers on conditions that if the number is greater than zero than that i have to display that number inside Arrow:Up like shape and if the number is less than zero than we have to show that number in down arrow shape.

Is there any way to do this ?

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

I don't think you can do this with the ODS Powerpoint engine.

However, what you can do is have a template, and then modify it to your liking:

- Just open the PPTX file as a ZIP file with SAS.

- In that ZIP file, you'll find the slides.

- Microsoft's XML is very ugly, but if you saved the template with a down arrow containing the text "TEMPLATE TEXT", you'll find these two elements (arrow and text) in the slide file.

- You can modify these 2 elements and save the file again.

 

 

Capture.PNG

View solution in original post

4 REPLIES 4
ChrisNZ
Tourmaline | Level 20

I don't think you can do this with the ODS Powerpoint engine.

However, what you can do is have a template, and then modify it to your liking:

- Just open the PPTX file as a ZIP file with SAS.

- In that ZIP file, you'll find the slides.

- Microsoft's XML is very ugly, but if you saved the template with a down arrow containing the text "TEMPLATE TEXT", you'll find these two elements (arrow and text) in the slide file.

- You can modify these 2 elements and save the file again.

 

 

Capture.PNG

akash1088
Obsidian | Level 7

can you please share your code?

akash1088
Obsidian | Level 7

Sir you are legend.
Its work.
Thanks a lot.

 

ChrisNZ
Tourmaline | Level 20

Good on you for giving it a go and finding the coding syntax. 🙂

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 4 replies
  • 1566 views
  • 2 likes
  • 2 in conversation