topic Re: if statement in SAS Procedures

if statement

robertrao — Mon, 05 Aug 2013 03:43:20 GMT

HI Team,

i was trying to use an if condition like the following and I get a syntax error.

could you please help me correct this?????

DAta want want2;

set have;

If datepart(time) between "begin" and "end " then output want;

if datepart(time) between "begin2 " and "end2" theN output want2;

run;

THanks

Re: if statement

Tom — Mon, 05 Aug 2013 03:52:49 GMT

Two problems

1) The IF statement does not support that SQL specific BETWEEN operator even though the WHERE statement does.

Use the normal SAS syntax :

"&begin"d <= datepart(time) <= "&end"d

Or the expanded syntax :

"&begin"d <= datepart(time) and datepart(time) <= "&end"d

2) You cannot compare a numeric (dates are numbers of days since 1/1/1960) with a character string. If you format the values in DATE format then you can use date literals.

%let begin=01JAN2013;

%let end=31MAR2013;

%let begin2=01APR2013;

%let end2=30JUN2013;

data want want2;

set have;

if "&begin"d <= datepart(time) <= "&end"d then output want;

if "&begin2"d <= datepart(time) <= "&end2"d then output want2;

run;

Re: if statement

robertrao — Mon, 05 Aug 2013 03:58:16 GMT

Thank you very much Tom. That was very helpful.