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. 🙂

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
  • 1815 views
  • 2 likes
  • 2 in conversation