topic Re: Macro %While Operator in ODS and Base Reporting

Macro %While Operator

deleted_user — Fri, 25 Aug 2006 14:20:56 GMT

Hello,

I've got a problem with my macro.
Here is the first part of it.

%macro castypes(table,x1=,x2=nul,x3=nul,x4=nul,x5=nul) ;
/* nombre de modalités*/
%let i=1 ;
%do %while(&&x&i NE nul) ;
%let i=&i+1;
%end ;
%mend ;
options symbolgen mlogic mprint ;
%castypes(table=estgen,x1=pauvretot,x2=typomen) ;

At the end "i" should resolve to 3.

Log tells me that he's expecting something numeric in the while condition.
Yet the following program works :

%macro castypes(table,x1=,x2=nul,x3=nul,x4=nul,x5=nul) ;
/* nombre de modalités*/
%let i=1 ;
%do %while(&&x&i=nul) ;
%let i=&i+1;
%end ;
%mend ;
options symbolgen mlogic mprint ;
%castypes(table=estgen,x1=pauvretot,x2=typomen) ;

Since x1 resolves to pauvretot, the condition is wrong the first time. But at least the program works.
What's wrong with the first program ?

Thank you.

Re: Macro %While Operator

David_SAS — Mon, 28 Aug 2006 16:21:04 GMT

This is a good question for Technical Support. You can submit it online at http://support.sas.com/ctx/supportform/index.jsp .

-- David Kelley, SAS

Re: Macro %While Operator

deleted_user — Mon, 28 Aug 2006 16:30:11 GMT

Does it have something to do with the operator "ne" ?

Does it work with the macrolanguage ?

Re: Macro %While Operator

deleted_user — Tue, 29 Aug 2006 12:42:59 GMT

no not NE

your assumptions about +

The answer is visible in the symbolgen generated by your options

MLOGIC(CASTYPES): %LET (variable name is I)
SYMBOLGEN: Macro variable I resolves to 1
SYMBOLGEN: && resolves to &.
SYMBOLGEN: Macro variable I resolves to 1+1

Summing needs to be surrounded by %eval()

So, not

%let i=&i+1;

but

%let i= %eval( &i+1 );

good luck

PeterC

Re: Macro %While Operator

deleted_user — Tue, 29 Aug 2006 13:17:50 GMT

Thank you very much. I have been waiting for an answer for so long 🙂

I am sorry.
I have learned very recently by myself how to use macrolanguage...