topic How to convert 20080220 00:00:00 to MMDDYY8. format? in SAS Procedures

How to convert 20080220 00:00:00 to MMDDYY8. format?

BETO — Fri, 16 Mar 2012 19:44:51 GMT

Hi currently I've A date formatted like this 20080220 00:00:00... I tried doing a datepart to format it to MMDDYY8. SAS or Excel doesn't see it as date ... How can a data step convert this to a date that can used to query? Thanks again for your assistance

How to convert 20080220 00:00:00 to MMDDYY8. format?

art297 — Fri, 16 Mar 2012 20:13:24 GMT

If the time part is irrelevant, anyhow, you could use the anydtdte informat to only read the first 8 digits. e.g.:

options datestyle=ymd;

data have;

informat dt anydtdte8.;

format dt date9.;

input dt;

cards;

20080220 00:00:00

;

How to convert 20080220 00:00:00 to MMDDYY8. format?

GeorgeSAS — Fri, 16 Mar 2012 20:24:44 GMT

%put %sysfunc(putn(%sysfunc(timepart(%sysfunc(DATETIME()))),time8));

How to convert 20080220 00:00:00 to MMDDYY8. format?

BETO — Fri, 16 Mar 2012 22:24:09 GMT

The name of my table is Table_A with Date/Time for name of col with 20080220 00:00:00 . With the responses provided how do I connect the dots to format it to mmddyy8. ? And thanks again for your assitances

How to convert 20080220 00:00:00 to MMDDYY8. format?

ballardw — Fri, 16 Mar 2012 22:28:47 GMT

Is this connecting to another database? There are some issues other than SAS formats that may need addressing if so.

How to convert 20080220 00:00:00 to MMDDYY8. format?

art297 — Fri, 16 Mar 2012 23:06:07 GMT

I agree. It depends upon what you are doing and from where. If the value is coming into SAS as a character string, the following might connect the dots:

options datestyle=ymd;

data table_a;

informat dt $20.;

input dt;

cards;

20080220 00:00:00

;

data want;

set table_a;

format want_dt date9.;

want_dt=input(dt,anydtdte8.);

run;

How to convert 20080220 00:00:00 to MMDDYY8. format?

BETO — Sat, 17 Mar 2012 15:23:27 GMT

Hi Art,

The name of the table is "Table_A" which you make referance in your recomendation the column that has the 20080220 00:00:00 is name Date/Time in your example where do I make referance to that column ?... Thanks again for your assitance

How to convert 20080220 00:00:00 to MMDDYY8. format?

art297 — Sat, 17 Mar 2012 15:51:58 GMT

I referenced the column as having the name dt, thus you would just replace dt with the variable's actual name, and you would change the name want_dt to be the name of the new date variable that you want.