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; %end; %mend; %Esegui;
... View more