It depends on how did you create a process flow. Sometimes design one process is not ideal. You can create separate process flows and include conditional processes in it. Exporting to code and run batch job is also a solution but if team can not handle this think about multiple process flow's input and output datasets could be run sequentially? Also process flow run starts at first icon on top and next below. So create good labeled tasks and process flow and follow submission status menu to outputs time and completion status. Best. Kemal. ... View more

Thank you to everyone for the suggestions and support.  We have a process in place and are testing it now.  ... View more

Thank you Rachael for responding. I actually was looking for within the Dataflux process how to create a worksheet that contains multiple tabs containing data on output.  I found that due to how our admins set up our dataflux the option isn't available on our server so I've found the solution using SAS programming.  Thanks again for responding, but at this time I am all set.   ... View more

Thank you Rachel, this is very helpful.  ... View more

Thank you. ... View more

If you are using DMP Server 64 bit for Windows, I assume you'll need to install the Microsoft Excel 64 bit driver on your server box. If you are using DMP Server on another platform, then I believe that the Excel driver is not available. Note that SAS does not support any drivers except for the DataFlux drivers that are shipped with the product. You might consider outputting to CSV files rather, and then pulling them all into a xlsx on separate sheets. You may be able to automate this with a vb script (outside the DMP product). I did a search on "import multiple csv files to excel sheets" and it looks like there are some solutions out there. ... View more

This seems a bit complex to be diagnosed in the forum. I think you'd need a join, and probably match codes for each of your addresses, but I'd to see the current job and maybe a sample of how your data is stored to be sure. Are you able to send any of this here? If not, I'd suggest opening a ticket with Technical Support by email at support@sas.com.   Thanks, Audrey ... View more

I made the modifications to your file (the entire line needs to be deleted). It will have a small impact on the performance, for all the jobs - we haven't enabled a DEBUG or TRACE level of logging, so the impact should be minimal.   Let me know if this helps. Audrey   ... View more

Not an Oracle expert, but it sounds like you need to increase the number of sessions alter system set processes=200 scope=spfile; alter system set sessions=250 scope=spfile; ... View more

One thing that may help: find where your are using the word TEXT in your program. It appears to be used in a place it is not valid and apparently wants a different value for a DBMS option.   I might guess that you are also attempting to connect to Quickbooks. You may not have installed or configured the ODBC driver properly. ... View more

Hi,   In Data Management Studio, you can use the Parsing node (under Quality) with the Address (Full) definition. This requires a Quality Knowledge Base. https://support.sas.com/downloads/browse.htm?fil=&cat=540     Hope this helps.   Audrey ... View more

Hi   No issue. There is not really that much to get. The expression language is quite powerful for doing row by row operations, or through group of rows (clusters). Arrays can of course 'live" over multiple rows, therefore you can add whatever into as a temp table. https://documentation.sas.com/doc/en/engelref/2.8/p1hmnxhrls0dsen1o5ga29unjrxe.htm https://documentation.sas.com/api/docsets/engelref/2.8/content/engelref.pdf?locale=en   ... View more