Logs of PROC Tabulate 1 /* region: Generated preamble */ 2 /* Make sure the current directory is writable */ 3 data _null_; 4 length rc 4; 5 %let tworkloc="%sysfunc(getoption(work))"; 6 rc=dlgcdir(&tworkloc); SYMBOLGEN: Macro variable TWORKLOC resolves to "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serv er-1168f934-cccb-4083-84ef-181aa798017b-19880" 7 run; NOTE: The current working directory is now "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-server-116 8f934-cccb-4083-84ef-181aa798017b-19880". NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 491.46k OS Memory 44964.00k Timestamp 05/04/2025 06:42:43 PM Step Count 200 Switch Count 0 Page Faults 0 Page Reclaims 45 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 40 8 9 /* Setup options */ 10 title; 11 footnote; 12 options validvarname=any; 13 options validmemname=extend; 14 options dtreset date number; 15 options device=png; 16 17 /* Setup macro variables */ 18 %let syscc=0; 19 %let _clientapp = %nrquote(%nrstr(SAS Studio)); 20 %let _clientappabbrev = %nrquote(%nrstr(Studio)); 21 %let _clientappversion=2024.09; 22 %let _clientversion=; 23 %let _sasservername=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 24 %let _sashostname=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 25 %let _sasprogramfilehost=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 26 %let _clientuserid = %nrquote(%nrstr(tom.hsiung@stu.cpu.edu.cn)); 27 %let _clientusername = %nrquote(%nrstr(tom.hsiung@stu.cpu.edu.cn)); 28 %let clientmachine = %nrquote(%nrstr()); 29 %let _clientmachine = %nrquote(%nrstr()); 30 %let _clientmode = %nrquote(%nrstr(viya)); 31 %let sasworklocation="%sysfunc(getoption(work))/"; 32 filename _cwd &sasworklocation; SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serv er-1168f934-cccb-4083-84ef-181aa798017b-19880/" 33 data _null_; 34 call symput('_sasworkingdir',pathname('_cwd')); 35 run; 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 476.84k OS Memory 44964.00k Timestamp 05/04/2025 06:42:43 PM Step Count 201 Switch Count 0 Page Faults 0 Page Reclaims 26 Page Swaps 0 Voluntary Context Switches 11 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 36 filename _cwd; NOTE: Fileref _CWD has been deassigned. 37 %let _sasprogramfile = %nrquote(%nrstr(/export/viya/homes/tom.hsiung@stu.cpu.edu.cn/casuser/Warfarin/AF/tCox.sas)); 38 %let _baseurl = %nrquote(%nrstr(https://vfl-032.engage.sas.com/SASStudio/)); 39 %let _execenv = %nrquote(%nrstr(SASStudio)); 40 %symdel _dataout_mime_type _dataout_name _dataout_url _dataout_table / nowarn; 41 %let _sasws_ = %bquote(%sysfunc(getoption(work))); 42 %let _saswstemp_ = %bquote(%sysfunc(getoption(work))); 43 44 /* Detect SAS/Graph and setup graph options */ 45 data _null_; 46 length rc $255; 47 call symput("graphinit",""); 48 call symput("graphterm",""); 49 rc=tslvl('sasxgopt','n'); 50 _error_=0; 51 if (rc^=' ') then do; 52 call symput("graphinit","goptions reset=all gsfname=_gsfname;"); 53 call symput("graphterm","goptions noaccessible;"); 54 end; 55 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 477.90k OS Memory 44964.00k Timestamp 05/04/2025 06:42:43 PM Step Count 202 Switch Count 0 Page Faults 0 Page Reclaims 44 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 56 data _null_; 57 length rc 4; 58 rc=sysprod("PRODNUM002"); 59 if (rc^=1) then do; 60 call symput("graphinit",""); 61 call symput("graphterm",""); 62 end; 63 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 476.90k OS Memory 44964.00k Timestamp 05/04/2025 06:42:43 PM Step Count 203 Switch Count 0 Page Faults 0 Page Reclaims 35 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 64 65 /* Setup ODS destinations */ 66 ods _all_ close; SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to DB69D65A-31EA-6E40-80B9-D438D9FDED3E 67 %studio_results_directory; 68 filename _htmlout "&_results_prefix_..html"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-DB69D65A-31EA-6E40-80B9-D438D9FDED3E 69 filename _listout "&_results_prefix_..lst"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-DB69D65A-31EA-6E40-80B9-D438D9FDED3E 70 filename _gsfname temp; 71 filename _dataout "&_results_prefix_..dat"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-DB69D65A-31EA-6E40-80B9-D438D9FDED3E 72 ods autonavigate off; 73 ods graphics on; 74 ods html5 (id=web) METATEXT='http-equiv="Content-Security-Policy" content="default-src ''none''; style-src ''unsafe-inline''; 74 ! img-src data: ;"' device=png gpath="&_saswstemp_" path="&_saswstemp_" encoding=utf8 file=_htmlout (title='Results:tCox.sas') 74 ! style=Illuminate options(bitmap_mode='inline' outline='on' svg_mode='inline' css_prefix=".ods_&SYS_COMPUTE_JOB_ID" SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serve r-1168f934-cccb-4083-84ef-181aa798017b-19880 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serve r-1168f934-cccb-4083-84ef-181aa798017b-19880 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 74 ! e=Illuminate options(bitmap_mode='inline' outline='on' svg_mode='inline' css_prefix=".ods_&SYS_COMPUTE_JOB_ID" 74 ! body_id="div_&SYS_COMPUTE_JOB_ID" ); SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to DB69D65A-31EA-6E40-80B9-D438D9FDED3E SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to DB69D65A-31EA-6E40-80B9-D438D9FDED3E NOTE: Writing HTML5(WEB) Body file: _HTMLOUT 75 ods listing file=_listout; SYMBOLGEN: Macro variable GRAPHINIT resolves to goptions reset=all gsfname=_gsfname; 76 &graphinit; 77 %studio_initialize_custom_output; 78 /* endregion */ 79 80 proc tabulate data = d202_raw; 81 title 'Summary of patient characterisitcs'; 82 class AF gender smoker CHF DM Stroke Hypertension HFstage hypoalbuminemia RIFLE 83 indication1 CYP2C9 VKORC1 84 Amiodarone Heparin Statin Antiplatelets 85 ; 86 var ageY wt bsa followUp 87 alb1 alb2 alb3 alb4 alb5 88 ; 89 table 90 ageY 91 wt 92 bsa 93 followUp 94 alb1 95 alb2 96 alb3 97 alb4 98 alb5 99 , AF = 'Atrial fibrillation' * (N Mean STD Q1 Q3) 100 all = 'Overall' * (N Mean STD Q1 Q3); 101 table 102 gender 103 smoker 104 CHF 105 DM 106 Stroke 107 Hypertension 108 HFstage 109 hypoalbuminemia 110 RIFLE 111 indication1 112 CYP2C9 113 VKORC1 114 Amiodarone 115 Heparin 116 Statin 117 Antiplatelets 118 , AF = 'Atrial fibrillation' * (N colpctn = '%') 119 all = 'Overall' * (N colpctn = '%') 120 ; 121 run; NOTE: There were 200 observations read from the data set WORK.D202_RAW. NOTE: The PROCEDURE TABULATE printed pages 134-139. NOTE: PROCEDURE TABULATE used (Total process time): real time 0.05 seconds user cpu time 0.05 seconds system cpu time 0.02 seconds memory 11064.26k OS Memory 55500.00k Timestamp 05/04/2025 06:42:43 PM Step Count 204 Switch Count 0 Page Faults 0 Page Reclaims 2161 Page Swaps 0 Voluntary Context Switches 614 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 616 SYMBOLGEN: Macro variable GRAPHTERM resolves to goptions noaccessible; 122 123 /* region: Generated postamble */ 124 /* Close ODS destinations */ 125 &graphterm; ;*';*";*/;run;quit; 126 quit;run; 127 ods html5 (id=web) close; 128 ods listing close; 129 %if %sysfunc(fileref(_gsfname)) lt 0 %then %do; 130 filename _gsfname clear; NOTE: Fileref _GSFNAME has been deassigned. 131 %end; 132 %studio_capture_custom_output; SYMBOLGEN: Macro variable _DATAOUT_NAME resolves to SYMBOLGEN: Macro variable _DATAOUT_MIME_TYPE resolves to 133 /* endregion */ 134   The PROC Univariate could get the 200 observation. However, the PROC Tabulate only report the results of 199 observation. I don't know which observation was removed.   PROC Tabulate script:   proc tabulate data = d202_raw; title 'Summary of patient characterisitcs'; class AF gender smoker CHF DM Stroke Hypertension HFstage hypoalbuminemia RIFLE indication1 CYP2C9 VKORC1 Amiodarone Heparin Statin Antiplatelets ; var ageY wt bsa followUp alb1 alb2 alb3 alb4 alb5 ; table ageY wt bsa followUp alb1 alb2 alb3 alb4 alb5 , AF = 'Atrial fibrillation' * (N Mean STD Q1 Q3) all = 'Overall' * (N Mean STD Q1 Q3); table gender smoker CHF DM Stroke Hypertension HFstage hypoalbuminemia RIFLE indication1 CYP2C9 VKORC1 Amiodarone Heparin Statin Antiplatelets , AF = 'Atrial fibrillation' * (N colpctn = '%') all = 'Overall' * (N colpctn = '%') ; run;   Log of PROC Univariate: 1 /* region: Generated preamble */ 2 /* Make sure the current directory is writable */ 3 data _null_; 4 length rc 4; 5 %let tworkloc="%sysfunc(getoption(work))"; 6 rc=dlgcdir(&tworkloc); SYMBOLGEN: Macro variable TWORKLOC resolves to "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serv er-1168f934-cccb-4083-84ef-181aa798017b-19880" 7 run; NOTE: The current working directory is now "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-server-116 8f934-cccb-4083-84ef-181aa798017b-19880". NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 490.96k OS Memory 45220.00k Timestamp 05/04/2025 06:46:08 PM Step Count 205 Switch Count 0 Page Faults 0 Page Reclaims 48 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 8 9 /* Setup options */ 10 title; 11 footnote; 12 options validvarname=any; 13 options validmemname=extend; 14 options dtreset date number; 15 options device=png; 16 17 /* Setup macro variables */ 18 %let syscc=0; 19 %let _clientapp = %nrquote(%nrstr(SAS Studio)); 20 %let _clientappabbrev = %nrquote(%nrstr(Studio)); 21 %let _clientappversion=2024.09; 22 %let _clientversion=; 23 %let _sasservername=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 24 %let _sashostname=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 25 %let _sasprogramfilehost=&SYSHOSTNAME; SYMBOLGEN: Macro variable SYSHOSTNAME resolves to sas-compute-server-1168f934-cccb-4083-84ef-181aa798017b-19880 26 %let _clientuserid = %nrquote(%nrstr(tom.hsiung@stu.cpu.edu.cn)); 27 %let _clientusername = %nrquote(%nrstr(tom.hsiung@stu.cpu.edu.cn)); 28 %let clientmachine = %nrquote(%nrstr()); 29 %let _clientmachine = %nrquote(%nrstr()); 30 %let _clientmode = %nrquote(%nrstr(viya)); 31 %let sasworklocation="%sysfunc(getoption(work))/"; 32 filename _cwd &sasworklocation; SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "/opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serv er-1168f934-cccb-4083-84ef-181aa798017b-19880/" 33 data _null_; 34 call symput('_sasworkingdir',pathname('_cwd')); 35 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 476.34k OS Memory 45220.00k Timestamp 05/04/2025 06:46:08 PM Step Count 206 Switch Count 0 Page Faults 0 Page Reclaims 25 Page Swaps 0 Voluntary Context Switches 12 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 36 filename _cwd; NOTE: Fileref _CWD has been deassigned. 37 %let _sasprogramfile = %nrquote(%nrstr(/export/viya/homes/tom.hsiung@stu.cpu.edu.cn/casuser/Warfarin/AF/tCox.sas)); 38 %let _baseurl = %nrquote(%nrstr(https://vfl-032.engage.sas.com/SASStudio/)); 39 %let _execenv = %nrquote(%nrstr(SASStudio)); 40 %symdel _dataout_mime_type _dataout_name _dataout_url _dataout_table / nowarn; 41 %let _sasws_ = %bquote(%sysfunc(getoption(work))); 42 %let _saswstemp_ = %bquote(%sysfunc(getoption(work))); 43 44 /* Detect SAS/Graph and setup graph options */ 45 data _null_; 46 length rc $255; 47 call symput("graphinit",""); 48 call symput("graphterm",""); 49 rc=tslvl('sasxgopt','n'); 50 _error_=0; 51 if (rc^=' ') then do; 52 call symput("graphinit","goptions reset=all gsfname=_gsfname;"); 53 call symput("graphterm","goptions noaccessible;"); 54 end; 55 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 477.37k OS Memory 45220.00k Timestamp 05/04/2025 06:46:08 PM Step Count 207 Switch Count 0 Page Faults 0 Page Reclaims 44 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 40 56 data _null_; 57 length rc 4; 58 rc=sysprod("PRODNUM002"); 59 if (rc^=1) then do; 60 call symput("graphinit",""); 61 call symput("graphterm",""); 62 end; 63 run; NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 476.37k OS Memory 45220.00k Timestamp 05/04/2025 06:46:08 PM Step Count 208 Switch Count 0 Page Faults 0 Page Reclaims 34 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 64 65 /* Setup ODS destinations */ 66 ods _all_ close; SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to E0214C96-7A6A-914C-8BDE-3A576B82DCF6 67 %studio_results_directory; 68 filename _htmlout "&_results_prefix_..html"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-E0214C96-7A6A-914C-8BDE-3A576B82DCF6 69 filename _listout "&_results_prefix_..lst"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-E0214C96-7A6A-914C-8BDE-3A576B82DCF6 70 filename _gsfname temp; 71 filename _dataout "&_results_prefix_..dat"; SYMBOLGEN: Macro variable _RESULTS_PREFIX_ resolves to !COMPUTESERVER_TMP_PATH/results-E0214C96-7A6A-914C-8BDE-3A576B82DCF6 72 ods autonavigate off; 73 ods graphics on; 74 ods html5 (id=web) METATEXT='http-equiv="Content-Security-Policy" content="default-src ''none''; style-src ''unsafe-inline''; 74 ! img-src data: ;"' device=png gpath="&_saswstemp_" path="&_saswstemp_" encoding=utf8 file=_htmlout (title='Results:tCox.sas') 74 ! style=Illuminate options(bitmap_mode='inline' outline='on' svg_mode='inline' css_prefix=".ods_&SYS_COMPUTE_JOB_ID" SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serve r-1168f934-cccb-4083-84ef-181aa798017b-19880 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. SYMBOLGEN: Macro variable _SASWSTEMP_ resolves to /opt/sas/viya/config/var/tmp/compsrv/default/a412f8f4-8993-48e2-be38-5f0f6d7a51cd/SAS_work2D5800000218_sas-compute-serve r-1168f934-cccb-4083-84ef-181aa798017b-19880 SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. 74 ! e=Illuminate options(bitmap_mode='inline' outline='on' svg_mode='inline' css_prefix=".ods_&SYS_COMPUTE_JOB_ID" 74 ! body_id="div_&SYS_COMPUTE_JOB_ID" ); SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to E0214C96-7A6A-914C-8BDE-3A576B82DCF6 SYMBOLGEN: Macro variable SYS_COMPUTE_JOB_ID resolves to E0214C96-7A6A-914C-8BDE-3A576B82DCF6 NOTE: Writing HTML5(WEB) Body file: _HTMLOUT 75 ods listing file=_listout; SYMBOLGEN: Macro variable GRAPHINIT resolves to goptions reset=all gsfname=_gsfname; 76 &graphinit; 77 %studio_initialize_custom_output; 78 /* endregion */ 79 80 proc univariate data = d202_raw; 81 var ageY; 82 run; NOTE: The PROCEDURE UNIVARIATE printed pages 140-141. NOTE: PROCEDURE UNIVARIATE used (Total process time): real time 0.05 seconds user cpu time 0.05 seconds system cpu time 0.01 seconds memory 1701.81k OS Memory 47528.00k Timestamp 05/04/2025 06:46:08 PM Step Count 209 Switch Count 0 Page Faults 0 Page Reclaims 57 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 8 SYMBOLGEN: Macro variable GRAPHTERM resolves to goptions noaccessible; 83 84 /* region: Generated postamble */ 85 /* Close ODS destinations */ 86 &graphterm; ;*';*";*/;run;quit; 87 quit;run; 88 ods html5 (id=web) close; 89 ods listing close; 90 %if %sysfunc(fileref(_gsfname)) lt 0 %then %do; 91 filename _gsfname clear; NOTE: Fileref _GSFNAME has been deassigned. 92 %end; 93 %studio_capture_custom_output; SYMBOLGEN: Macro variable _DATAOUT_NAME resolves to SYMBOLGEN: Macro variable _DATAOUT_MIME_TYPE resolves to 94 /* endregion */ 95   ... View more

When I run code in base SAS (version 9.4), I am getting this mysterious SAS Message Log window now that my computer has been switched to Windows 11. I never saw it before under Windows 10, Windows 7 or earlier operating systems. I don't want this window to appear. How can I stop it?     I note that if my code includes PROC PRINTTO LOG= to send the log to a text file, that is when I get this mysterious window. If I run the same code without PROC PRINTTO, the window does not appear.   So how do I get rid of it? ... View more

Hello World, The following page explains what Threaded Applications are: "SAS threaded applications are SAS procedures that thread input, output, and numeric operations".  Is there a list somewhere that shows what these proc steps are? I tested proc means and proc summary, but the option DBSLICEPARM=(THREADED_APPS, 2) has no effect.   Options That Affect Threaded Reads ... View more

The correct code is as follows. But I used almost an hour to figure it out and still have questions about it. (ps: I made these mistakes while doing the practice questions on page 285 in Macro1: essentials course notes pdf, that was a complex question.)   1) The correct code and results %macro ctrylist(ctry1)/minoperator; %let list1=AT AU CA CH; %put &list1; %if &ctry1 in &list1 %then %do; %put &ctry1; %end; %else %do; %put ERROR: &ctry1 is an invalid country code.; %put ERROR: Valid country codes include &list1.; %end; %mend ctrylist; %ctrylist(AU); %ctrylist(zz);   2) How I used almost an hour to make mistakes and correct it. At first I wrote something like this (I did not know what's wrong with my mind then and forgot to write the semicolon ; behind the two %put statements in the %else %do statement, also when debugging I kept ignore this obvious mistake and costed me a lot of time to figure out the problem): %macro ctrylist(ctry1); %let list1=AT AU CA CH; %put &list1; %if &ctry1 in &list1 %then %do; %put &ctry1; %end; %else %do; %put ERROR: &ctry1 is an invalid country code. %put ERROR: Valid country codes include &list1. %end; %mend ctrylist; %ctrylist(AU); %ctrylist(zz); And I got error message like this: I am not good at using error message to help debug, also did not pay attention to where did the error occur. The possible mistakes came into my mind were: 1) maybe the %if &ctry1 in &list1  statement has problem, maybe I should try a &list with commas that separate the values, and 2) maybe the first %put in the first %if %then statement is not necessary. Then I tried something like this: %macro ctrylist2(ctry2); %let list2='AT','AU','CA','CH'; %if &ctry2 in (&list2) %then %do; &ctry2; %end; %else %do; %put ERROR: &ctry2 is an invalid country code. %put ERROR: Valid country codes include &list2. %end; %mend ctrylist2; %ctrylist(AU); %ctrylist(zz); And I got the same error message: Then I did not know what to do. The only thing came into my mind was, maybe an option minoperator should be added (because in that section in the material there was content of minoperator), then I tried something like this: %macro ctrylist2(ctry2)/minoperator; %let list2='AT','AU','CA','CH'; %if &ctry2 in (&list2) %then %do; %put &ctry2; %end; %else %do; %put ERROR: &ctry2 is an invalid country code. %put ERROR: Valid country codes include &list2. %end; %mend ctrylist2; %ctrylist(AU); %ctrylist(zz); And I got the exact same error message. I did not know why I kept ignore the obvious mistake that there was no semicolon ; after the two %put statements, I even did not put my eyesight at the two statements, like I kept ignore an obvious, major mistake intentionally. Then I think I cannot figure it out and was going to post the problem into this community. But right before I post the problem my attention and eyesight somehow switched to and see the mistake: I did not write semicolon ; after the two statements. And I corrected it.   3) What I learnt from the experience: a) do not in a hurry and too eager to find out what is wrong, just look into every details of the code, b)look at the error message, especially where does the error message occur,  c) when writing complex macros, keep relax and keep attention focused and enjoy, do not rush. d) When writing macro, it is easy for me to forget the semicolon, or sometimes added unnecessary semicolon or put semicolon at wrong place, I made this mistake twice before, the scenario is like(I forget another example which use a %if %then and where statement in a data step, which has the similar usage of the semicolon, could anyone come up with a similar example, many thanks) this, for this incorrect code I should put the semicolon after the &&b&i right before run; statement and after the %end; statement: data a; set %do i=1 to &sqlobs; &&b&i; %end; run;   4) I still have questions about the codes:  a) do %if &ctry1 in &list1 and %if &ctry2 in (&list2) work the same way? I mean the syntax of the %if in statement, the first one does not need the brackets and the second one does need the brackets, isn't it? %let list1=AT AU CA CH; %put &list1; %if &ctry1 in &list1 %then %do; %put &ctry1; %end; %let list2='AT','AU','CA','CH'; %if &ctry2 in (&list2) %then %do; %put &ctry2; %end; b) what does the minoperator options do? why do I need it after the macro name? Without it I got a similar error message (only without the error message about %put). %macro ctrylist2(ctry2); %let list2='AT','AU','CA','CH'; %if &ctry2 in (&list2) %then %do; %put &ctry2; %end; %else %do; %put ERROR: &ctry2 is an invalid country code.; %put ERROR: Valid country codes include &list2.; %end; %mend ctrylist2; %ctrylist(AU); %ctrylist(zz); ... View more

Hello everyone, After installing SAS Enterprise Miner I initially encountered an issue related to the environment file URL. I resolved it by following a solution shared here (https://communities.sas.com/t5/Administration-and-Deployment/SAS-Enterprise-Miner-environment-file/td-p/372993). but upon trying to log in afterward, I encountered a new error message:   "The connection to the SAS Enterprise Miner Server has been lost and it may be restarting. Wait a moment and select YES to attempt to reconnect, select NO to close the application." Has anyone faced a similar issue or have any suggestions on how to resolve this? Thanks in advance for your help. ... View more