Calculate the numbers of day logic

[Jesusismygrace]

Hi,

I would like to calculate the following logic using the two date fields (DOS and IESD).

DOS on the IESD or in the 28 days following the IESD.

[Reeza]

42

[AMSAS]

You will need to provide more context as this really doesn't tell me anything 

Assuming they are both SAS Date values, then you can just subtract one from the other to get number of days

I suggest you provide some sample data and code, and the expected output

Data2DataStep Maco instructions

[Kurt_Bremser]

Do you mean

if IESD le DOS le IESD + 28

?

[ballardw · Accepted solution]

The INTCK function will return number of intervals between date, time or datetime values, you specify the interval.

But example data and what you expect the result to look like will get you much further than use constantly guessing what you may have and what you want the result to look like.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the </> icon or attached as text to show exactly what you have and that we can test code against.

A data step is particularly helpful because we have people ask questions about "date" values and then after many "but that doesn't work" comments find out the actual values are not dates but character values or datetime values. SAS uses different values for storing dates and time or datetime values.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/... has a PDF with much information about dates.

[Jesusismygrace]

Thank you