Note 49-169

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

Note 49-169

Hello everyone,

 

I am trying to run a macro code but I am continuously getting this so called 49-169 note. Any idea how to fix it?

I have attached both the macro and the log file. 

Thanks


Accepted Solutions
Solution
‎10-04-2016 02:06 AM
Super User
Posts: 19,855

Re: Note 49-169

Unless you've stored your macro in an autocall library or a catalog you first need to define it. 

The log is clear in saying the macro isn't defined. 

 

Where is you macro source code? Run it first then you can execute it. 

View solution in original post


All Replies
Trusted Advisor
Posts: 1,583

Re: Note 49-169

[ Edited ]

You got next note at the beginning of your log:

NOTE: The quoted string currently being processed has become more than 262 
       characters long.  You might have unbalanced quotation marks.

According to the log the problem is not in the reg2dse macro but in previous code running.

Rerun your program in a new session and if the problem still exists check your autoxece code.

Contributor
Posts: 24

Re: Note 49-169

Hi Shmuel,
I just ran it in a new SAS session, but got the same note. The problem is that the macro used to work without any issue!
Trusted Advisor
Posts: 1,583

Re: Note 49-169

what is the full code you ran as first run in the session ?

Contributor
Posts: 24

Re: Note 49-169

I just invoked the macro with following line:
%REG2DSE(y=NIS, x=DR RET Rep DRRET REPDR REPRET REPDRRET, firm=permco, time=fyear, multi=1, dataset=am.datab15, output=am.results);
and first I got the following in log:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
WARNING: Apparent invocation of macro REG2DSE not resolved.
55
56 %REG2DSE(y=NIS, x=DR RET Rep DRRET REPDR REPRET REPDRRET,
_
180
56 ! firm=permco, time=fyear, multi=1, dataset=amirkhan.datab15,
56 ! output=results);

ERROR 180-322: Statement is not valid or it is used out of proper order.

57
58 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
70



The second time I invoked the macro I got the 49-169 note message.
Solution
‎10-04-2016 02:06 AM
Super User
Posts: 19,855

Re: Note 49-169

Unless you've stored your macro in an autocall library or a catalog you first need to define it. 

The log is clear in saying the macro isn't defined. 

 

Where is you macro source code? Run it first then you can execute it. 

Contributor
Posts: 24

Re: Note 49-169

Thank Reeza,
It worked!!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 872 views
  • 1 like
  • 3 in conversation