topic Re: DATDIF FUNCTION in SAS Programming

DATDIF FUNCTION

Bhargav_Movva — Sat, 25 Mar 2017 08:16:35 GMT

Hi team,

I have a dataset with startdate and enddate of certain task.All i wanted to know is the no of days between start and end of each task.But my input sas dataset contains date as character variable,so when i applied datdif function on the start and end date vars imk getting errors.Even tried to apply input function before executing Datdif function.

Re: DATDIF FUNCTION

Patrick — Sat, 25 Mar 2017 12:47:18 GMT

"Even tried to apply input function before executing Datdif function."

You're on the right track with this one. All SAS calendar functions like datdif() and intck() require the data to be a SAS date or SAS datetime value (=number of days or number of seconds since 1/1/1960).

The INPUT() function will help you to convert a character string into such a numeric SAS date/datetime value. You just need to apply the correct INFORMAT which instructs SAS how to convert this string into a date/datetime value.

Should you require more guidance: You need to post sample data (a data step creating such data) and then explain us what you need.

Re: DATDIF FUNCTION

Bhargav_Movva — Sun, 26 Mar 2017 03:22:12 GMT

Hey Patrick !!! thanks for the response.Issue resolved with your guidance..