When I create and submit batch on remote server in succession, it gets submitted and the log is generated error free. But when I submit the same batch again after few minutes, it is giving me the below error in log file:-   ERROR: File is in use /backup/adhoc/batchtest007.sas. ERROR: Errors printed on page 1. Also, when I checked on the server, there is a process "sasels" active(please see attachment) which needs to be killed to submit the batch successfully. Please suggest me a method to remediate this.   ... View more

I am creating and running batch by submitting to the Unix server. When I do them in succession, everything works fine and no error gets recorded in the log but if I try to remote submit the same batch after some time, I get the below error in the log:-   ERROR: File is in use, /backup/adhoc/batchtest007.sas. ERROR: File is in use, /backup/adhoc/batchtest007.sas. ERROR: Errors printed on page 1. Although, the files aren't open anywhere. By checking on UNIX server, I found that a "sasels" process is active(please see attached) which is causing this problem. If I kill the process, the batch gets submitted and the log is generated error free.Please suggest a method to remediate this. ... View more

Hi,   I have macros string1, string2, string3 declared and initialized in code and I want to send the control to a labeled section which will put them in a message box. However, the do loop in the message box is unable to retrieve the value of macro variable by using the statement:- commandlist=insertc(commandlist,string!!i,i); here is the main part of the code:- %let string1; %let string2; %let string3; %let n; if anyspace(selpath) then do; string1="Path Should Not Contain Blank Spaces"; string2="select another path"; n=1; link errormsg; tmp_lstbtn._cursor(); return; end; errormsg: commandlist=makelist(); do i=1 to n; commandlist=insertc(commandlist,string!!i,i); end; command=messagebox(commandlist,'S','O',"ERROR: Header Generator"); commandlist=dellist(commandlist); return;  Please suggest a method to get the string values iteratively so that it could be inserted int he list. ... View more

Hi,   I have a small utility coded in SAS which is used to open and modify SAS files as per the needs of programmer. These SAS files are present on a network drive which could also be mapped to the local drive. The problem I am facing is, the UNC path of selected SAS file doesnt resolve but instead drive letter comes up in the absolute path of the file. For eg. If I've mapped \\mrllogon\system\phases\tools to drive W, I am getting path as W:\adhoc\programming instead of \\mrllogon\system\phases\tools\adhoc\programming. Please suggest a method to resolve this drive paths in Base SAS. ... View more

Hi,   I have SAS 9.1.3 , 9.3 and 9.4(all three of them) installed on my Unix server. So I have an application which is used to submit batch programs to the remote SAS. Also, I can signon to any of the three versions and submit a batch to any of the three SAS version on the same UNIX server. To choose the version I want to sumbit my batch on, I have given a radiobox control which has which has 3 radio buttons(See attached).   To get the above submission, I am using the following code:-     /* macro "sysver" gives the version of SAS currently connected to and sasver refers to the server I want to submit batch on, based on which certain flags are getting modified*/ %if "&sysver"="9.1" and "&sasver"="sas93" or "&sasver"="sas94" %then %let flag_reset=1; %else %if "&sysver"="9.3" or "&sysver"="9.4" and "&sasver"="sas" %then %let flag_reset=2; %else %let flag_reset=0; /* To submit batch from a lower version to higher, I am including TKPATH variable and assigning it an empty string which will be later set to the tkpath*/ %if &flag_reset=1 %then %do; %let tkpath=%sysget(TKPATH) ; options set=TKPATH "" ; %end; So when I am signed on to SAS 9.3 or 9.4,I am getting a warning message as below:-     WARNING: The argument to macro function %SYSGET is not defined as a system variable. Even if the statment (below) is inside a conditional construct which is never getting executed, it is prompting me the above warning message. %let tkpath=%sysget(TKPATH) ;   Please suggest a method to either remediate this or get rid of the warning message. ... View more

Hi, I am using a SAS code which have macros within a macro. When I execute this, the output is not getting transferref to the .lst file(which contains the output of the print proc). All I get is an empty .lst file. Please refer the code below:-   proc printto print="&protpath/outlist/program_d.lst" log ="&protpath/outlog/program_d.log" new; run; %macro program_d(callid=); %put ; %put -----------------------------------------------------------------------------; %put --- Start of %upcase(&sysmacroname) macro ; %put --- callid=&callid ; %put -----------------------------------------------------------------------------; %put ; %local report_name; %let report_name=&sysmacroname; %*** Bring in global report macro parameters and perform other global functions. ****; %infrastructure2(report=&report_name,callid=&callid); %if &_err_flag=Y %then %goto exit; data class1; set sashelp.class; run; %macro meann(datain=); proc means data=&datain median min max ; by sex; var Age Height Weight ; run; proc print data=&datain; title "Is datain in the list file"; run; %mend meann; %meann(datain=class1); %rtfsymbl(groups=_ALL_); %exit: %if "&debug"="N" %then %wrapup; %put; %put ---End of %upcase(&sysmacroname) macro; %put; %mend program_d; %program_d(callid=001); proc printto; run; ... View more