topic Macro issue? in SAS Programming

Macro issue?

TimmySauce — Sun, 12 Apr 2020 00:23:55 GMT

So, this is the code from 'Beginning Sas Programming' (copied and pasted)

dm log 'clear'; dm output 'clear';

/*create fibonacci table; create first 2 Fibonacci numbers */
proc sql;
create table fibonacci (n num,f num);

insert into fibonacci 
values (0,0)
values (1,1);
quit;

/* get the last 2 Fibonacci numbers*/
proc sql outobs=2;
  create table last2 as
  select * from fibonacci order by n descending;
quit;

It's not producing any output, and it's giving me the message "

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

So.. Google tells me from these forums that it's an issue with the macro not being '%mend' - ed..

What would the specific fix be, and why wouldn't the code from a book work, assuming he copied and pasted functional code?

Re: Macro issue?

LeonidBatkhan — Sun, 12 Apr 2020 02:09:06 GMT

This code runs perfectly fine. You must have an unbalanced quotation mark left from other code you previously tried running within your SAS session. Close your SAS and open it again.

Re: Macro issue?

Kurt_Bremser — Sun, 12 Apr 2020 04:16:41 GMT

There is no macro definition (%macro) in your code, so you have unbalanced quotes in code submitted before that.

Restart your SAS session.

Re: Macro issue?

TimmySauce — Sun, 12 Apr 2020 20:59:11 GMT

Thank you, gentlemen. I found what I was doing wrong.