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
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;
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;
Shorter:
data dunning;
input DT_DUNNING_DATE :yymmdd8.;
format DT_DUNNING_DATE date9.;
cards;
19980428
20100324
20110330 ;
run;
@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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.