topic Macro Help in SAS Programming

topic Macro Help in SAS Programming https://communities.sas.com/t5/SAS-Programming/Macro-Help/m-p/95418#M20091 <HTML><HEAD></HEAD><BODY><P>Is someone able to tell me why SAS is giving me an error on this macro?</P><P></P><P></P><P>3705      %SCALETABLE2 ('01. WebSat', q1_web_sat_1 ,qtouch_websat_1  ,qgeneric_websat,</P><P>3705! TEMP_WEBSAT_US );</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>3      AND  (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0</P><P>3   ! end)) AS TopTwoBox FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1 EQ ('5')) AND (&VAR2 IN ('5'))</P><P>          -</P><P>          22</P><P>          200</P><P>3   ! AND (&VAR3 IN ('5'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1',</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>5     '2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN</P><P>5   ! ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS TopBox FORMAT=percent9.1, SUM(CASE WHEN</P><P>                                                -</P><P>                                                22</P><P>                                                200</P><P>5   ! ((&VAR1 EQ ('4')) AND (&VAR2 EQ ('4')) AND (&VAR3 EQ ('4'))) THEN 1 ELSE 0 end)/ SUM(CASE</P><P>5   ! WHEN ((</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>6     &VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN</P><P>6   ! ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS Four FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1</P><P>                                                -</P><P>                                                22</P><P>                                                200</P><P>6   !  EQ ('3')) AND (&VAR2 EQ ('3')) AND (&VAR3 EQ ('3'))) THEN 1 ELSE 0 end)/ SUM(</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>8     CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3</P><P>8   !  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS Three FORMAT=percent9.1, SUM(CASE WHEN</P><P>                                                    -</P><P>                                                    22</P><P>                                                    200</P><P>8   ! ((&VAR1 IN ('1','2')) AND (&VAR2 IN ('1','2')) AND (&VAR3 IN ('1','2')))</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>9      THEN 1 ELSE 0 end)  / SUM (CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN</P><P>9   ! ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS</P><P>                                                                                      -</P><P>                                                                                      22</P><P>                                                                                      200</P><P>9   ! BottomTwoBox FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND</P><P>ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +,</P><P>              ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT,</P><P>              FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE,</P><P>              LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.</P><P></P><P>ERROR 200-322: The symbol is not recognized and will be ignored.</P><P></P><P></P><P>The actual Code is below:</P><P>%MACRO SCALETABLE2 (TTL, VAR1, VAR2, VAR3, DST_NM);</P><P></P><P>PROC SQL;</P><P>CREATE TABLE &DST_NM AS</P><P>SELECT &TTL as Category,</P><P>        MTH AS Month FORMAT=MONYY7.,</P><P></P><P>SUM(CASE WHEN ((&VAR1 IN ('4','5')) AND (&VAR2 IN('4','5')) AND (&VAR3 IN ('4','5'))) THEN 1 ELSE 0 end) / SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND  (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS TopTwoBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('5')) AND (&VAR2 IN ('5')) AND (&VAR3 IN ('5'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS TopBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('4')) AND (&VAR2 EQ ('4')) AND (&VAR3 EQ ('4'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Four FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('3')) AND (&VAR2 EQ ('3')) AND (&VAR3 EQ ('3'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Three FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 IN ('1','2')) AND (&VAR2 IN ('1','2')) AND (&VAR3 IN ('1','2'))) THEN 1 ELSE 0 end)  / SUM (CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS BottomTwoBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Base    </P><P></P><P>FROM TEMP</P><P>GROUP BY 2</P><P>;</P><P></P><P>QUIT;</P><P>RUN;</P><P>%MEND;</P></BODY></HTML> Tue, 04 Jun 2013 23:31:39 GMT ejimenez 2013-06-04T23:31:39Z Macro Help https://communities.sas.com/t5/SAS-Programming/Macro-Help/m-p/95418#M20091 <HTML><HEAD></HEAD><BODY><P>Is someone able to tell me why SAS is giving me an error on this macro?</P><P></P><P></P><P>3705      %SCALETABLE2 ('01. WebSat', q1_web_sat_1 ,qtouch_websat_1  ,qgeneric_websat,</P><P>3705! TEMP_WEBSAT_US );</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>3      AND  (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0</P><P>3   ! end)) AS TopTwoBox FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1 EQ ('5')) AND (&VAR2 IN ('5'))</P><P>          -</P><P>          22</P><P>          200</P><P>3   ! AND (&VAR3 IN ('5'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1',</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>5     '2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN</P><P>5   ! ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS TopBox FORMAT=percent9.1, SUM(CASE WHEN</P><P>                                                -</P><P>                                                22</P><P>                                                200</P><P>5   ! ((&VAR1 EQ ('4')) AND (&VAR2 EQ ('4')) AND (&VAR3 EQ ('4'))) THEN 1 ELSE 0 end)/ SUM(CASE</P><P>5   ! WHEN ((</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>6     &VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN</P><P>6   ! ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS Four FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1</P><P>                                                -</P><P>                                                22</P><P>                                                200</P><P>6   !  EQ ('3')) AND (&VAR2 EQ ('3')) AND (&VAR3 EQ ('3'))) THEN 1 ELSE 0 end)/ SUM(</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>8     CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3</P><P>8   !  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS Three FORMAT=percent9.1, SUM(CASE WHEN</P><P>                                                    -</P><P>                                                    22</P><P>                                                    200</P><P>8   ! ((&VAR1 IN ('1','2')) AND (&VAR2 IN ('1','2')) AND (&VAR3 IN ('1','2')))</P><P>NOTE: Line generated by the invoked macro "SCALETABLE2".</P><P>9      THEN 1 ELSE 0 end)  / SUM (CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN</P><P>9   ! ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end)) AS</P><P>                                                                                      -</P><P>                                                                                      22</P><P>                                                                                      200</P><P>9   ! BottomTwoBox FORMAT=percent9.1, SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND</P><P>ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +,</P><P>              ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT,</P><P>              FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE,</P><P>              LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.</P><P></P><P>ERROR 200-322: The symbol is not recognized and will be ignored.</P><P></P><P></P><P>The actual Code is below:</P><P>%MACRO SCALETABLE2 (TTL, VAR1, VAR2, VAR3, DST_NM);</P><P></P><P>PROC SQL;</P><P>CREATE TABLE &DST_NM AS</P><P>SELECT &TTL as Category,</P><P>        MTH AS Month FORMAT=MONYY7.,</P><P></P><P>SUM(CASE WHEN ((&VAR1 IN ('4','5')) AND (&VAR2 IN('4','5')) AND (&VAR3 IN ('4','5'))) THEN 1 ELSE 0 end) / SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND  (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS TopTwoBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('5')) AND (&VAR2 IN ('5')) AND (&VAR3 IN ('5'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS TopBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('4')) AND (&VAR2 EQ ('4')) AND (&VAR3 EQ ('4'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Four FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 EQ ('3')) AND (&VAR2 EQ ('3')) AND (&VAR3 EQ ('3'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Three FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 IN ('1','2')) AND (&VAR2 IN ('1','2')) AND (&VAR3 IN ('1','2'))) THEN 1 ELSE 0 end)  / SUM (CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3  IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS BottomTwoBox FORMAT=percent9.1,</P><P>SUM(CASE WHEN ((&VAR1 IN ('1','2','3','4','5')) AND (&VAR2 IN ('1','2','3','4','5')) AND (&VAR3 IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Base    </P><P></P><P>FROM TEMP</P><P>GROUP BY 2</P><P>;</P><P></P><P>QUIT;</P><P>RUN;</P><P>%MEND;</P></BODY></HTML> Tue, 04 Jun 2013 23:31:39 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Help/m-p/95418#M20091 ejimenez 2013-06-04T23:31:39Z Re: Macro Help https://communities.sas.com/t5/SAS-Programming/Macro-Help/m-p/95419#M20092 <HTML><HEAD></HEAD><BODY><P>Syntax works for me. I suspect that the actual error is earlier in the program. Most likely missmatched () or quotes.</P><P></P><P><SPAN style="font-family: 'courier new', courier;">326  data temp;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">327   length q1_web_sat_1  qtouch_websat_1   qgeneric_websat $1;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">328   length mth 8;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">329  run;</SPAN></P><P></P><P></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: Variable q1_web_sat_1 is uninitialized.</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: Variable qtouch_websat_1 is uninitialized.</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: Variable qgeneric_websat is uninitialized.</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: Variable mth is uninitialized.</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: The data set WORK.TEMP has 1 observations and 4 variables.</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: DATA statement used (Total process time):</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">      real time           0.00 seconds</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">      cpu time            0.01 seconds</SPAN></P><P></P><P><SPAN style="font-family: 'courier new', courier;">330  options mprint;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">331  %SCALETABLE2 ('01. WebSat', q1_web_sat_1 ,qtouch_websat_1  ,qgeneric_websat,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">332   TEMP_WEBSAT_US );</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">MPRINT(SCALETABLE2):   PROC SQL;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">MPRINT(SCALETABLE2):   CREATE TABLE TEMP_WEBSAT_US AS SELECT '01. WebSat' as Category, MTH AS Month FORMAT=MONYY7., SUM(CASE WHEN ((q1_web_sat_1 IN</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">('4','5')) AND (qtouch_websat_1 IN('4','5')) AND (qgeneric_websat IN ('4','5'))) THEN 1 ELSE 0 end) / SUM(CASE WHEN ((q1_web_sat_1 IN</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">('1','2','3','4','5')) AND (qtouch_websat_1 IN ('1','2','3','4','5')) AND (qgeneric_websat IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS TopTwoBox</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">FORMAT=percent9.1, SUM(CASE WHEN ((q1_web_sat_1 EQ ('5')) AND (qtouch_websat_1 IN ('5')) AND (qgeneric_websat IN ('5'))) THEN 1 ELSE 0 end)/ SUM(CASE</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">WHEN ((q1_web_sat_1 IN ('1','2','3','4','5')) AND (qtouch_websat_1 IN ('1','2','3','4','5')) AND (qgeneric_websat IN ('1','2','3','4','5'))) THEN 1</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">ELSE 0 end) AS TopBox FORMAT=percent9.1, SUM(CASE WHEN ((q1_web_sat_1 EQ ('4')) AND (qtouch_websat_1 EQ ('4')) AND (qgeneric_websat EQ ('4'))) THEN 1</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">ELSE 0 end)/ SUM(CASE WHEN ((q1_web_sat_1 IN ('1','2','3','4','5')) AND (qtouch_websat_1 IN ('1','2','3','4','5')) AND (qgeneric_websat IN</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Four FORMAT=percent9.1, SUM(CASE WHEN ((q1_web_sat_1 EQ ('3')) AND (qtouch_websat_1 EQ ('3')) AND</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">(qgeneric_websat EQ ('3'))) THEN 1 ELSE 0 end)/ SUM(CASE WHEN ((q1_web_sat_1 IN ('1','2','3','4','5')) AND (qtouch_websat_1 IN ('1','2','3','4','5'))</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">AND (qgeneric_websat IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS Three FORMAT=percent9.1, SUM(CASE WHEN ((q1_web_sat_1 IN ('1','2')) AND</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">(qtouch_websat_1 IN ('1','2')) AND (qgeneric_websat IN ('1','2'))) THEN 1 ELSE 0 end) / SUM (CASE WHEN ((q1_web_sat_1 IN ('1','2','3','4','5')) AND</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">(qtouch_websat_1 IN ('1','2','3','4','5')) AND (qgeneric_websat IN ('1','2','3','4','5'))) THEN 1 ELSE 0 end) AS BottomTwoBox FORMAT=percent9.1,</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">SUM(CASE WHEN ((q1_web_sat_1 IN ('1','2','3','4','5')) AND (qtouch_websat_1 IN ('1','2','3','4','5')) AND (qgeneric_websat IN ('1','2','3','4','5')))</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">THEN 1 ELSE 0 end) AS Base FROM TEMP GROUP BY 2 ;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: Table WORK.TEMP_WEBSAT_US created, with 1 rows and 8 columns.</SPAN></P><P></P><P></P><P><SPAN style="font-family: 'courier new', courier;">MPRINT(SCALETABLE2):   QUIT;</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">NOTE: PROCEDURE SQL used (Total process time):</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">      real time           0.63 seconds</SPAN></P><P><SPAN style="font-family: 'courier new', courier;">      cpu time            0.06 seconds</SPAN></P><P></P><P></P><P></P><P></P><P><SPAN style="font-family: 'courier new', courier;">MPRINT(SCALETABLE2):   RUN;</SPAN></P></BODY></HTML> Wed, 05 Jun 2013 00:14:56 GMT https://communities.sas.com/t5/SAS-Programming/Macro-Help/m-p/95419#M20092 Tom 2013-06-05T00:14:56Z