topic Re: what's wrong with this piece of code in SAS Procedures

what's wrong with this piece of code

buckeye — Tue, 05 Apr 2011 14:47:44 GMT

Hi all,

I got error msg after running the following code. Can anyone please help debug. Thanks in advance.

%MACRO MYSQL;
PROC SQL;
SELECT COUNT(*) INTO :MYCNT FROM MYTABLE;
%LET MYCNT = &MYCNT;
DATA _NULL_;
IF &MYCNT > 1 THEN %MYPRINT(MYTABLE,'MYTABLE');
RUN;
%MEND MYSQL;

%MACRO MYPRINT(MYDATA,TN);
PROC CONTENTS DATA = &MYDATA POSITION;
TITLE 'Contents of ' &TN;
RUN;
PROC PRINT DATA=&MYDATA (OBS=10) U;
RUN;
%MEND MYPRINT;

%MYSQL;

RUN;

Re: what's wrong with this piece of code

Paige — Tue, 05 Apr 2011 14:58:29 GMT

PROC CONTENTS cannot be called from within DATA _NULL_;

Instead of your DATA _NULL_ step, the following should work

%IF &MYCNT > 1 %THEN %MYPRINT(MYTABLE,'MYTABLE');

Re: what's wrong with this piece of code

RickM — Tue, 05 Apr 2011 15:01:02 GMT

It would be helpful to see the error message as well as the code that came before it in the SAS log.

Re: what's wrong with this piece of code

buckeye — Tue, 05 Apr 2011 15:58:44 GMT

from the replied tips, it apperas that adding % takes care of it.

Thank all who replied.