Let's assume that your SAS datasets are already created. Download the SAS ODBC driver and install it. You could also use OleDb. Go into Word VBA, for now, and read an ODBC datasource. The SAS data will be available using a simple ODBC query. Loop through the data and write it to a figure/table/text/etc.   This is the entry method for doing this kind of work. As you progress, it is better to use C# and a 3rd party tool that handles Word (there are lots). That way, you can create Word documents w/o Word being on the machine. If you face a serious enterprise problem (like 10K worksheets a day), VBA doesn't cut it. Ultimately a docx is simply a zip file with XML documents in it. Open source libraries can read/write to them. SAS datasets are ODBC/OleDb compliant. You can read from them.    If you make it to that point, you can also submit SAS code from C#/VBA using SAS/Int Technologies. Then, SAS becomes a child process.  ... View more

Too often, the question is 'how to I get SAS to do XYZ?'. That implies a PUSH operation from SAS. turn the question on its head and ask how do I get my data, from SAS processing, into Word using a PULL operation. Execute and pull SAS from Word using a variety of techniques. I often execute SAS programs and retrieve the data w/o using anything more than SAS via Integration Technologies.   So, how do you do a PULL operation? Look at articles by Chris Hemendinger on VBA or C# doing it. Use Examples from Excel as well since they are very similar. i also have a complete example on gihub. (see: savian-net/ExcelSasDemo (github.com)) for Excel. If you will be using Word, just use the COM dll for Word.   A PULL operation takes a bit of time to get used to but it is, by far, the most powerful way to use SAS and Microsoft products together. Every feature of Microsoft is available as well as SAS. A PUSH operation does not have that advantage. ... View more

C# isn't bad. You should try it a bit and see how it goes.   Alternatives would be something like PowerShell to automate the rename. Pretty easy to use. Any other language, such as Python, can also be used. Get the files in a dir, loop through them, renaming and saving out. ... View more