Obsidian | Level 7

## Calculate the numbers of day logic

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Calculate the numbers of day logic

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.

5 REPLIES 5
Super User

42
SAS Super FREQ

## Re: Calculate the numbers of day logic

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

Super User

## Re: Calculate the numbers of day logic

Do you mean

``if IESD le DOS le IESD + 28``

?

Super User

## Re: Calculate the numbers of day logic

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.

Obsidian | Level 7

## Re: Calculate the numbers of day logic

Thank you
Discussion stats
• 5 replies
• 522 views
• 1 like
• 5 in conversation