I always struggle with the macro quoting.   Why does this work and the following modification does not???   %let kept=Arne Bert Hansi; %macro quote_names(name_list); %local i name; %GLOBAL quoted_names; %let quoted_names = ; %let i = 1; %do %while(%scan(&name_list, &i) ne ); %let name = %scan(&name_list, &i); %let quoted_names = &quoted_names %str(%')&name%str(%')%str(, ); %let i = %eval(&i + 1); %end; %let quoted_names = %substr(&quoted_names, 1, %length(&quoted_names) - 2); %mend quote_names; %quote_names(%str(&kept)); %put %STR(&quoted_names); 'Arne', 'Bert', 'Hansi'   But if I want to leave only the spaces without the comma, then it fails stating    ERROR: Literal contains unmatched quote. ERROR: The macro QUOTE_NAMES will stop executing.   %let kept=Arne Bert Hansi; %macro quote_names(name_list); %local i name; %GLOBAL quoted_names; %let quoted_names = ; %let i = 1; %do %while(%scan(&name_list, &i) ne ); %let name = %scan(&name_list, &i); %let quoted_names = &quoted_names %str(%')&name%str(%')%str( ); %let i = %eval(&i + 1); %end; %let quoted_names = %substr(&quoted_names, 1, %length(&quoted_names) - 2); %mend quote_names; %quote_names(%str(&kept)); %put %STR(&quoted_names);     ... View more

I get bad results because they don't wait for each other.    The result is different from the one I egt when I run both datasteps one after another.   proc cas; function doesTableExist(casLib,casTable); table.tableExists result=r status=rc / caslib=casLib table=casTable; tableExists = dictionary(r, "exists"); return tableExists; end func; source myDataStep; data casuser.origin_filtered_by_time; set &fname.; if timestamp >= input("&last_start_date.", datetime20.); keep timestamp var1; run; endsource; source myDataStep1; data casuser.result_groups_temp / sessref="mySession" single=yes; set casuser.origin_filtered_by_time; by timestamp var1; retain group_id; if lag(var1) ^= var1 then group_id + 1; if first.timestamp; run; endsource; /* check whether the process has been carried out at least once */ tableExists_watchdog = doesTableExist("&liby", "&casy_watchdog"); /* in that case, proceed with the following steps */ if tableExists_watchdog ^=0 then do; dataStep.runCode result=r status=rc / code=myDataStep; dataStep.runCode result=r status=rc / code=myDataStep1; run; ... View more

I haven't cared so far about this issue. I use cas actions and cas programming all over.  But I wonder why I have 6 sessions running.  An what is the use case for having several active sessions? I suppose that if I do not manage the sessions actively I'll face sooner or later performance issues.    When I'm starting my day I run:  /* Init CAS library; */ cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US"); caslib _all_ assign; cas mySession sessopts=(caslib="casuser"); But I do not close sessions. I turn off my laptop and that's it. I think that's bad practice.  I would like to know what I'm missing out not understanding and dealing properly with the sessions.    80 proc cas; 81 session mySession; 82 session.sessionStatus result=res; /* 2 */ 83 84 print "Session status:"; /* 3 */ 85 print " State: " res["state"]; 86 print " Connections: " res["number of Connections"]; 87 print " Timeout: " res["Timeout"] "minutes"; 88 print " Action Status: " res["ActionStatus"]; 89 print " Authenticated: " res["Authenticated"]; 90 print " Locale: " res["locale"]; 91 run; NOTE: Active Session now mySession. Session status: State: Connected Connections: 6 Timeout: 1800 minutes Action Status: Action is active Authenticated: Yes Locale: en_US 92 quit; NOTE: PROCEDURE CAS used (Total process time): real time 0.00 seconds cpu time 0.01 seconds   ... View more