@Renato_sas thanks, oh man lots of red!     Device.js?eval:21 2022-08-02 10:07:45 Device API logging initialized - DEVICE /SASDrive/:1 Unchecked runtime.lastError: The message port closed before a response was received. /preferences/preferences/@currentUser/FormatLocale.DefaultLocale:1 Failed to load resource: the server responded with a status of 404 () /preferences/preferences/@currentUser/_hc_xx_:1 Failed to load resource: the server responded with a status of 404 () Device.js?eval:21 2022-08-02 10:07:47 [] Device API logging initialized - DEVICE ltjsLoaderUtil.js?eval:1 LTJS load: WASM load time: 1987.7000000476837 ms /preferences/preferences/@currentUser/FormatLocale.DefaultLocale:1 Failed to load resource: the server responded with a status of 404 () ltjsRuntime.js?eval:1 LTJS: getFormatLocale en-US ltjsRuntime.js?eval:1 LTJS: getLocale en-US ltjsRuntime.js?eval:1 ******************************* ltjsRuntime.js?eval:1 LTJS PLATFORM INITIALIZATION SUCCESS ltjsRuntime.js?eval:1 ******************************* Log.js?eval:6 2022-08-02 10:07:54.388600 SASDrive has received message from AppSwitcher : AppSwitcher.AppAdded : {"appId":"SASDrive","availableApps":[{"appId":"SASDrive","title":null,"url":"https://10.100.3.5/SASDrive/","isDirty":false}]} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:07:54.389000 SASDrive has received message from AppSwitcher : AppSwitcher.AppShow : {"hashId":"SASDrive","appId":"SASDrive","url":"https://10.100.3.5/SASDrive/"} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:07:54.395500 SASDrive has received message from AppSwitcher : AppSwitcher.AppSwitch : {"appId":"SASDrive"} - ApplicationSwitcher.js jquery.js?eval:26 Failed to load resource: the server responded with a status of 404 (Not Found) send @ jquery.js?eval:26 Device.js?eval:21 2022-08-02 10:07:57 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:07:57 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA assert.js?eval:6 Assertion failed: ManagedObject.apply: encountered unknown setting 'tabindex' for class 'sas.hc.m.Label' (value:'0') eval @ assert.js?eval:6 Device.js?eval:21 2022-08-02 10:08:00 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:08:00 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:08:00 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:08:00 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Log.js?eval:6 2022-08-02 10:08:04.218600 SASDrive has received message from AppSwitcher : AppSwitcher.AppAdded : {"appId":"VANextLogon","availableApps":[{"appId":"SASDrive","title":null,"url":"https://10.100.3.5/SASDrive/","isDirty":false},{"appId":"VANextLogon","title":null,"url":"/SASVisualAnalytics/","isDirty":false}]} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:04.218800 SASDrive has received message from AppSwitcher : AppSwitcher.AppHide : {} - ApplicationSwitcher.js Device.js?eval:21 2022-08-02 10:08:05 [] Device API logging initialized - DEVICE ltjsLoaderUtil.js?eval:1 LTJS load: WASM load time: 3069.400000035763 ms /preferences/preferences/@currentUser/FormatLocale.DefaultLocale:1 Failed to load resource: the server responded with a status of 404 () Log.js?eval:6 2022-08-02 10:08:11.520199 SASDrive has received message from AppSwitcher : AppSwitcher.AppSwitch : {"appId":"VANextLogon","previousAppId":"SASDrive"} - ApplicationSwitcher.js ltjsRuntime.js?eval:1 LTJS: getFormatLocale en-US ltjsRuntime.js?eval:1 LTJS: getLocale en-US ltjsRuntime.js?eval:1 ******************************* ltjsRuntime.js?eval:1 LTJS PLATFORM INITIALIZATION SUCCESS ltjsRuntime.js?eval:1 ******************************* Log.js?eval:6 2022-08-02 10:08:13.871399 VANextLogon has received message from AppSwitcher : AppSwitcher.AppAdded : {"appId":"VANextLogon","availableApps":[{"appId":"SASDrive","title":null,"url":"https://10.100.3.5/SASDrive/","isDirty":false},{"appId":"VANextLogon","title":null,"url":"/SASVisualAnalytics/","isDirty":false}]} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:13.871800 VANextLogon has received message from AppSwitcher : AppSwitcher.AppShow : {"hashId":"VANextLogon","appId":"VANextLogon","url":"/SASVisualAnalytics/"} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:13.877000 VANextLogon has received message from AppSwitcher : AppSwitcher.AppSwitch : {"appId":"VANextLogon","previousAppId":"SASDrive"} - ApplicationSwitcher.js QuickStartDialog.js?eval:1 (QS) QuickStartDialog::init(): Creating QuickDrive. (console.info) Log.js?eval:6 2022-08-02 10:08:15.367899 SASDrive has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:15.369699 VANextLogon has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:15.666800 SASDrive has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:15.667399 VANextLogon has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:15.667500 SASDrive has received message from AppSwitcher : AppSwitcher.UpdateAppTitle : {"appId":"VANextLogon","title":"Report 1"} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:15.668100 VANextLogon has received message from AppSwitcher : AppSwitcher.UpdateAppTitle : {"appId":"VANextLogon","title":"Report 1"} - ApplicationSwitcher.js /reportData/executors?sso_retry=POST&code=wMHXtY5cYz&state=618ba1ae:1 Failed to load resource: the server responded with a status of 449 () /crossdomainproxy/?sas-commons-destUrl=https%3A%2F%2Fservices.arcgisonline.com%2FArcGIS%2Frest%2Fservices%3Ff%3Djson:1 Failed to load resource: the server responded with a status of 500 () ltjs-wasm.js:284 2022-08-02 10:08:20.5350 [WARNING] NetworkDataLogger.cpp::73:HTTP_GET https://services.arcgisonline.com/ArcGIS/rest/services?f=json returned HTTP_INTERNAL_SERVER_ERROR xb @ ltjs-wasm.js:284 AutoCancellingTransporterWrapper.ts:185 request 9679634b-6246-440c-a8fd-c99fea0e2045 completed. Removing from transporter group availableTables Device.js?eval:21 2022-08-02 10:08:23 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:08:23 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Device.js?eval:21 2022-08-02 10:08:23 [] Range set DeviceSet has already been initialized - DEVICE.MEDIA Log.js?eval:6 2022-08-02 10:08:24.880399 TileView onAfterRendering, setFocusIndex - sas.drive r @ Log.js?eval:6 Log.js?eval:6 2022-08-02 10:08:40.791199 SASDrive has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:40.791699 VANextLogon has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:42.992100 SASDrive has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:42.993300 VANextLogon has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:42.994199 SASDrive has received message from AppSwitcher : AppSwitcher.UpdateAppTitle : {"appId":"VANextLogon","title":"VA-DDC-Job Hello Small World"} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:42.994699 VANextLogon has received message from AppSwitcher : AppSwitcher.UpdateAppTitle : {"appId":"VANextLogon","title":"VA-DDC-Job Hello Small World"} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:43.007500 SASDrive has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js Log.js?eval:6 2022-08-02 10:08:43.008000 VANextLogon has received message from AppSwitcher : AppSwitcher.DirtyFlagChanged : {"appId":"VANextLogon","dirtyFlag":false} - ApplicationSwitcher.js ... View more

@Renato_sas  So I have that path in the code and also have show log, but I do not even see the log or errors, do i need to do something in the browser to see more information?    ... View more

@malima Thanks malima, i have those files from a previous example i walked thru https://communities.sas.com/t5/SAS-Communities-Library/Data-Entry-in-SAS-Visual-Analytics-8-3-Part-3-Integrate-SAS-Viya/ta-p/582397  from @XavierBizoux  where it said to store them in /var/www/html :   so i did and updated the logic in this example to point to them but maybe i missed something path i put in code similar to Xaviers  <script type="text/javascript" src="/util/messagingUtil.js"></script>  . I never got the example I mentioned to fully work which was the part that showed what others answered. So I'm wondering is my browser is not configured to utilize the js files or something, because that is the only part of this example not working either. I can clearly see the js file when I put their direct path in the browser:       Could it be an issue with our certificates not being applied yet on our servers? Or setting I need to make in Edge to make it work, I already have allow javascript&colon;  Any help would be great, thanks. ... View more

@Renato_sas My data-driven content doesn't show any results, i changed the url to my host name and in the html code, I'm getting no errors, any thoughts?     ... View more

@XavierBizoux is it possible to use a CAS memory table instead of a SAS dataset in the the datasources section of the xml? I tried pointing my task to one, but doesn't seem to work. I figured that would be faster to use for my combobox as i have a large list of values but the column is grayed out and will not let me select anything versus when I point it to a sas dataset. Is there a better way of doing this especially with really large list of customer id's to choose from (millions), I want them to have to choose an id for data integrity purposes. Any help would be appreciated. thanks.     ... View more

Thanks @XavierBizoux , so data is available to report on, and the part of capturing the data in the tables is working, so at least i know that works which is what I really care about. I'm sure I'll have more question now that I am trying to build my own. Thanks for getting back to me. ... View more

So found one issue that I fogot to do, when replacing the html from part two with the new html from part three forgot to change the line with the gel content to my directory where the job is   171 value="/gelcontent/Jobs/Quiz">'; So I can submit the quiz now with now apparent errors however the section in the data driven content, still doesn't show what other users responses are and I now get new errors:   NOTE: Active Session now MYSESSION. NOTE: Cloud Analytic Services saved the file quiz_answers.sashdat in caslib Fintech. {caslib=Fintech,name=quiz_answers.sashdat} NOTE: Cloud Analytic Services dropped table questions from caslib CASUSER(jwalker). ERROR: The source data questions could not be removed from caslib CASUSER(jwalker) of Cloud Analytic Services. ERROR: The action stopped due to errors. NOTE: Cloud Analytic Services dropped table toLoad from caslib CASUSER(jwalker). ERROR: The source data toLoad could not be removed from caslib CASUSER(jwalker) of Cloud Analytic Services. ERROR: The action stopped due to errors.  Not sure if it an issue? Also is it supposed to look like i have five contents inside each other, each time I answer a question looks like its opening up a new data driven object? ... View more

Hi Xavier, stuck re-creating the Visual. I have the javascripts saved to the recommended folders and tested it with my browser, and all successfully showed the script details, sample:   Before updating the the new html code, I ran the job in sas studio and it worked great, no errors. After updating the html code and building the visual:    I am not getting the section on the data driven content that shows what other users selected as answers and when I submit my first question I get an error: I clicked on show log and reopened report and here is the log short of the Error saying table already existed, I'm not seeing any other issues: AS Log 1 %JESBEGIN The SAS System >>> SAS Macro Variables: _ACTION=form,prompts,execute _ADDJESBEGINENDMACROS=true _CASHOST_=AZRSASCASTEST.coastal.local _CASHOSTCONT_=AZRSASCASTEST.coastal.local _CASPORT_=5570 _CLIENTNAME=SASJobExecution _CONTEXTNAME=SAS Job Execution compute context _CSRF=0c961cae-dc54-442a-8d6d-723b261b8e1d _DEBUG=log _GRAFLOC= _HTUA= Mozilla/5.0 (Windows NT 10.0 Win64 x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.5005.124 Safari/537.36 Edg/102.0.1245. 44 _MIGRATED_STP= _OMITJSONLISTING=true _OMITJSONLOG=false _OMITSESSIONRESULTS=true _OMITTEXTLISTING=true _OMITTEXTLOG=true _OUTPUT_TYPE=html _PROGRAM=/Users/jwalker/Quiz _REPLAY= _RESULTFILE=_webout.* _RMTADDR=10.100.253.230 _RMTHOST=10.100.253.230 _SUPPRESS_MVARS= _TMPCAT= _URL=/SASJobExecution/ _USERLOCALE=en_US _VARIABLEFILTER=eq(name,'_STATUS_MESSAGE') _VERSION=SASJobExecution Version 2.2.62 _XFORWARD=10.100.3.5 SYS_COMPUTE_DATA=/opt/sas/viya/config/data/compsrv/default SYS_COMPUTE_JOB_ID=2F5DD491-2B08-D945-9CA7-5EECFAD27C0D SYS_COMPUTE_SESSION_ID=236f9e19-3719-41c3-94aa-21681920c773-ses0000 SYS_COMPUTE_SESSION_OWNER=jwalker SYS_JES_JOB_URI=/jobExecution/jobs/08785044-1e82-4e28-b4cb-d22e35509665 2 /* Define macro variables for the parameters defined in the URL */ 3 %global id maxid answer01 answer02 answer03 answer04 answer05; 4 5 /* Define CAS server connection, session and CAS libraries */ 6 options cashost="azrsascastest.coastal.local" casport=5570; 7 cas mySession sessopts=(caslib="casuser"); NOTE: The session MYSESSION connected successfully to Cloud Analytic Services azrsascastest.coastal.local using port 5570. The UUID is 3087a34c-bfa7-894a-979f-68469708d201. The user is jwalker and the active caslib is CASUSER(jwalker). NOTE: The SAS option SESSREF was updated with the value MYSESSION. NOTE: The SAS macro _SESSREF_ was updated with the value MYSESSION. NOTE: The session is using 0 workers. NOTE: 'CASUSER(jwalker)' is now the active caslib. NOTE: The CAS statement request to update one or more session options for session MYSESSION completed. 8 libname fintech cas caslib="fintech"; NOTE: Libref FINTECH was successfully assigned as follows: Engine: CAS Physical Name: 3087a34c-bfa7-894a-979f-68469708d201 The SAS System 9 libname casuser cas caslib="casuser"; NOTE: Libref CASUSER was successfully assigned as follows: Engine: CAS Physical Name: 3087a34c-bfa7-894a-979f-68469708d201 10 11 /* Macro invoked at the beginning of the Job execution */ 12 %macro init; 13 %if %symexist(id) and %eval(&id > 0) %then 14 %do; 15 16 /* Call record macro to register the answers */ 17 %record; 18 19 /* Increment question id */ 20 %let id = %eval(&id + 1 ); 21 %end; 22 %else 23 %do; 24 25 /* Code executed when loading the first time */ 26 %let id = 1; 27 28 data casuser.questions; 29 set fintech.quiz_programming; 30 run; 31 proc cas; 32 table.promote /caslib="casuser" name="questions"; 33 quit; 34 %end; 35 36 /* Define the number of questions */ 37 proc sql noprint; 38 create table maxid as select max(id) as maxid from casuser.questions; 39 select maxid into :maxid from maxid; 40 quit; 41 42 %mend; 43 44 /* Macro invoked when last question has been answered */ 45 %macro finish; 46 %if %eval(&id > &maxid) %then 47 %do; 48 /* Generate the data set to be loaded into the Global CASLib used for reporting */ 49 data casuser.toLoad; 50 set casuser.questions (drop= questions choices hint justification); 51 userid = "&sysuserid"; 52 datetime = datetime(); 53 format datetime datetime16.; 54 run; 55 /* Load data into the CASLib used for reporting and perform some cleanup activities */ 56 proc cas; 57 table.tableExists result=res/caslib='fintech' name='quiz_answers'; 58 59 if res.exists > 0 then 60 do; 61 datastep.runcode result=dsResult /code="data fintech.quiz_answers (append=yes); set casuser.toLoad; run;"; 62 end; 63 else The SAS System 64 do; 65 table.promote / caslib='casuser' name='toLoad' target='quiz_answers' targetlib='fintech'; 66 table.promote / caslib='fintech' name='quiz_answers'; 67 end; 68 table.save / caslib='fintech' name='quiz_answers' table={caslib='fintech' name='quiz_answers'} replace=true; 69 table.dropTable / caslib='casuser' name='questions'; 70 table.deleteSource / caslib='casuser' source='questions'; 71 table.dropTable / caslib='casuser' name='toLoad'; 72 table.deleteSource / caslib='casuser' source='toLoad'; 73 quit; 74 /* Terminate the CAS session */ 75 cas mySession terminate; 76 %end; 77 %mend; 78 79 /* Macro invoked to record the answers */ 80 %macro record; 81 proc cas; 82 questionsTbl.name="questions"; 83 84 do i=1 to 5 by 1; 85 name_i=put(i, z2.); 86 varName='Answer'||name_i; 87 88 if symget(varName) > "" then 89 do; 90 questionsTbl.where="&id = id and name ='"|| varName ||"'"; 91 table.update / table=questionsTbl set={{var='selected', value="1"}}; 92 end; 93 end; 94 quit; 95 96 %mend; 97 98 /*Macro generating the html pages */ 99 %macro html; 100 %if %eval(&id > &maxid) %then 101 %do; 102 /* Call the quizz summary page */ 103 %html_result; 104 %end; 105 %else 106 %do; 107 data _null_; 108 set casuser.questions (where=(ID=&id)) nobs=rows; 109 file _webout; 110 by id; 111 /* Generate the HTML head */ 112 if _n_ = 1 then do; 113 put '<html lang="en">'; 114 put '<head>'; 115 put '<title>Quizz Programming</title>'; 116 put '<meta charset="utf-8">'; 117 put '<meta name="viewport" content="width=device-width, 118 initial-scale=1.0">'; 119 put '<meta author="BIZOUX, Xavier">'; 120 put '<style>'; 121 put 'article {padding-left:20px;}'; The SAS System 122 put '</style>'; 123 /* Add jquery and the utilities for Data-Driven Content object */ 124 put '<script type="text/javascript" 125 src="/libs/jquery-3.3.1.min.js"></script>'; 126 put '<script type="text/javascript" 127 src="/util/messagingUtil.js"></script>'; 128 put '<script type="text/javascript" 129 src="/util/contentUtil.js"></script>'; 130 put '<script>'; 131 put 'function hint() { 132 var x = document.getElementById("hint"); 133 if (x.style.display === "none") { 134 x.style.display = "block"; 135 } else { 136 x.style.display = "none"; 137 } 138 }'; 139 /* Define function to handle the data retrieved from 140 Data-Driven Content Object */ 141 put 'function DDC(messageFromVA) { 142 var question = $("#id").val(); 143 var html = "Other users gave the following answers:"; 144 html += "<table>"; 145 messageFromVA.data.forEach(function (d) { 146 if (d[0] == question) { 147 html += "<tr><td>" + d[1] + "</td><td>" + 148 d[2].toLocaleString(undefined,{style: "percent", NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. 149 minimumFractionDigits:2}) +"</td></tr>"; 150 }}); 151 html += "</table>"; 152 $("#superHint").html(html); 153 }'; 154 /* Add an event listener to define the action 155 when the Hint button is pressed */ 156 put 'document.addEventListener("DOMContentLoaded", 157 function (event) { hint(); });'; 158 /* Define the action that is executed when the data are received 159 from the Data-Driven Content object */ 160 put 'va.messagingUtil.setOnDataReceivedCallback(DDC);'; 161 put '</script>'; 162 put '</head>'; 163 put '<body>'; 164 end; 165 if first.id then 166 do; 167 /* Create the form calling the SAS JobExecution 168 and the specific job */ 169 put '<form action="/SASJobExecution/">'; 170 put '<input type="hidden" name="_program" 171 value="/gelcontent/Jobs/Quiz">'; 172 put '<input type="hidden" name="id" id="id" value="' id +(-1)'">'; 173 put '<section>'; 174 put '<header>'; 175 put '<h3>Q ' id "/&maxid : " questions '</h3>'; 176 put '</header>'; 177 put '<article>'; 178 end; The SAS System 179 put '<br>'; 180 put '<label> <input type="checkbox" name="' Name +(-1) '" value="' 181 Correct +(-1) '">' choices +(-1) '</label>'; 182 if last.id then 183 do; 184 put '<br><br>'; 185 put '<button type="button" onclick="hint();">Hint</button>'; 186 put '<input type="submit">'; 187 put '<div id="hint"><p>Multiple answers</p>'; 188 put '<div id="superHint"></div>'; 189 put '</div>'; 190 put '</article>'; 191 put '</section>'; 192 put '</form>'; 193 end; 194 if _n_=rows then do; 195 put '</body>'; 196 put '</html>'; 197 end; 198 run; 199 %end; 200 %mend; 201 202 /*Macro generating the summary page */ 203 %macro html_result; 204 data _null_; 205 length cssClass $200; 206 set casuser.questions nobs=rows; 207 file _webout; 208 by id; 209 /* Generate the HTML head */ 210 if _n_=1 then 211 do; 212 put '<html lang="en">'; 213 put '<head>'; 214 put '<title>quiz Programming</title>'; 215 put '<meta charset="utf-8">'; 216 put 217 '<meta name="viewport" content="width=device-width, initial-scale=1.0">'; 218 put '<meta author="BIZOUX, Xavier">'; 219 put '<style>'; 220 put 'article {padding-left:20px;}'; 221 put '.valid {display:block; background-color: lightgreen; width:400px;}'; 222 put '.invalid {display:block; background-color: red; width:400px;}'; 223 put '</style>'; 224 put '</head>'; 225 put '<body>'; 226 end; 227 /* Generate the card for each question */ 228 if first.id then 229 do; 230 put '<section>'; 231 put '<header>'; 232 put '<h3>Q ' id "/&maxid : " questions '</h3>'; 233 put '</header>'; 234 put '<article>'; 235 end; 236 The SAS System 237 if correct=1 then 238 cssClass=' class="valid" '; 239 else 240 cssClass=' class="invalid" '; 241 put '<label ' cssClass '>'; 242 put; 243 244 if selected=1 then 245 do; 246 put '<input type="checkbox" checked disabled>'; 247 end; 248 else 249 do; 250 put '<input type="checkbox" disabled>'; 251 end; 252 put choices +(-1) '</label>'; 253 254 if last.id then 255 do; 256 put '</article>'; 257 put '<br>'; 258 put '<article>'; 259 put '<header> <h4>Answer</h4> </header>'; 260 put '<p>' justification '</p>'; 261 put '</article>'; 262 put '<br>'; 263 put '</section>'; 264 end; 265 266 if _n_=rows then do; 267 put '</body>'; 268 put '</html>'; 269 end; 270 run; 271 272 %mend; 273 274 /* Call the different macros */ 275 %init; NOTE: Running DATA step in Cloud Analytic Services. NOTE: The DATA step will run in multiple threads. NOTE: There were 10 observations read from the table QUIZ_PROGRAMMING in caslib Fintech. NOTE: The table questions in caslib CASUSER(jwalker) has 10 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1409.87k OS Memory 26148.00k Timestamp 07/18/2022 04:02:48 PM Step Count 7 Switch Count 2 Page Faults 0 Page Reclaims 82 Page Swaps 0 Voluntary Context Switches 68 Involuntary Context Switches 0 Block Input Operations 0 The SAS System Block Output Operations 0 NOTE: Active Session now MYSESSION. ERROR: The target table questions of the promotion already exists. Please specify a different name. ERROR: The action stopped due to errors. NOTE: PROCEDURE CAS used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 10658.03k OS Memory 35980.00k Timestamp 07/18/2022 04:02:48 PM Step Count 8 Switch Count 0 Page Faults 0 Page Reclaims 1166 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: Table WORK.MAXID created, with 1 rows and 1 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 5467.50k OS Memory 31268.00k Timestamp 07/18/2022 04:02:48 PM Step Count 9 Switch Count 0 Page Faults 0 Page Reclaims 315 Page Swaps 0 Voluntary Context Switches 42 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 136 276 %html; NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. NOTE: The file _WEBOUT is: Filename=_webout.html, URI path=/files/files/68090848-ba38-442d-80b3-bf9df3c73b3c, File Identifier=68090848-ba38-442d-80b3-bf9df3c73b3c, Content Type=text/html, Parent URI=/jobExecution/jobs/08785044-1e82-4e28-b4cb-d22e35509665, Encoding=UTF-8,RECFM=V,LRECL=32767, File Size (bytes)=0, Last Modified=18Jul2022:16:02:48, Create Time=18Jul2022:16:02:48 The SAS System NOTE: 45 records were written to the file _WEBOUT. The minimum record length was 4. The maximum record length was 376. NOTE: There were 4 observations read from the data set CASUSER.QUESTIONS. WHERE ID=1; NOTE: DATA statement used (Total process time): real time 0.32 seconds user cpu time 0.06 seconds system cpu time 0.01 seconds memory 912.50k OS Memory 26400.00k Timestamp 07/18/2022 04:02:48 PM Step Count 10 Switch Count 0 Page Faults 0 Page Reclaims 623 Page Swaps 0 Voluntary Context Switches 92 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 8 277 %finish; 278 %JESEND   ... View more

@ChrisHemedinger Hey Chris is it possible to attach a file from the SAS Studio explorer folders if so how do I refer to that in the attach option? Tried this: filename myemail EMAIL; FILENAME REFFILE FILESRVC FOLDERPATH='/Users/jwalker' FILENAME='BSA_FEDWIRE.csv'; data _null_; FILE myemail to=("jwalker@coastalbank.com") subject="testing with attachment" attach=(REFFILE); file myemail; put "Attached is sample"; put "Thank you,"; put "it worked"; run; ERROR 24-2: Invalid value for the ATTACH option. Also just tried the path, but I think its looking for a path on the OS: data _null_; FILE myemail to=("jwalker@coastalbank.com") subject="testing with attachment" attach=('/Users/jwalker/BSA_FEDWIRE.csv'); file myemail; put "Attached is sample"; put "Thank you,"; put "it worked"; run;   ... View more

@XavierBizoux    Morning Xavier, great article, as with @danilononod I need to be able to share this with guest, I too got the 403 error, I went into Environment manager and changed all but a couple of rules, it got rid of the 403 error but now just says job error. I know my report work for those with access to sas, and the report works for guest but the part of my VA report that kicks off the job doesn't work for guest. is there another management option i need to adjust? The public guest folder is setup properly for access, as our other va reports without any job attached works great.    Rules I adjusted just to test:   new error:     Any help you can give would be great.thanks ... View more

Thanks Chris, I've tried the termstr=LF as well as cr, crlf and every combo of scanover, truncover etc and it still doesn't read the data in properly, the issue I have is an unexpected LF in the middle of quoted data, so the full line is not read in for the record and instead the rest of the data is read in as another record. Is there another way to deal with issues like this, I would love to not have to rewrite the files. thanks   ... View more