topic Re: %EVAL function giving an error in SAS Programming

%EVAL function giving an error

deleted_user — Tue, 17 Aug 2010 16:09:31 GMT

Hi all!

I have a SAS file created
Thanks!

Re: %EVAL function giving an error

darrylovia — Tue, 17 Aug 2010 17:37:22 GMT

Dear SASNewBee

Double check your macro code spefically

%macro trans( id, gid,sj, tdata);
data _temp_cs;
set &t_data;
run;

should the set &t_data be &tdata ?

Re: %EVAL function giving an error

Doc_Duke — Tue, 17 Aug 2010 17:46:47 GMT

You need to turn on the options that Scott (SBB) recommends, so you (and we) can see what is going on. Without more detail of the log, it is a stab in the dark.

However, to stab in the dark, I'd guess that your connection to the database failed and thus &cnt is never created. The password warning is my key.

Re: %EVAL function giving an error

deleted_user — Tue, 17 Aug 2010 17:59:15 GMT

Sorry but I dont see any posts from SBB. Which options do I need to turn on?

Re: %EVAL function giving an error

sbb — Tue, 17 Aug 2010 18:16:14 GMT

You really need to share *ALL* of your SAS code, not just sections. There is a macro you are invoking which is not revealed at all.

The OPTIONS setting mentioned - you may want to consider reviewing the DOC about diagnosing SAS programs is:

OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MPRINT;

And there are times when you will need to add MLOGIC as well.

Scott Barry
SBBWorks, Inc.