topic Re: to convert a date from date9 format to sas number in SAS Programming

to convert a date from date9 format to sas number

archana — Fri, 02 Oct 2015 23:34:46 GMT

to convert a date variable - xdate to SAS date values like 20340 . Xdate has values -12SEP2015 and xdate is of numeric and format date9

Re: to convert a date from date9 format to sas number

stat_sas — Sat, 03 Oct 2015 00:23:37 GMT

data have;
date_have='12SEP2015'd;
format date_have date9.;
date_want=date_have;
run;

proc print data=have;
run;

Re: to convert a date from date9 format to sas number

Tom — Sat, 03 Oct 2015 01:26:06 GMT

So if the variable is of type NUM and has a format DATE9 applied and the values when printed look like valid dates, such as '12SEP2015' then it already IS and number. In fact if the value is '12SEP2015'd then the number in the XDATE variable is 20,343.

There is nothing to "convert".

Re: to convert a date from date9 format to sas number

archana — Sat, 03 Oct 2015 11:27:47 GMT

Tom,

The vales in Xdata re of 12SEP2015, 01OCT2015. when i try to assign it to new variable ydate i need to get the number but i am getting empty values.

ydate = datepart(xdate); - didnt work.

tried others too.

Re: to convert a date from date9 format to sas number

Tom — Sat, 03 Oct 2015 11:52:22 GMT

The DATEPART() function converts a DATETIME value (number of seconds) to a DATE value (number of days). So basically you divided your date by 86,400 (24hr*60min/hr*60sec/min)

ydate = xdate ;

Re: to convert a date from date9 format to sas number

archana — Sat, 03 Oct 2015 11:51:58 GMT

How can i add d to my date value.

Re: to convert a date from date9 format to sas number

Tom — Sat, 03 Oct 2015 12:00:54 GMT

If D is an integer number of days then just add it.

newdate = olddate + d ;

If you want to add other intervals (months, weeks) then you should look at the INTNX() function.

newdate = intnx('day',olddate,d);
newdate = intnx('month',olddate,m,'same');