If then statement with conditions

RandyStan — Fri, 07 Oct 2022 16:29:11 GMT

Dear All:

I am trying a IF/THEN statement and I do not seem to get the syntax.

The conditions are as follows

If Year < 2015 and

date not between 24SEP2014 and 08OCT2014 and

Group_ID >15 then

Group_ID = 14

Data want ; set have ;

if Year <2015 and date NE (24SEP2014 le 08OCT2014) and Group_ID > 15 then do;

Group_ID = 14;

run;

I do not seem to get the date statement correctly.

Please help.

Thanks in advance

Re: If then statement with conditions

Reeza — Fri, 07 Oct 2022 16:39:29 GMT

Your date comparisons are incorrect.

Data want ; 

set have ;

if Year <2015 
    and not ( '24Sep2014'd <= date <= '08Oct2014'd) 
    and Group_ID > 15 
              then Group_ID = 14;

run;

@RandyStan wrote:

Dear All:

I am trying a IF/THEN statement and I do not seem to get the syntax.

The conditions are as follows

If Year < 2015 and

date not between 24SEP2014 and 08OCT2014 and

Group_ID >15 then

Group_ID = 14

Data want ; set have ;

if Year <2015 and date NE (24SEP2014 le 08OCT2014) and Group_ID > 15 then do;

Group_ID = 14;

run;

I do not seem to get the date statement correctly.

Please help.

Thanks in advance

topic Re: If then statement with conditions in SAS Programming

If then statement with conditions

Re: If then statement with conditions