We have a unique PDF format for our Bill copy that needs to be generated using dynamic data from a table. We are looking to create a complete end-to-end project and would appreciate your suggestions on the best ways to create a solution for this project.
Your very general question can only be answered with very general answers.
You read the dynamic data into SAS, then you use SAS to write to a PDF file in the desired format.
I also suspect that there are tools other than SAS that would be better for this task, but I have no idea what those other tools would be. You might want to ask companies that create bills what they use.
The ODS Report Writing capabilities provide granular access to building reports and tables that are data driven. See this paper for examples and also the SAS documentation.
It may be more than you need, but using these techniques you can create very customized PDF output that has the content you want.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.