I am trying to load a MS-SQL server table to CAS via Proc Casutil Load. The table has more than 100000 records with 2 columns of type NVARCHAR(MAX) which are really big string variables. The load table takes around 4hrs to complete. My environment has 5 worker nodes each of 1TB.   What are the options I have to speed up the load ? ... View more

SAS VI Indexer - Performance improvement and API return   Hi   I am triggering SVI Indexer via API call from batch mode.   1. The API indexer takes a lot of time for indexing all entities and the time increases each day with new data load. How can I fine tune the performance ? Any guide on implementing Incremental Indexing ?   2. Is there any way to capture when the indexing triggered via API call is complete, it would be helpful to trigger next job. Currently I am just using sleep function to hold the next job. ... View more

I have SQL Server table with columns of type varchar(max) and they hold values > 32767. How can i read the complete column in varchar(*) column using SAS V9 or SAS Viya ? ... View more

Hi    I am trying to do bit testing. It works when I write it as a data step but fails if i wrap it inside a macro. What am i missing here ? Below is the simple code. The one in bold works but the one in red doesn't.   options symbolgen mlogic mprint; %macro test; %let a = 4096; %let b= '1............'b; data a; %if &a =&b %then %do; x=10; %end; run; %mend; %test; proc print data=a; run;   %let a = 4096; %let b= '1............'b; data a; if &a =&b then do; x=10; end; run; proc print data=a; run; ... View more

Hi   Currently my client has VA 7.3 installed and while we plan the upgrade to VA 7.5, in the meantime client wants SAS 9.4 M6 patch to be deployed. Wanted to check if the upgrade to M6 will have any issues with VA 7.3. Will the upgrade even work or it is mandatory to have VA 7.5 ?   Thanks for your help.     ... View more

Hi   I am getting below error while opening a report. Kindly provide a solution to fix this.    FaultEvent fault IRPC Fault faultSting-java lang RuntimeException Report could not be opened. Cause: Premature end of file. (Reason Report Cannot Be Read) : java.io.lOException: Error occurred during attempt to read a report from input stream Exception: Premature end of file. (Reason Report Cannot Be Read) faultCode-"Server Processing" faultDetail-nullT messageld-"8D339466-3A08-51AC-07B8-90B140BC3BC1 type-'fault"bubbles-false cancelable-true eventPhase-2]  ... View more