The macro will not compile because the %END statement is missing the closing semicolon.
The SAS code the macro is generating is gibberish also but it is the mistake with the %END statement that is causing the macro not be compiled.
1162 %MACRO SQLLLOP;
1163 %DO FECHA=22646 %TO 22650;
1164 PROC SQL;
1165 CREATE TABLE WORK.TEST_TABLE&FECHA. AS
1166 SELECT
1167
1168 t1.V1,
1169 t1.SEX,
1170 t1.V2
1171
1172 FROM DATA_HAVE;
1173
1174 WHERE t1.V1 = &FECHA.;
1175
1176 QUIT;
1177
1178 /* OTHER PROC SQL*/
1179
1180 PROC SQL;
1181
1182 CREATE TABLE WORK.GROUP_TABLE&FECHA. AS
1183
1184 SELECT t1.SEX,
1185
1186 COUNT(t1.V1) AS TOTAL,
1187
1188 FROM WORK.TEST_TABLE&FECHA.
1189
1190 GROUP BY t1.SEX;
1191
1192 QUIT;
1193
1194 %END
1195
1196 %MEND;
NOTE: Extraneous text on %END statement ignored.
Since the %END statement "ate" the %MEND statement you need to submit another one. Or restart your SAS session and try again.
... View more