topic Re: SAS and PowerPoint in SAS Programming

SAS and PowerPoint

Onizuka — Mon, 17 Jun 2019 12:09:42 GMT

Hello !

Is it possible to "merge" multiples PowerPoints ?

I have many powerpoints with only one slide and I would like to have only one powerpoint.

Exemple :

PowerPoint 1 : 1 slide A

Powerpoint 2 : 1 slide B

PowerPoint 3 : 1 slide C

==> PowerPoint 4 : 3 slides, A, B, C

It's like a "open the files you need, copy the slides and paste them into a new powerpoint, save and close"

Is it possible with SAS ?

Thank you !

Onizuka

Re: SAS and PowerPoint

Onizuka — Mon, 17 Jun 2019 14:31:47 GMT

No one have any idea ?

Re: SAS and PowerPoint

Reeza — Mon, 17 Jun 2019 15:13:53 GMT

Not directly from SAS, but you can call VBS from SAS.

Re: SAS and PowerPoint

Onizuka — Tue, 18 Jun 2019 07:13:41 GMT

@Reeza wrote:
Not directly from SAS, but you can call VBS from SAS.

Thank you for your answer Reeza !

A VBA macro already exist and do what they (collegues) want but it seem that it's very long in time to produce 8500 reports ^^

So I look if there were other ways in R or SAS to run it more efficiently !

Thank you again

Re: SAS and PowerPoint

Reeza — Tue, 18 Jun 2019 14:58:41 GMT

My question would be why do you have so many files? Is there a way to change that in some other step?

Re: SAS and PowerPoint

Reeza — Tue, 18 Jun 2019 15:02:17 GMT

And VBS is not VBA, so it's possible it's faster. I've done this with Excel and Word files before without any noticeable speed issues, about 5000 docs in under 5 minutes.

Re: SAS and PowerPoint

Onizuka — Fri, 21 Jun 2019 09:41:01 GMT

Hello @Reeza !

Well, it was for a collegue but they will keep the same method. I'm just an internship haha and I don't know VBS but i have telled them that it exist !

Thank you for your answer 🙂

Onizuka