topic double loop in a macro statement in SAS Enterprise Guide

double loop in a macro statement

FediSimi_333 — Fri, 21 Jun 2024 11:57:58 GMT

Can someone help me? I can't see my error 😞

&column_name. and &product. are already defined as list of name separated by *

%macro Esegui;

%do i = 1 %to &n_column_sales.;

%let Variabile = %SCAN(&column_name.,&i.,'*');

%do j= 1 %to 2

%let product_ = %SCAN(&product.,&j.,'*');

proc sql;

create table lib.&variabile. as

select

count(column) as quanti

, CG

, &variabile.

from tab

where product= "&product_."

group by 2,3

;quit;

%end;

%mend;

%Esegui;

Re: double loop in a macro statement

PaigeMiller — Fri, 21 Jun 2024 13:10:34 GMT

When you have a macro and are trying to debug it, turn on the macro debugging options by running this command

options mprint;

and then run the macro, and show us the entire log for this macro (or the log down to this particular error).

Re: double loop in a macro statement

Astounding — Fri, 21 Jun 2024 12:46:30 GMT

Well, you didn't post anything to show what the error might be. So here are a couple of guesses.

There's a missing semicolon to end this statement: %do j= 1 %to 2

The delimiter for the %scan function is likely incorrect. Macro language does not need quotes to show what is text and what is a significant name. Instead, macro language uses & to show what is a significant name. So '*' as a delimiter means to use asterisks and single quotes as possible delimiters. It gets you the right answer as along as your values do not contain any single quotes. (Of course if your values do include single quotes, those might generate other problems.

Re: double loop in a macro statement

FediSimi_333 — Fri, 21 Jun 2024 13:21:32 GMT

Many thanks for your suggestions!

Re: double loop in a macro statement

FediSimi_333 — Fri, 21 Jun 2024 13:25:16 GMT

that semicolon was driving me cr4sy! Many thanks!! 😁