topic Re: convertion to sas dates in SAS Programming

convertion to sas dates

dr2014 — Wed, 04 Nov 2015 15:40:23 GMT

Hi,

I want to convert the date value in the 'd' variable in the sas dataset 'final' such as 10/21/2012 to a sas date value and create a new variable 'd1' for it. The 'd' variable is numeric. I used the code below and it did convert the mmddyy10. formatted values to a sas value but only for the year 2012. Dates with values in the 2011 year such as 10/12/2011 were not converted. I am not able to understand this. In addition I also got the 'note' stated below in the log. Please advice. I need to find the most recent date value and coverting into sas date values will make ti easier.

Thanks,

data temp (keep= d d1);
17    set final;
18   d1=input(d,anydtdte15.);
19   run;

NOTE: Numeric values have been converted to character values at the places given by:
      (Line):(Column).
      18:13

Re: convertion to sas dates

MaikH_Schutze — Wed, 04 Nov 2015 15:49:02 GMT

It appears that your data variable 'd' is already in a numeric SAS date. Run the CONTENTS procedure to see if a permanent format is already assigned to variable 'd'. If so, then the actual date will show on the printed output but the underlying data is still the numeric SAS date, i.e. the number of days since January 1, 1960.

The log note simply documents that INPUT function performed numeric to character conversion.

Re: convertion to sas dates

DartRodrigo — Wed, 04 Nov 2015 15:56:15 GMT

Hi mate,

Can you post your code as an example to work on it ?

Thanks

Re: convertion to sas dates

MaikH_Schutze — Wed, 04 Nov 2015 16:10:07 GMT

The original post already includes the code. Upon re-reading, he does say the date variable is already associated with the SAS date format mmddyy10., therefore, the raw data is already a standard SAS date number. If you'd rather have the number than remove the format using this type of code.

data final_2;
   set final;
   format d;
run;

The FORMAT statement without a format will remove a previously assigned format.

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000178212.htm

Re: convertion to sas dates

dr2014 — Wed, 04 Nov 2015 16:48:58 GMT

Thanks @MaikH_Schutze. Yes, it did have a permanent format and I removed it.

Re: convertion to sas dates

dr2014 — Wed, 04 Nov 2015 16:49:57 GMT

Thanks @MaikH_Schutze for the link. I did remove the format and it worked.