a date interval in if then statement

[Jannie_D]

Hi. So I am working on a hughe database on a secure server. why I can not copy-pasty codes into the browser.

anyways as I am working with health economics I need to multiply all results with a year factor. 

so for instance I made a variable totalmedicine I get a number and then if it comes from 2014 I have to multiply that number with 1.083 to get the equivalent amount in 2020. I have to do that for all years 2014-2019.

then I make a code

data allst3;

set all;

totalmedicin=eksp+tilpris;

if eksd >20131231 and eksd<20150101 then totalmedicin=totalmedicin*1.083;

run;

And so on for all the years and factors

when I run the code with or without the if then statement I get the same results in totalmedicin, what am I doing wrong?

[PaigeMiller]

if eksd >'31DEC2013'd and eksd<'01JAN2015'd then totalmedicin=totalmedicin*1.083;

The D after the quoted date indicates SAS should interpret this as an actual SAS date value. Of course, this assumes that EKSD is an actual SAS date value.

[yabwon]

...or the "SAS way" 😉😉

if '31DEC2013'd < eksd < '01JAN2015'd then ...

B

[PaigeMiller · Accepted solution]

Or

if year(eksd)=2014 then ...