topic Re: SAS Dates in SAS Procedures

SAS Dates

JackFerral — Wed, 15 Oct 2014 23:44:37 GMT

error

Re: SAS Dates

stat_sas — Thu, 16 Oct 2014 00:09:22 GMT

Something like this will produce the desired output. I am assuming the difference between dates as number of days.

data have;

input m d y date1 :mmddyy10.;

date2=mdy(m,d,y);

date_diff_day=intck('day',date2,date1);

format date1 date2 date9.;

datalines;

1 20 1985 01/30/1986

;

proc print data=have;

run;

Re: SAS Dates

dkb — Thu, 16 Oct 2014 00:30:32 GMT

As the original question has been deleted, here is a copy from Google's cache.

------------------------------------------------------------------------------------------------------------------

I have a Data set that contains separate columns for day, month and year. I need to consolidated these into one single variable .

Example:

1 20 1985 (consolidated into a single SAS date)

Would I want to use the MDY Function? and what would this look like?

Once I've consolidated this date I need to find the difference from this new column and another date column that was originally a single columned date.

Thanks!

Jack