So I tired to generate a new table from the existing one using the datastep, and In addition to the loading time, this time also an error triggered:   80   data gmod.&train_table._2; 81   set gmod.&train_table; 82   format split $10.; 83   if email_dt<="&cutoff9"d then split="train"; 84   else split="test"; 85   run;   NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. ERROR: Cloud Analytic Services failed writing to system disk space. Please contact your administrator. ERROR: Cloud Analytic Services failed writing to system disk space. Please contact your administrator. ERROR: Cloud Analytic Services failed writing to system disk space. Please   I will probably check with my admin what is going on here ... View more

I have no log, as I run the piece of code:   80 data gmod.&train_table._2; 81 set gmod.&train_table; 82 format split $10.; 83 if email_dt<="&cutoff9"d then split="train"; 84 else split="test"; 85 run; NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads.  It get stuck in running without completing  ... View more

GMOD is a caslibrary. The table is loaded in memory already. ... View more

yes, both CAS and multithread:  NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. NOTE: There were 24160332 observations read from the table SPNDAC_TRAIN_TOPIC_PROP_V1 in caslib Global Marketing Models. NOTE: The table spndac_train_topic_prop_v1TEST in caslib Global Marketing Models has 128 observations and 539 variables. NOTE: Sentencia DATA used (Total process time): real time 2.63 seconds cpu time 0.04 seconds ... View more

hanks. I will try that.   Also, to provide more details I add the extended log, as the error is persisting:   As I see the error triggered on the 15/09, and there was no other version of the code running in parallel on that day, I can also exclude that the error is generated by a parallel session running. so no idea at all why this is happening. MPRINT(PROCHTTP_CHECK_RETURN): filename src temp; MPRINT(PROCHTTP_CHECK_RETURN): proc http url="vle.sas.com/mod/page/view.php?id=139728" out=src; MPRINT(PROCHTTP_CHECK_RETURN): run; ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: Resource is write-locked by another thread. File =/batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. ERROR: File is in use, /batchtmp/SAS_workB9F50001F7E4_miseiddvp1/#LN00021. NOTE: 200 OK ERROR: Generic HTTP Client Error NOTE: PROCEDURE HTTP used (Total process time): real time 0.22 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 487.37k OS Memory 579068.00k Timestamp 09/15/2023 07:31:55 PM Step Count 3758064 Switch Count 0 Page Faults 0 Page Reclaims 68 Page Swaps 0 Voluntary Context Switches 13 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: The SAS System stopped processing this step because of errors. ... View more

Sorry, I checked and the function doesn't need the "&" for the macro recall. Terrific. Amazing function to know! ... View more

73 data test; 74 url='blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL 74 ! function 75 evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions.'; 76 call symputx('url',url); 77 run; NOTE: The data set WORK.TEST has 1 observations and 1 variables. NOTE: Compressing data set WORK.TEST increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds SYMBOLGEN: Macro variable URL resolves to blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions. ERROR: %EVAL must be followed by an expression enclosed in parentheses. ERROR: Invalid symbolic variable name BLOGS.SAS.COM/CONTENT/SASTRAINING/2011/09/23/SAS-AUTHORS-TIP-MACRO-FUNCTIONS-EVAL-AND-SYSEVALF/#:~:TEXT=THE %EVAL FUNCTION EVALUATES EXPRESSIONS USING INTEGER ARITHMETIC.,IN MORE DETAIL HOW TO CONSTRUCT MACRO EXPRESSIONS.. Still getting the %EVAL error triggered ... View more

There is an %EVAL keyword in the text of the URL. URls are extracted iteratively from a dataset. So proxy code like this, using your suggestion:   data test; url='blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions.'; run; proc sql; select strip(url)into:url from test; quit; %let urls=%bquote('&url'); %put &urls; Error generated   SYMBOLGEN: Macro variable URL resolves to blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions. ERROR: %EVAL must be followed by an expression enclosed in parentheses. ERROR: %EVAL must be followed by an expression enclosed in parentheses. 83 84 85 %let urls=%bquote('&url'); 86 87 %put &urls; SYMBOLGEN: Macro variable URLS resolves to 'blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions.' SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. ERROR: %EVAL must be followed by an expression enclosed in parentheses. 'blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions.'     ... View more

Yeah, I think we are near a solution. So the URLs are extracted iteratively in a code. A proxy is the following:  data test; url='blogs.sas.com/content/sastraining/2011/09/23/sas-authors-tip-macro-functions-eval-and-sysevalf/#:~:text=The %EVAL function evaluates expressions using integer arithmetic.,in more detail how to construct macro expressions.'; run; proc sql; select strip(url)into:url from test; quit; %let urls=%nrstr(&url); %put &urls; The %nrstr seems stopping the %Eval triggering in the text but does not allow the first macro var to resolve.  ... View more

You have cut the url address. The full address include the %EVAL keywords, which is generating errors described above ... View more