topic Re: character date to Date9. in SAS Programming

character date to Date9.

Hudson33 — Tue, 17 Jun 2014 23:06:27 GMT

I suppose there is an easy fix for this, although I am new to SAS so it seems a little tricky at the moment.

Basically I have a date variable that is in character format ( $ 10) and looks like 06/31/2009, as an example. I would like to get that to date9. format if possible.

Thanks for the help!

Re: character date to Date9.

Fugue — Wed, 09 Nov 2016 20:45:07 GMT

Editor's Note: Thanks to Fugue for providing an example of how to use the INPUT function to convert a character date into a SAS date and then using the FORMAT statement to apply the desired format.

Try this:

Data want;
set have;
format datevar date9.;
datevar = input ( chardate, MMDDYY10.);
run;

Re: character date to Date9.

Hudson33 — Wed, 18 Jun 2014 19:35:21 GMT

Thanks very much! Would the same be the case for changing DATE9. to the numeric SAS date?

Thanks again!

Re: character date to Date9.

Fugue — Wed, 18 Jun 2014 19:42:06 GMT

SAS date and time values are stored as numbers, but displayed according to the chosen format. Example:

Data want;

set have;

format formatted_date date9. /* displays stored date value with specified format */

not_formatted_date best. /* number format */;

formatted_date = input ( chardate, MMDDYY10.); /* stores value as a SAS date value (number). Format determines which date format is used to display it. */

not_formatted_date = formatted_date; /* also a numeric value, but format displays it as a number */

run;

Re: character date to Date9.

PaulaC — Wed, 08 Feb 2017 20:03:13 GMT

My current character value is stored as ddmmmyyyy so I used date9. when changing it to the numeric value. The problem is that when I look at my data set the value for that variable is the SAS date. I tried using "format dateqol date9.;" to get it into the correct format, but I am getting the following error message: ERROR 48-59: The format $DATE was not found or could not be loaded.
What am I doing wrong? I put the format statement prior to the input statement. Thanks.

Re: character date to Date9.

P_trivedi — Sat, 07 Oct 2017 05:23:53 GMT

Dear PaulaC,

Refer below code for your mentioned query:

data dateC;
input chardate :$9.;
datalines;
31dec1999
;
run;

data dateN;
set dateC;
format sasdate date9.;
sasdate=input(chardate,date9.);
run;

Placement of format statement does not affect at all.