Hello everyone: I'm writing a task and one of the objects (daterange) returns a couple of dates to two macro variables. I can read these two variables properly to a table with the following code: options locale=English_UnitedStates; %let d1 = February 24, 2003; data test; dd = input("&d1", nldate200.); run; But I can't read read the date in the macro variable and save it in another one with the format I need (date9. would ideal). I have tried the following, but it doesn't work. options locale=English_UnitedStates; %let d1 = February 24, 2003; %let d2 = %sysfunc(inputn("&d1", nldate200.), date9.); %put &d2; Any help is appreciated. ... View more

Hello everyone:   I am trying to send a parameter from the main local session to other sessions I am opening to execute in parallel. The program of the example works without the %syslput lines, but as soon as I add these lines I get the following error:    85 signon mySess1 sascmd="!sascmd" signonwait=no; NOTE: Background signon to MYSESS1 in progress. 86 signon mySess2 sascmd="!sascmd" signonwait=no; NOTE: Background signon to MYSESS2 in progress. 87 88 %syslput macrovar1 = &macrovar / remote=mySess1; ERROR: A link must be established by executing the SIGNON command before you can communicate with MYSESS1. 89 %syslput macrovar2 = &macrovar / remote=mySess2; ERROR: A link must be established by executing the SIGNON command before you can communicate with MYSESS2. 90 91 rsubmit mySess1 wait=no; 92 93 rsubmit mySess2 wait=no; This is the example program:   %let macrovar = outside; signon mySess1 sascmd="!sascmd" signonwait=no; signon mySess2 sascmd="!sascmd" signonwait=no; %syslput macrovar1 = &macrovar / remote=mySess1; %syslput macrovar2 = &macrovar / remote=mySess2; rsubmit mySess1 wait=no; data multitask1; x = 1; run; endrsubmit; rsubmit mySess2 wait=no; data multitask2; x = 1; run; endrsubmit; waitfor _all_; signoff _all_; Any idea of what the problem might be? ... View more

Hello everyone:   I'm preparing a script so execute several tasks in parallel on one server. My first step is to execute the following code:   signon mySess sascmd="!sascmd"; rsubmit mySess; data test; x = 1; run; endrsubmit; signoff mySess; When I do, I get the following log (everythin is OK). 83 signon mySess sascmd="!sascmd"; NOTE: Remote signon to MYSESS commencing (SAS Release V.03.05M0P111119). NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software V.03.05 (TS5M0 MBCS3170) Licensed to EGP- SAS X ADVANCED ANALYTICS / ESP ON VIYA, Site 70237841. NOTE: This session is executing on the Linux 3.10.0-1160.15.2.el7.x86_64 (LIN X64) platform. NOTE: Analytical products: SAS/STAT 15.1 SAS/ETS 15.1 SAS/OR 15.1 SAS/IML 15.1 NOTE: Additional host information: Linux LIN X64 3.10.0-1160.15.2.el7.x86_64 #1 SMP Thu Jan 21 16:15:07 EST 2021 x86_64 Red Hat Enterprise Linux Server release 7.9 (Maipo) NOTE: SAS initialization used: real time 0.04 seconds cpu time 0.04 seconds NOTE: AUTOEXEC processing beginning; file is /opt/sas/viya/config/etc/compsrv/default/autoexec.sas. NOTE: DATA statement ha utilizado (Tiempo de proceso total): real time 0.00 seconds cpu time 0.00 seconds NOTE: AUTOEXEC processing completed. NOTE: Remote signon to MYSESS complete. 84 rsubmit mySess; NOTE: Remote submit to MYSESS commencing. 2 data test; 3 x = 1; 4 run; NOTE: The data set WORK.TEST has 1 observations and 1 variables. NOTE: DATA statement ha utilizado (Tiempo de proceso total): real time 0.00 seconds cpu time 0.01 seconds NOTE: Remote submit to MYSESS complete. 85 signoff mySess; NOTE: Remote signoff from MYSESS commencing. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.05 seconds cpu time 0.05 seconds NOTE: Remote signoff from MYSESS complete. 86 87 %studio_hide_wrapper; 98 99 Now I add a libname statement in order to access to tables in it (this lib exists and I use it in other scritps): signon mySess sascmd="!sascmd"; rsubmit mySess; libname emibal cas caslib=BAL_EMISIONES; data test; x = 1; run; endrsubmit; signoff mySess; and I get the following message in the log (I omit the first part because it's the same):   84 rsubmit mySess; NOTE: Remote submit to MYSESS commencing. 1 libname emibal cas caslib=BAL_EMISIONES; ERROR: The request to start or connect to a session failed. Specify a UUID to connect to an existing session or specify a session name, port and host name to start a session. ERROR: Error in the LIBNAME statement. 2 data test; 3 x = 1; 4 run; NOTE: The data set WORK.TEST has 1 observations and 1 variables. NOTE: DATA statement ha utilizado (Tiempo de proceso total): real time 0.00 seconds cpu time 0.00 seconds NOTE: Remote submit to MYSESS complete. 85 signoff mySess; NOTE: Remote signoff from MYSESS commencing. NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 0.13 seconds cpu time 0.07 seconds NOTE: Remote signoff from MYSESS complete. 86 87 %studio_hide_wrapper; 98 99 I am not still accessing any data in that lib, but I already get an error. Do you know why this might be happening?   Thanks.   ... View more

I have written the following test code. The goal is to send an e-mail with the content of some variables which my contain any character (in this example, an &):   %macro WriteInLog(Text1, Text2); data _null_; %put "Text1 is &Text1"; %put "Text2 is &Text2"; run; %mend WriteInLog; %macro SendMail(Text1, Text2); filename msg email to = "moretest@sas.com" from = "test@sas.com" subject = "Test mail"; data _null_; file msg; put "Text1: &Text1"; put '0D0A'x; put "Text2: &Text2"; run; %mend SendMail; data test; Text1 = 'Test'; Text2 = 'Text&MoreText'; run; data _null_; set test; call execute(cats('%WriteInLog(',Text1,',%nrstr(',Text2,'))')); call execute(cats('%SendMail(',Text1,',%nrstr(',Text2,'))')); run; The execution of the macro WriteInLog shows no error and the following text in the log, as expected: "Text1 is Test" "Text2 is Text&MoreText" The execution of the macro SendMail shows a warning when trying to resolve the variable &MoreText, even if I have called the macro using %nrstr in order to avoid that: 2 + filename msg email to = "moretest@sas.com" from = "test@sas.com" subject = "Test mail"; 2 + data _null_; file msg; put "Text1: Test"; put '0D0A'x; put "Text2: Text&MoreText"; run; WARNING: Apparent symbolic reference MORETEXT not resolved. What am I missing?   Thank you ... View more