topic Re: ERROR 117-185: There was 1 unclosed DO block. in SAS Programming

ERROR 117-185: There was 1 unclosed DO block.

Geo- — Wed, 21 Mar 2018 02:18:08 GMT

data _null_;

if month(today())=1 then

do;

proc sql noprint;

insert into table1(date,tag)

set date=today(),

tag=0;

end;

else;

do;

%put @@@@@NO NEED TO INSERT@@@@@@;

end;

run;

There was 1 unclosed DO block,but I can't find it..how to fix?thanks!

Re: ERROR 117-185: There was 1 unclosed DO block.

Patrick — Wed, 21 Mar 2018 02:21:47 GMT

@Geo-

1. You can't mix a SAS data step with a Proc SQL.

2. A macro %put statement used in a SAS data step Do Loop won't work as you believe.

Also based on your other post: You need to read-up a bit how SAS Macro processing works and how it relates to SAS data and Proc steps as it clearly shows that you haven't grasped the concept yet.

Re: ERROR 117-185: There was 1 unclosed DO block.

Geo- — Wed, 21 Mar 2018 02:33:03 GMT

yes I will read them at other leisure time..would you please fix the code ,I need to offer it first..

Re: ERROR 117-185: There was 1 unclosed DO block.

Astounding — Wed, 21 Mar 2018 02:53:47 GMT

To build upon what you already have:

data _null_;

if month(today())=1 then call execute(

'proc sql noprint;

insert into table1(date,tag)

set date=today(),

tag=0;');

else put '@@@@@NO NEED TO INSERT@@@@@@';

run;

This not only fixes the unclosed DO block, but corrects a significant number of other errors you would have encountered after the DO block was fixed. I can't promise that your SQL syntax is correct, but you will soon find that out. I just have to assume that it's correct.

Re: ERROR 117-185: There was 1 unclosed DO block.

Kurt_Bremser — Wed, 21 Mar 2018 10:31:25 GMT

@Geo- wrote:
yes I will read them at other leisure time..would you please fix the code ,I need to offer it first..

From my Maxim 13:

Never say "I don't have the time to learn that now". The time to learn is NOW.