topic Re: Calculate the numbers of day logic in SAS Programming

Calculate the numbers of day logic

Jesusismygrace — Thu, 14 Oct 2021 16:41:00 GMT

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.

Re: Calculate the numbers of day logic

Reeza — Thu, 14 Oct 2021 16:53:44 GMT

Re: Calculate the numbers of day logic

AMSAS — Thu, 14 Oct 2021 16:54:35 GMT

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

Re: Calculate the numbers of day logic

Kurt_Bremser — Thu, 14 Oct 2021 16:55:17 GMT

Do you mean

if IESD le DOS le IESD + 28

Re: Calculate the numbers of day logic

ballardw — Thu, 14 Oct 2021 16:58:49 GMT

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-data-AKA-generate/ta-p/258712 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/ta-p/424354 has a PDF with much information about dates.

Re: Calculate the numbers of day logic

Jesusismygrace — Mon, 18 Oct 2021 14:24:31 GMT

Thank you