topic Re: conditionally run proc sql in SAS Programming

conditionally run proc sql

me55 — Thu, 06 Apr 2017 16:14:32 GMT

i am somewhat new to sas, so what i want to do is execute some sql only on a certain month. so i want...

proc sql;

update table

set field='Y';

;

to run in a larger program only when the month is january. i am sure it is a fairly easy solution, just having trouble finding the right one. i am using sas eg 7.1 tyi.

thanks

Re: conditionally run proc sql

Astounding — Thu, 06 Apr 2017 17:16:58 GMT

First, you will need working PROC SQL code. I leave that to you as a separate issue. For a short program like you have illustrated, here is an easy way:

data _null_;

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

"proc sql;

update table

set field='Y';

);

run;

Re: conditionally run proc sql

ballardw — Thu, 06 Apr 2017 17:45:14 GMT

I am not quite sure if you want to conditionally execute Proc Sql or if you only want to process some records within a data set based on the value of a variable in the data set.

Re: conditionally run proc sql

me55 — Thu, 06 Apr 2017 18:50:11 GMT

yeah, that worked out great but while i was waiting i also wroote a macro to do that same thing...

%let mnth=%sysfunc(month(%sysfunc(today())));
%macro monthtest;
%if &mnth^=4 %then %do;
proc sql;
select * from TABLE where ID<=100;
%end;
%else %if &mnth=4 %then %do;
proc sql;
select * from TABLE where 100<=ID<=200;
;
%end;
%mend monthtest;
run;

%monthtest
run;

...and to the other questions, what i needed to do was based on whether it was jan or not, if so i needed to mark some delete=y under 2 certain conditions of other columns in the data.