Failed Log -
1 The SAS System 19:52 Sunday, August 29, 2021
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program (4)';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTNAME='';
7 %LET _SASPROGRAMFILE=;
8
9 ODS _ALL_ CLOSE;
10 OPTIONS DEV=ACTIVEX;
11 GOPTIONS XPIXELS=0 YPIXELS=0;
12 FILENAME EGSR TEMP;
13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14 STYLE=HtmlBlue
15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
16 NOGTITLE
17 NOGFOOTNOTE
18 GPATH=&sasworklocation
SYMBOLGEN: Macro variable SASWORKLOCATION resolves to
"/localwork2/SAS_work29EB0000FD28_hkpa2ls0136/SAS_work57120000FD28_hkpa2ls0136/"
19 ENCODING=UTF8
20 options(rolap="on")
21 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 options symbolgen mlogic mprint;
25
26 %MACRO TEST(ds,fld_nm);
27
28 libname dim "<location>" access =r;
29
30 proc sql;
31 create table test as
32 select distinct &fld_nm. from dim.&ds.;
33 quit;
34
35 data test1;
36 set test(WHERE=(&fld_nm. EQ 'IND'));
37 CALL SYMPUT('N',_N_);
38 CALL SYMPUTX(CAT('CTY',_N_),&fld_nm.);
39 run;
40
41 %PUT &N.;
42
43 %include "location";
44
45 %MEND;
46
47 %test(dim_product,ctry_cde);
MLOGIC(TEST): Beginning execution.
MLOGIC(TEST): Parameter DS has value dim_product
MLOGIC(TEST): Parameter FLD_NM has value ctry_cde
MPRINT(TEST): libname dim "<location>" access =r;
NOTE: Libref DIM was successfully assigned as follows:
Engine: V9
Physical Name: <location>
MPRINT(TEST): proc sql;
2 The SAS System 19:52 Sunday, August 29, 2021
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
SYMBOLGEN: Macro variable DS resolves to dim_product
MPRINT(TEST): create table test as select distinct ctry_cde from dim.dim_product;
NOTE: Compression was disabled for data set WORK.TEST because compression overhead would increase the size of the data set.
NOTE: Table WORK.TEST created, with 8 rows and 1 columns.
MPRINT(TEST): quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
MPRINT(TEST): data test1;
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
MPRINT(TEST): set test(WHERE=(ctry_cde EQ 'IND'));
MPRINT(TEST): CALL SYMPUT('N',_N_);
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
MPRINT(TEST): CALL SYMPUTX(CAT('CTY',_N_),ctry_cde);
MPRINT(TEST): run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
3998:233
NOTE: Compression was disabled for data set WORK.TEST1 because compression overhead would increase the size of the data set.
NOTE: There were 1 observations read from the data set WORK.TEST.
WHERE ctry_cde='IND';
NOTE: The data set WORK.TEST1 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
MLOGIC(TEST): %PUT &N.
SYMBOLGEN: Macro variable N resolves to 1
1
ERROR: The %DO statement is not valid in open code.
MPRINT(TEST): DATA _TMP;
SYMBOLGEN: Macro variable DS resolves to dim_product
MPRINT(TEST): SET dim.dim_product;
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
SYMBOLGEN: && resolves to &.
WARNING: Apparent symbolic reference I not resolved.
SYMBOLGEN: Unable to resolve the macro variable reference &i
WARNING: Apparent symbolic reference CTY not resolved.
WARNING: Apparent symbolic reference I not resolved.
MPRINT(TEST): where ctry_cde eq "&cty&i.";
MPRINT(TEST): run;
NOTE: There were 0 observations read from the data set DIM.DIM_PRODUCT.
WHERE ctry_cde='&cty&i.';
NOTE: The data set WORK._TMP has 0 observations and 31 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.02 seconds
MPRINT(TEST): proc print data=_tmp;
MPRINT(TEST): run;
3 The SAS System 19:52 Sunday, August 29, 2021
NOTE: No observations in data set WORK._TMP.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
ERROR: The %END statement is not valid in open code.
MLOGIC(TEST): Ending execution.
60
61 GOPTIONS NOACCESSIBLE;
62 %LET _CLIENTTASKLABEL=;
63 %LET _CLIENTPROCESSFLOWNAME=;
64 %LET _CLIENTPROJECTPATH=;
65 %LET _CLIENTPROJECTNAME=;
66 %LET _SASPROGRAMFILE=;
67
68 ;*';*";*/;quit;run;
69 ODS _ALL_ CLOSE;
70
71
72 QUIT; RUN;
73
Success Log (without INCLUDE) -
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 options symbolgen mlogic mprint;
25
26 %MACRO TEST(ds,fld_nm);
27
28 libname dim "<location>" access =r;
29
30 proc sql;
31 create table test as
32 select distinct &fld_nm. from dim.&ds.;
33 quit;
34
35 data test1;
36 set test(WHERE=(&fld_nm. EQ 'IND'));
37 CALL SYMPUT('N',_N_);
38 CALL SYMPUTX(CAT('CTY',_N_),&fld_nm.);
39 run;
40
41 %PUT &N.;
42 /*%PUT &CTY1. &CTY5.;*/
43
44 /*%include "<location>";*/
45
46 %DO I=1 %TO &N.;
47
48 DATA _TMP;
49 SET dim.&ds.;
50 where &fld_nm. eq "&&cty&i.";
51 run;
52
53 PROC PRINT DATA=_TMP;
54 RUN;
55
2 The SAS System 19:52 Sunday, August 29, 2021
56 %END;
57
58
59 %MEND;
60
61 %test(dim_product,ctry_cde);
MLOGIC(TEST): Beginning execution.
MLOGIC(TEST): Parameter DS has value dim_product
MLOGIC(TEST): Parameter FLD_NM has value ctry_cde
MPRINT(TEST): libname dim “<Location>" access =r;
NOTE: Libref DIM was successfully assigned as follows:
Engine: V9
Physical Name: <Location>
MPRINT(TEST): proc sql;
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
SYMBOLGEN: Macro variable DS resolves to dim_product
MPRINT(TEST): create table test as select distinct ctry_cde from dim.dim_product;
NOTE: Compression was disabled for data set WORK.TEST because compression overhead would increase the size of the data set.
NOTE: Table WORK.TEST created, with 8 rows and 1 columns.
MPRINT(TEST): quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
MPRINT(TEST): data test1;
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
MPRINT(TEST): set test(WHERE=(ctry_cde EQ 'IND'));
MPRINT(TEST): CALL SYMPUT('N',_N_);
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
MPRINT(TEST): CALL SYMPUTX(CAT('CTY',_N_),ctry_cde);
MPRINT(TEST): run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
3651:233
NOTE: Compression was disabled for data set WORK.TEST1 because compression overhead would increase the size of the data set.
NOTE: There were 1 observations read from the data set WORK.TEST.
WHERE ctry_cde='IND';
NOTE: The data set WORK.TEST1 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.13 seconds
cpu time 0.02 seconds
MLOGIC(TEST): %PUT &N.
SYMBOLGEN: Macro variable N resolves to 1
1
SYMBOLGEN: Macro variable N resolves to 1
MLOGIC(TEST): %DO loop beginning; index variable I; start value is 1; stop value is 1; by value is 1.
MPRINT(TEST): DATA _TMP;
SYMBOLGEN: Macro variable DS resolves to dim_product
MPRINT(TEST): SET dim.dim_product;
SYMBOLGEN: Macro variable FLD_NM resolves to ctry_cde
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable I resolves to 1
SYMBOLGEN: Macro variable CTY1 resolves to IND
MPRINT(TEST): where ctry_cde eq "IND";
3 The SAS System 19:52 Sunday, August 29, 2021
MPRINT(TEST): run;
NOTE: There were 55 observations read from the data set DIM.DIM_PRODUCT.
WHERE ctry_cde='IND';
NOTE: The data set WORK._TMP has 55 observations and 31 variables.
NOTE: Compressing data set WORK._TMP increased size by 100.00 percent.
Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
MPRINT(TEST): PROC PRINT DATA=_TMP;
MPRINT(TEST): RUN;
NOTE: There were 55 observations read from the data set WORK._TMP.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.15 seconds
cpu time 0.16 seconds
MLOGIC(TEST): %DO loop index variable I is now 2; loop will not iterate again.
MLOGIC(TEST): Ending execution.
... View more
