Hello, In traditional SAS Stored Process environments, it's possible to chain or link stored processes together to create more flexible, modular web applications—allowing for distributed processing and user interaction between steps. I’m now working within the SAS Viya Job Execution (JE) platform, and I’m wondering: Is it possible to chain multiple SAS jobs together using JE? Can a job call or redirect to another JE job, perhaps passing parameters between them (e.g., via URL or session state)? Are there any working examples, documentation, or best practices for implementing this chaining technique within JE? My goal is to implement a multi-step web workflow using SAS Job Execution jobs, where each step can guide the user to the next one and possibly reuse parameters or intermediate results. If anyone has a simple working demo, or if SAS provides any official documentation, I would greatly appreciate it!   ... View more

All: I have SAS Code below, and upon SAS Job Execution, it doesn't render sgplot image.    ods graphics on / outputfmt=png; ODS HTML style=HTMLBlue file=_webout gpath= _ODSOPTIONS = options(BITMAP_MODE='inline');  proc sgplot data=xxx  ; title; footnote; by year;   xaxis type=linear min=&min_y. max=&max_y. values=(&min_y. to &max_y. by 1); series x=time y=estrips / name="mrfss" lineattrs=(thickness=1.85 color=black) markers markerattrs=(size=3.5px color=black) break; series x=time y=lower_eff / name="mrfss_ci" lineattrs=(thickness=1.7 pattern=ShortDash color=ligr) break legendlabel="95% Confidence Interval" markers markerattrs=(symbol=x size=4px color=gray); series x=time y=upper_eff / lineattrs=(thickness=1.7 pattern=ShortDash color=ligr) break legendlabel=" " markers markerattrs=(symbol=x size=4px color=gray);   yaxis offsetmin=0 ; run; ods html close; ods graphics off;   I am getting ...When I right click on the image, it can be open in another tab, and it shows the image.       ... View more

I have following SAS code that creates two excel links using SAS VIYA JOB EXECUTION. However, each excel link outputs the same (last) record of the dataset 'all'.  Need help/suggestions to fix this issue.     data all; format inspectiondate date9.; name='Johny'; Month_Year='01-2021'; Rpt_Dt='Inspection_Tasks_2021_01'; InspectionDate='01JAN2021'd; output; name='Jacob'; Month_Year='02-2021'; Rpt_Dt='Inspection_Tasks_2021_02'; InspectionDate='01FEB2021'd; output; run; %global actlist Insp_Rpts ; Proc SQL ; Select distinct Month_year into: actlist separated by '~' from all ; Select distinct Rpt_Dt into: Insp_Rpts separated by '~' from all ; quit; %put actlist = &actlist. ; %put Insp_Rpts = &Insp_Rpts. ;   %MACRO RW; Proc SQL ; Select distinct Month_year into: actlist separated by '~' from all ; Select distinct Rpt_Dt into: Insp_Rpts separated by '~' from all ; quit; %global actlist Insp_Rpts ; %put actlist = &actlist. ; %put Insp_Rpts = &Insp_Rpts. ; %let i=1; %do %while(%length(%scan(&Insp_Rpts,&i,"~"))); %let act=%scan(&Insp_Rpts,&i,"~"); Proc SQL NoPrint; Select min(InspectionDate) FORMAT=MMDDYY10. into:MIN_DATE SEPARATED by ' ' from all where Rpt_Dt ="&act."; Quit; %put Min_DATE = &Min_DATE. ; Proc SQL NoPrint; Select max(InspectionDate) FORMAT=MMDDYY10. into:MAX_DATE SEPARATED by ' ' from all where Rpt_Dt ="&act."; Quit; %put Max_DATE = &Max_DATE. ;   Proc SQL NoPrint; Select Min(inspectionDate) format=mmddyy10. into:Stdt SEPARATED by ' ' From work.all where Rpt_Dt ="&act.";; Quit; Proc SQL NoPrint; Select Max(inspectionDate) format=mmddyy10. into:Enddt SEPARATED by ' ' From work.all where Rpt_Dt ="&act.";; Quit; %Put Stdt = &Stdt. EndDt = &Enddt. ; %let i=%eval(&i+1); ods escapechar='~'; ods _all_ close; %put act_A = &act.; /* *************** */ filename f_xlxp filesrvc parenturi="&SYS_JES_JOB_URI" name="NR.xml" contenttype='application/vnd.ms-excel' contentdisp='attachment; filename="&act.xlsx" ' ; ods excel file=f_xlxp style=Plateau ; %LET Curr_date = %left(%qsysfunc(date(),mmddyy10.)) ; %let bold_style=~S={font_size=15pt font_weight=bold foreground=blue}~; title1 j=left color=blue height=14pt "Sample Report "; Proc print data=all(where=(Rpt_Dt ="&act.")) noobs label sumlabel style(header)={background=#33adff color=white just=center } ; Title color=blue "&act"; run; ods excel close; ods _all_ close; ods listing; data _null_; file _webout; put '<HTML>'; put "<HEAD><TITLE>Sample Report</TITLE></HEAD>"; put '<BODY>'; put "<P> <font size= 4.5 bgcolor= Black color = Red >Sample Report can be downloaded by clicking on the link below."; put "<P><font size= 4.5 bgcolor= Black color = Red > <a href=""&_FILESRVC_F_XLXP_URI/content"" target=""_SASDLResults"">Click here to download the report</a>"; put '</BODY>'; put '</HTML>'; Run; %end; %mend; %RW; ... View more