topic Re: the log note that :% Discovery of character operands by EVAL or% IF functions in SAS Programming

the log note that :% Discovery of character operands by EVAL or% IF functions

HannaZhang — Mon, 05 Aug 2019 07:29:24 GMT

Hi，,all;

I tried to write some macro statements.but they did not work and I can not find the mistakes,here are the codes.Thanks.

%macro T71122;

proc sort data=test2;
	by OBS;
run;
data test3;
	set test2;
	if obs=1 then delete;
run;
data test3;
	set test3;
	obs=obs-1;
run;

proc sql;
	select distinct AMTEST into: AMTESTlist separated by ":" from test3 ;
run;
quit;

%let num=1;
%do %while(%scan(&AMTESTlist.,&num.,%str(:)) NE %str());
	%let AMTESTtest=%scan(&AMTESTlist.,&num.,%str(:));
%let num=%eval(&num.+1);

%end;

%mend;
%T71122;

Re: the log note that :% Discovery of character operands by EVAL or% IF functions

Kurt_Bremser — Mon, 05 Aug 2019 08:17:46 GMT

Macro variables have scope. If created in a macro, they are local to that macro and vanish as soon as the macro stops executing.

You can simplify the macro loop by using the automatic macro variable sqlobs:

%do num = 1 %to &sqlobs.;
  %let AMTESTtest=%scan(&AMTESTlist.,&num.,:);
%end;

If you have further problems, post the log by using the {i} button.

Re: the log note that :% Discovery of character operands by EVAL or% IF functions

Jagadishkatam — Mon, 05 Aug 2019 08:33:33 GMT

The code seems fine,but there is issue with the data i.e. in AMTEST there is text as 'æ¦“-'

the special characters concatenated to HCV and these special characters need to be removed using compress function and it will resolve the issue.

%macro T71122;

data test3;
	set test.test2 (ENCODING=WLATIN1);
	if obs=1 then delete;
run;

data test3;
	set test3;
	obs=obs-1;
run;

proc sql;
	select distinct compress(AMTEST,'?æ¦“-') into: AMTESTlist separated by ":" from test3 ;
quit;

%put &AMTESTlist.;

%let num=1;
%do %while(%scan(&AMTESTlist.,&num.,%str(:)) NE %str());
	%let AMTESTtest=%scan(&AMTESTlist.,&num.,%str(:));
%let num=%eval(&num.+1);
%put &num;
%end;

%mend;
options mprint;
%T71122;

Re: the log note that :% Discovery of character operands by EVAL or% IF functions

Astounding — Mon, 05 Aug 2019 08:57:03 GMT

The only place that a hidden %EVAL might be invoked is within the comparison inside the %DO %WHILE loop. For that comparison, try switching from %SCAN to %QSCAN.

Re: the log note that :% Discovery of character operands by EVAL or% IF functions

HannaZhang — Mon, 05 Aug 2019 09:15:25 GMT

Thanks,I konw where the problem is.Your suggestion is very helpful.