Hope this is the correct location for this question. It appears that I cannot run macros in Jupyter:   https://blogs.sas.com/content/sasdummy/2016/04/24/how-to-run-sas-programs-in-jupyter-notebook   Code used:   %macro SomeExcitingMacro(OriginName); PROC SGPLOT DATA=SASHELP.cars(where=(Origin = "&OriginName.")); VBOX Invoice / category = DriveTrain nooutliers; yaxis min=0 max=100000; RUN; %mend SomeExcitingMacro; proc sql; create table LoopData as select distinct Origin from SASHELP.cars ; quit; data _null_; set LoopData; call execute('%nrstr(%SomeExcitingMacro('||Origin||'))'); run; PS:   Log:   6 The SAS System 16:14 Thursday, April 26, 2018 39 ods listing close;ods html5 (id=saspy_internal) file=_tomods1 options(bitmap_mode='inline') device=svg; ods graphics on / 39 ! outputfmt=png; NOTE: Writing HTML5(SASPY_INTERNAL) Body file: _TOMODS1 40 41 PROC SGPLOT DATA=SASHELP.cars(where=(Origin = "&OriginName.")); WARNING: Apparent symbolic reference ORIGINNAME not resolved. 42 VBOX Invoice 43 / category = DriveTrain nooutliers; 44 yaxis min=0 max=100000; 45 RUN; NOTE: There were 0 observations read from the data set SASHELP.CARS. WHERE 0 /* an obviously FALSE WHERE clause */ ; NOTE: PROCEDURE SGPLOT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 243.46k OS Memory 19864.00k Timestamp 26/04/2018 04:14:56 PM Step Count 6 Switch Count 40 Page Faults 0 Page Reclaims 99 Page Swaps 0 Voluntary Context Switches 105 Involuntary Context Switches 2 Block Input Operations 0 Block Output Operations 0 ERROR: No matching %MACRO statement for this %MEND statement. 46 %mend SomeExcitingMacro; 47 48 proc sql; 49 create table LoopData as 50 select 51 distinct Origin 52 from SASHELP.cars 53 ; NOTE: Compression was disabled for data set WORK.LOOPDATA because compression overhead would increase the size of the data set. NOTE: Table WORK.LOOPDATA created, with 3 rows and 1 columns. 54 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 5328.46k OS Memory 24988.00k Timestamp 26/04/2018 04:14:56 PM Step Count 7 Switch Count 48 Page Faults 0 Page Reclaims 431 Page Swaps 0 Voluntary Context Switches 136 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 136 55 56 data _null_; 57 set LoopData; 58 call execute('%nrstr(%SomeExcitingMacro('||Origin||'))'); 59 run; NOTE: There were 3 observations read from the data set WORK.LOOPDATA. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 921.87k OS Memory 21144.00k Timestamp 26/04/2018 04:14:56 PM Step Count 8 Switch Count 32 Page Faults 0 Page Reclaims 314 Page Swaps 0 Voluntary Context Switches 73 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 NOTE: CALL EXECUTE generated line. WARNING: Apparent invocation of macro SOMEEXCITINGMACRO not resolved. WARNING: Apparent invocation of macro SOMEEXCITINGMACRO not resolved. WARNING: Apparent invocation of macro SOMEEXCITINGMACRO not resolved. NOTE: Line generated by the CALL EXECUTE routine. 1 + %SomeExcitingMacro(Asia ) _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 2 + %SomeExcitingMacro(Europe) 3 + %SomeExcitingMacro(USA ) 60 61 ; 61 ! *';*";*/;ods html5 (id=saspy_internal) close;ods listing; 62   ... View more

Can someone please help with this code. It looks OK to me:   %macro SomeExcitingMacro(Origin); PROC SGPLOT DATA=SASHELP.cars(where=(Origin = %bquote('&Origin.'))); VBOX Invoice / category = DriveTrain nooutliers; title &Origin.; RUN; %mend SomeExcitingMacro; %SomeExcitingMacro(Asia); I get this error:   ERROR: Syntax error while parsing WHERE clause. ... View more

I use this code:     %let Result = %sysevalf(&Number1. + &Number2.); %let old = %sysfunc(stpsrv_header(Content-type, application/json)); %let old = %sysfunc(stpsrv_header(Access-Control-Allow-Origin, *)); data _null_; file _webout; put '{ "name":"John1", "age":31, "city":"New York" }'; run; Here the Number1 and Number2 macro variables come from prompts and should ultimately come from query strings. How can I add the Result macro variable to the JSON file to achieve something like this:   { "name":"John1", "age":31, "city":"New York", "Result":"333" }             ff ... View more