I can't help you with this error, but as you phrase it "I want to report", I suggest you direct this issue to SAS tech support. ... View more

If you set the Object Spawner's IOM.LoadBalancing logger to TRACE the Object Spawner log will provide detail on the cost algorithm's process. You can set this logger in SAS Management Console by right-clicking on the host under the Object Spawner and selecting "Connect", then under the loggers tab locate the logger "IOM.LoadBalancing" and double-click or right-click and select "Properties", then change it's setting from Inherited to Assigned: Trace. You can change this back after reproducing the behavior. ... View more

If you don't get a response then I recommend opening a TS track for this question. Please include the following: - SAS Version you are running (the following code will report SAS version information) %put &sysvlong ; %put &sysscpl ; %put &syssite ; - Registry Report (*.txt files) for each server, please clearly name the report files to reflect the server it was executed on. ... View more

OK, I'm sorry, I am out of my depth.  Your system's encoding may come in to play on this.  I naively suspect that the solution I linked to on Stack Overflow may have been using wlatin encoding but we have not established what encoding your system or DI uses, if it is different.      did you try the other suggestion? options missing="%sysfunc(byte(0))"; ... View more

Here is the list of supported formats:   https://go.documentation.sas.com/?docsetId=spdsug&docsetTarget=n08u8jpio1sk6cn1cl35oneuld85.htm&docsetVersion=5.4&locale=en   It does not appear that DDMMYYP is on the list. ... View more

The CPU cost of the query at the SQL Server side is not included here, only your SAS session. This note indicates that it took 3 mins (elapsed time) for SQL Server to execute the query, and a couple of seconds of CPU time for SAS to write the data back.         ... View more

2 other papers to look at about the Report Writing Interface, in addition to the papers that Reeza mentioned.   http://support.sas.com/resources/papers/proceedings14/1689-2014.pdf   http://support.sas.com/resources/papers/proceedings16/2240-2016.pdf   If a customer orders multiple items, you will need to keep track of how many can fit on a page. ... View more

You are most likely encountering the issue described in this SAS note: http://support.sas.com/kb/36/784.html   There are some workarounds depending on which scenario applies in your case. ... View more

What sort of engine is used by library VL00 ? SPDE ? ... View more

Please try this code %put %str(NOTE: Creating indexes in Parallel...); proc datasets lib = VL00 nolist; modify VL0004_005D_Employee_Sensitive (asyncindex=YES); index delete VL0004_004D_Employee_Sk ; index delete Employee_Id ; index delete Person_Id ; index create VL0004_004D_Employee_Sk ; index create Employee_Id ; index create Person_Id ; quit;   ... View more

70gb is perhaps a too large table to be handled by the standardised code from the transformation. Attach the log from the loader and a contents of the target table if you need further guidance. Be sure to set the msglevel=I system option, and assign sodswdeb=YES to get additional information about the processing. ... View more

How about using the following steps? 1.  Create two new datasets from Policy_Fact table by using Querybuilder.  The first dataset will contain two columns, pol_num_txt and Service_Tax.  Assign new column name, Amount, to Service_Tax.  The second dataset will contain two columns, pol_num_txt and Sales_tax.  Assign new column name, Amount, to Sales_tax.  So, you will have two identical datasets which have two columns, pol_num_txt and Amount.  The Amount column on the first dataset actually contains data of Service_Tax, and the Amount column on the second dataset actully contains data of Sales_tax.  See examples below. First Dataset                                                                                    Second Dataset pol_num_txt     Amount                                                                   pol_num_txt         Amount 101                   12                                                                           101                        8    102                   12                                                                           102                        8 103                   12                                                                           103                        8 2.  Open the first dataset and run Append Table.  Append Table is located under Data function.  Append Table enables you to concatenate the first dataset and second dataset.  After completing Append Table, sort the table by pol_num_txt. ... View more