- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.