Thanks. I tried:   AXIS1 order=(0.5 to 10 by 0.5) Unfortunately this distorts the values, which btw are not logged but simply values between 0 and 10.  ... View more

Thanks. Happy with PDF in landscape ... ... View more

I tried this code (adopted according to your suggestions):   %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; str = catt('%SomeExcitingMacro(', Origin, ');'); call execute(str); run; Unfortunately, I am still getting and error, if I do not use:   data _null_; run; at the beginning. I have installed the latest saspy but maybe my server version is not the latest (e.g. we do not have M5). ... View more

This works:   data _null_; run; %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; The first lines of code seem to be necessary to get the macro to work. ... View more

Thanks Reeza   Again Jupyter marks macro code red (see screenshot below). Errors in log:   SAS Connection established. Subprocess id is 8964 6 The SAS System 20:53 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 42 proc print data=&dsn; run; _ 22 200 WARNING: Apparent symbolic reference DSN not resolved. ERROR: File WORK.DSN.DATA does not exist. ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 72.71k OS Memory 19608.00k Timestamp 26/04/2018 08:53:52 PM Step Count 6 Switch Count 38 Page Faults 0 Page Reclaims 84 Page Swaps 0 Voluntary Context Switches 96 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 ERROR: No matching %MACRO statement for this %MEND statement. WARNING: Apparent invocation of macro SAMPLE_PRINT not resolved. 43 44 %mend ; 45 46 %sample_print(dsn=sashelp.class); 47 48 ods html5 (id=saspy_internal) close;ods listing; 49 ... View more

I agree! TBH I am perfectly happy with EG but certain people think everything is Python/Jupyter these days. It should still be possible to use a macro in Jupyter though?! ... View more

I know. The first few lines of the code in the screenshot are red. Jupyter seems to ignore them for whatever reason?! Not sure what else to do? ... View more

As I said I submitted your code as well. The screenshot is below. I get similar error logs:   6 The SAS System 18:24 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."; vbox invoice / category=drivetrain nooutliers; WARNING: Apparent symbolic reference ORIGINNAME not resolved. 42 yaxis min=0 max=100000; 43 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 242.03k OS Memory 19864.00k Timestamp 26/04/2018 06:24:26 PM Step Count 6 Switch Count 32 Page Faults 0 Page Reclaims 104 Page Swaps 0 Voluntary Context Switches 72 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 ERROR: No matching %MACRO statement for this %MEND statement. 44 %mend someexcitingmacro; 45 46 proc sql; 47 create table loopdata as 48 select distinct origin 49 from sashelp.cars; 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. 50 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 5328.46k OS Memory 24988.00k Timestamp 26/04/2018 06:24:26 PM Step Count 7 Switch Count 40 Page Faults 0 Page Reclaims 424 Page Swaps 0 Voluntary Context Switches 104 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 144 51 52 data _null_; 53 set loopdata; 54 call execute('%SomeExcitingMacro('||origin||');'); 55 run; 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: 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.01 seconds system cpu time 0.00 seconds memory 925.21k OS Memory 21144.00k Timestamp 26/04/2018 06:24:26 PM Step Count 8 Switch Count 38 Page Faults 0 Page Reclaims 313 Page Swaps 0 Voluntary Context Switches 96 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. 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. WARNING: Apparent invocation of macro SOMEEXCITINGMACRO not resolved. NOTE: Line generated by the CALL EXECUTE routine. 2 + %SomeExcitingMacro(Europe); _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. WARNING: Apparent invocation of macro SOMEEXCITINGMACRO not resolved. NOTE: Line generated by the CALL EXECUTE routine. 3 + %SomeExcitingMacro(USA ); _ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 56 57 ods html5 (id=saspy_internal) close;ods listing; 58 My current conclusion is that Jupyter does not work with macros or maybe I am missing something. ... View more

added log (?) to original code. the suggested alternative code produces the same ... ... View more