topic need help in SAS Programming

need help

sss — Fri, 16 Dec 2011 14:21:12 GMT

I am having a variable by name DT_DUNNING_DATE which is off type numeric with BEST12. format

I am tring to apply format ie date9. on this column but i am getting an error msg.

DATA TEMP;

SET DUNNING;

DT_DUNNING_DATE1=INPUT(DT_DUNNING_DATE,DATE9.);

FORMAT DT_DUNNING_DATE1 DATE9.;

RUN;

ERROR:there was a problem with format so best. is used.

variable values in table as follow

DT_DUNNING_DATE

19980428

20100324

20110330

PLS HELP ME OUT

Re: need help

art297 — Fri, 16 Dec 2011 15:04:42 GMT

I think that you are looking for something like:

data dunning;

input DT_DUNNING_DATE;

cards;

19980428

20100324

20110330

;

DATA TEMP;

SET DUNNING;

DT_DUNNING_DATE1=

INPUT(put(DT_DUNNING_DATE,8.),yymmdd8.);

FORMAT DT_DUNNING_DATE1 DATE9.;

RUN;

Re: need help

ballardw — Fri, 16 Dec 2011 21:05:54 GMT

Shorter:

data dunning;

input DT_DUNNING_DATE :yymmdd8.;

format DT_DUNNING_DATE date9.;

cards;

19980428

20100324

20110330 ;

run;

need help

Saugata — Tue, 20 Dec 2011 12:38:59 GMT

@art297 is completely correct. As the input values in the dataset is in YYYYMMDD format you have to first read them in yymmdd8. format then you can change them to Date9. format easily.