topic Re: Converting yyyymmdd. to DATE9.? in SAS Data Management

Converting yyyymmdd. to DATE9.?

TurnTheBacon — Fri, 07 Jun 2013 14:57:10 GMT

I'm working in DI Studio, and have trouble changing the format of a numeric variable.

My input table has a numeric variable with the format yyyymmdd. Value example: 20130531.

I need to convert it to the DATE9. format, so that it displays as 31MAY2013.

What kind of expression can I use for this?

I tried using this:

input(put(DUE_DT, yyyymmdd.),date9.)

However, the values only become blank/null.

Thanks for your time!

Re: Converting yyyymmdd. to DATE9.?

ballardw — Fri, 07 Jun 2013 15:25:58 GMT

If your values are a SAS date value the statement would be: format variablename date9.;

If not then the assignment should be

input(put(due_dt,f8.0),yymmdd.);

The put(due_dt, yyyymmdd.) has two problems in your case, first the format would be yymmdd. , second if the value isn't a date value then your results are going to be very unpredictable, and in this case it would represent a day in the future well past the range of dates SAS will manipulate

Re: Converting yyyymmdd. to DATE9.?

LinusH — Fri, 07 Jun 2013 18:08:22 GMT

What you mean by convert?

Basically, just specify the required format in target table properties.

Re: Converting yyyymmdd. to DATE9.?

TurnTheBacon — Mon, 10 Jun 2013 06:39:21 GMT

Thanks, but if I simply specify DATE9 as the target table column format, all the values show up as " ********* ". Incompatible date formats, I think.

Incidentally, if I use the expression datepart(due_dt) and the DATE9 format in the target table, all date values display as "20AUG1960" (correct format, wrong values).

EDIT: If I force it to have the 8.0 format, the values still appear as "20130531".

Re: Converting yyyymmdd. to DATE9.?

LinusH — Mon, 10 Jun 2013 10:01:25 GMT

Ok, so you date values are not stored as SAS dates. Then datepart will definitely not work.

So, apart from specifying date9. on the target column, you need to transform the value, as in your initial post.

First, there is not format called yyyymmdd., it's called yymmdd.

In your case, the data is already stored in a read friendly format, so use 8. format in the put statement instead, and yymmdd8. on the input.

Re: Converting yyyymmdd. to DATE9.?

TurnTheBacon — Mon, 10 Jun 2013 11:14:22 GMT

Worked like a charm, many thanks!