topic Combine more than 100 rtf files in one rtf file using SAS studio in SAS Programming

Combine more than 100 rtf files in one rtf file using SAS studio

Amine_Khemiri — Fri, 01 Dec 2023 11:44:35 GMT

I would like to combine 100 rtf files in one rtf file using SAS studio.

Thanks for your help.

Re: Combine more than 100 rtf files in one rtf file using SAS studio

A_Kh — Fri, 01 Dec 2023 13:39:22 GMT

Are you creating those 100 rtf files in sas? If yes, then what is your code to create those files?

Re: Combine more than 100 rtf files in one rtf file using SAS studio

Amine_Khemiri — Fri, 01 Dec 2023 14:27:42 GMT

Yes, I have different SAS codes that create 100 rtf files. Now, I want a code to combine all 100 files into 1 single rtf file.

Re: Combine more than 100 rtf files in one rtf file using SAS studio

ballardw — Fri, 01 Dec 2023 15:42:09 GMT

Not really a SAS job to combine already existing files.

If you created them from SAS then the proper way is to create ONE file instead of 100s. Easy to do in theory: wrap all of the output creating steps that write to the RTF in single ODS RTF call:

Dummy code:

Ods rtf file="<path>\bigfile.rtf" <other rtf options>;

<first proc step that creates output>
<second proc step that creates output>
<repeat until last proc step that creates output>

ods rtf close;

Or create the output and use Proc document to gather all the output together for the rtf output.

If you have "different sas codes" you could use %include to call separate SAS files but you would want to remove the specific ods rtf output/close in any of them to use the above approach.

Re: Combine more than 100 rtf files in one rtf file using SAS studio

A_Kh — Fri, 01 Dec 2023 16:29:26 GMT

In this case, you should put all your codes inside a single ODS RTF sandwich as suggested in previous comments. See additional comments here.

Re: Combine more than 100 rtf files in one rtf file using SAS studio

Reeza — Fri, 01 Dec 2023 17:27:40 GMT

If you search on here, there's a few examples, each solution having pros/cons.

Example:
https://communities.sas.com/t5/SAS-Programming/Combine-multiple-RTF-files-to-one-file/m-p/807239

Re: Combine more than 100 rtf files in one rtf file using SAS studio

Amine_Khemiri — Fri, 01 Dec 2023 21:08:20 GMT

Dear All,

Please note that I found a macros that is combining multiple rtf file in one single rtf file and it works very well.

https://www.bioinfo-scrounger.com/archives/combine_rtf/?fbclid=IwAR0i-lugw5FT-w_nOcTbEfJ5lh6qpBLf0HW2WbFnA40s7yupahS7kku6JSk

Thanks.

Kind regards,

Amine