topic how to get a when statement to work with negative numbers in SAS Procedures

how to get a when statement to work with negative numbers

BETO — Mon, 17 Aug 2015 22:20:30 GMT

a HI I have an if statement

data ms;

set ms;

actual = datedif (date,today(), 'act/act');

put actual= ;

gets me number of days from date to today date...

data ms;

set ms;

select;

when (actual=.) copy= " ";

when (actual <0 or actual > -15 ) Copy "pre_15";

when ( actual >=1 or actual <=90) copy " post_90";

end;

run;

I Want to Id what's within 15 days an that number is a negative reason its a -15...

i Want to ID post 90 days I'm using today date to get the datediff and date. Thanks

Message was edited by: gilbert arredondo

Re: how to get if statement to work with negative numbers

ChrisNZ — Mon, 17 Aug 2015 23:47:08 GMT

1- There is no IF in your code; what with the title?

2- The copy keyword is invalid syntax as used in your code

3- The last sentences make little sense

If you want to be helped the least you can do is present a properly explained and presented case.

Re: how to get if statement to work with negative numbers

BETO — Tue, 18 Aug 2015 02:22:29 GMT

it was an if statement I change it before I asked the question....Chris if it doesn't make sense to you need to respond I try to make it as clear as possible

Re: how to get if statement to work with negative numbers

Reeza — Tue, 18 Aug 2015 03:26:49 GMT

You need AND not OR In your conditions.

As Chris has indicated you need an equal in your assignment statement for the copy variable.

Re: how to get if statement to work with negative numbers

BETO — Tue, 18 Aug 2015 03:30:58 GMT

Thanks Reeza ... I will take your suggestion...It a snippe of code that works for me on other code but it's character not number

Re: how to get if statement to work with negative numbers

BETO — Tue, 18 Aug 2015 04:13:51 GMT

HI reeza

i Got it

data table;

set table;

if actual ge 0 and actual Le 90 then copy = "post_90";

thanks