All the macros are compiled and created catalogs using SAS 9.4 M1. We have different environments like Development, Validation and UAT. The error is occurring only in UAT environment. If I execute the same as sequentally, error is not coming. I am wondering because it is happening only one environment. ... View more

I have a question regarding looping of resubmit blocks. I want to submit 30 programs parallel. Which one will be the best way to do rsubmits. A. Writting 30 individual rsubmits B. Looping rsubmits %macro loop; Preprocessing like enabling sas sessions on grid and autosignon option and etc; Do i= 1 to n; Rsubmit task&i wait=no; Some sas program....; End rsubmt; Waitfor _all_; Some sas program; Signoff _all_; %mend; %loop; Or Rsubmit task1 wait=no; Some program; End rsbmit; .... Rsubmit task30 wait=no; Some program; End rsbmit; ... View more

Thank you JuanS_OCS. I also felt the same.    I have general question, Any way to submit the jobs only to particular grid node. We have four Grid nodes, I want to submit the rsubmit blocks to only one Grid node. ... View more

I am not authorized to run the commands. I asked to know that if any thing available or not? .   Mainly I am looking programmatic way to know the find the inactive grid server and available Free memory of the server. ... View more

Hi  JuanS_OCS, Thanks for the reply. We are not using the EG UI for submitting the SAS jobs. In this Scenario I can not event configure the (HA)  and I can't check the logs of the spawners.  I have another question, Is there any way to find the allocated memory and available free memory a server (Grid node) grammatically or by commands?. ... View more

Thanks to all. that is true. I shall try the same.    I have another question, How can I access work libraries across the grids and local machine, without defining the same location for all servers work libraries?.   1. Local work library in Remote machine. 2. Remote work library in Local machine 3. One Remote work library in another remote machine ... View more

I have mstored compiled macro catalogs in the location "\\C:shared". each macro do different functionality (like, ISO date conversion, formats creation, some calcuctions etc.)   I have some 20 programs available in another location "\\C:Programs".   Now i need to write a macro which can run programs (available in "\\C:Programs"). some times i have to use macro catalogs which are available in  "\\C:shared" location (means, need to call those macros in rsubmit blocks).   Example code: %let rc = %sysfunc( grdsvc_enable(_all_, server= SASApp_DEV)); options autosignon; filename testlib "C:\Users\yanamadalavenkatesh\Desktop\SAS Parallel Execution\Rsubmit"; libname shared "%sysfunc(pathname(testlib))"; rsubmit grid1 wait=no inheritlib=(shared) /*NOTIFY=YES*/ log=logfil; %formatds;  **Catalog is available in  \\C:shared location; %include "\\C:Programs\dm.sas"; endrsubmit;   rsubmit grid2 wait=no inheritlib=(shared) /*NOTIFY=YES*/ log=logfil; %isodt;  **Catalog is available in  \\C:shared location; %include "\\C:Programs\lb.sas"; endrsubmit;   My question is, how can I use those catalogs (Means, How can i call those macros) in RSUBMIT blocks. Can you provide the sample code for the same. ... View more

below is the sample code i am using, I want to call the macro (%xyz) in all rsubmit blocks. Now i am getting the WARNING: Apparent invocation of macro XYZ not resolved error when i use in RSUBMIT blocks. how can i call the macro without write the macro in RSUBMIT blocks.     %let rc = %sysfunc( grdsvc_enable(_all_, server= SASApp_DEV)); /*signon grid1;*/ /*signon grid2;*/ options autosignon; filename testlib "C:\Users\yanamadalavenkatesh\Desktop\SAS Parallel Execution\Rsubmit"; libname shared "%sysfunc(pathname(testlib))"; filename logfil "C:\Users\yanamadalavenkatesh\Desktop\SAS Parallel Execution\Rsubmit\ab.log" mod; filename logfil1 "C:\Users\yanamadalavenkatesh\Desktop\SAS Parallel Execution\Rsubmit\cd.log" mod; filename logfil2 "C:\Users\yanamadalavenkatesh\Desktop\SAS Parallel Execution\Rsubmit\ef.log" mod; %macro xyz; data shared.ABC; do i= 1 to 100000; update =rand('Uniform'); end; run; %mend xyz; rsubmit grid1 wait=no inheritlib=(shared) /*NOTIFY=YES*/ log=logfil; data shared.AB; do i= 1 to 100000; update =rand('Uniform'); end; run; %xyz; %put &syshostname; endrsubmit; rsubmit grid2 wait=no inheritlib=(shared) log=logfil1 ; data shared.CD; do i= 1 to 100000; update =rand('Uniform'); end; run; %put &syshostname; endrsubmit; rsubmit grid3 wait=no inheritlib=(shared) log=logfil2 ; data shared.EF; do i= 1 to 100000; update =rand('Uniform'); end; run; %put &syshostname; endrsubmit; ... View more