topic Re: Nested looping in SAS Programming

Nested looping

Kiteulf — Fri, 26 Feb 2021 12:44:14 GMT

I have files like this:

Test_1_1

Test_1_2

Test_1_3

Test_1_4

Test_2_1

Test_2_2

Test_2_3

Test_2_4

etc...

I need to do a nested loop and can I use both the variables s and j to call up each file?

%macro sloop;

%do s= 1 %to 2;
do j= 1 to 5;

filename out_pipe "\\xxxx_&s_&j..xml" ;

DATA Test4_SME_&s_&j ;
set Temp2.Test_&s_&j;

run;

%END;
%MEND SLOOP;
%SLOOP;

Re: Nested looping

PaigeMiller — Fri, 26 Feb 2021 13:04:47 GMT

I need to do a nested loop and can I use both the variables s and j to call up each file?

Yes.

One problem with the code you show is that it need two %DO loops. You have one %DO loop and one DO loop, which won't work here.

Re: Nested looping

Kiteulf — Fri, 26 Feb 2021 13:21:06 GMT

I did some changes:

%macro sloop;

%do s= 1 %to 2;
%do j= 1 %to 5;

filename out_pipe "\\xxxx_&s_&j..xml" ;

DATA test_&s_&j ;
set Temp2.test_&s_&j;

%END;%END;
%MEND SLOOP;
%SLOOP;

However it says:

test_&s_1
_
22
200
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.

Re: Nested looping

PaigeMiller — Fri, 26 Feb 2021 13:27:21 GMT

Please show us the log. First, turn on the proper option by putting this command at the top of your code and then run it again.

options mprint;

Show us the entire log (not selected portions) for this macro by copying it as text and pasting it into the window that appears when you click on the </> icon, this formats the log properly. I will not try to decipher logs that are not formatted properly.

Re: Nested looping

Kiteulf — Fri, 26 Feb 2021 13:42:01 GMT

1 The SAS System 13:19 Friday, February 26, 2021

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='RDW-174 DenmarkCreditBureau_Felix';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\Colosas SAS prosjekter\RDWs.egp';
6 %LET _CLIENTPROJECTPATHHOST='ZLE02763';
7 %LET _CLIENTPROJECTNAME='RDWs.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28
29 options mprint;
30
31
32 %macro sloop;
33
34 %do s= 1 %to 2;
35 %do j= 1 %to 5;
36
37 filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
37 ! CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&&s_&j..xml" ;
38
39
40
41
42
43
44 DATA DK_PANDE4_SME_&s_&j ;
45 set Temp2.DK_PANDE3_SME_&s_&j;
46
47
48 %END;%END;
49 %MEND SLOOP;
50 %SLOOP;
WARNING: Apparent symbolic reference S_1 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_1.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
2 The SAS System 13:19 Friday, February 26, 2021

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_1 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_1;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_2 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_2.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_1 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_2 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_2;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_3 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_3.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_2 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_2 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
3 The SAS System 13:19 Friday, February 26, 2021

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_3 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_3;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_4 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_4.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_3 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_3 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_4 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_4;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_5 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_5.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_4 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
4 The SAS System 13:19 Friday, February 26, 2021

WARNING: Data set WORK.S_4 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_5 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_5;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_1 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_1.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_5 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_5 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_1 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_1;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_2 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_2.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
5 The SAS System 13:19 Friday, February 26, 2021

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_1 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

WARNING: Apparent symbolic reference S_4 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_4.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_3 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_3 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_4 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_4;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_5 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_5.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_4 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_4 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_5;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
51
52 %LET _CLIENTTASKLABEL=;
53 %LET _CLIENTPROCESSFLOWNAME=;
54 %LET _CLIENTPROJECTPATH=;
55 %LET _CLIENTPROJECTPATHHOST=;
56 %LET _CLIENTPROJECTNAME=;
57 %LET _SASPROGRAMFILE=;
58 %LET _SASPROGRAMFILEHOST=;
59
60 ;*';*";*/;quit;run;
____
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_5 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_5 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

61 ODS _ALL_ CLOSE;
62
63
64 QUIT; RUN;
65

Re: Nested looping

PaigeMiller — Fri, 26 Feb 2021 13:47:09 GMT

set Temp2.DK_PANDE3_SME_&s_&j;

This resolves to &s_1 when &j = 1. There is no macro variable by that name.

To tell SAS that &s is a macro variable by itself, and the macro variable name does not continue with _&j, you must use a dot to indicate the end of the macro variable name.

set Temp2.DK_PANDE3_SME_&s._&j;