topic Re: How can the text input date of format 2011-01-01 be converted to a mmddyy10. format? in SAS Programming

How can the text input date of format 2011-01-01 be converted to a mmddyy10. format?

SasNewBieEight — Wed, 18 Apr 2012 18:59:44 GMT

How can the text input date of format 2011-01-01 be converted to a mmddyy10. format?

Haikuo — Wed, 18 Apr 2012 19:06:21 GMT

I am not 100% what you need, so maybe you find this helpful:

data _null_;

a='2011-01-01';

b=input(a,yymmdd10.);

format b mmddyy10.;

put 'new format=' b;

run;

Haikuo

SasNewBieEight — Wed, 18 Apr 2012 19:24:00 GMT

Hi Haikuo,

This is exactly what I needed... I could swear I have tried this, but kept receiving the "Invalid argument to function INPUT" error message.

data begin;

input date $25.;

cards;

2011-01-01

2011-01-02

;

run;

data test (drop=date);

set begin;

date2=input(date,yymmdd10.);

format date2 mmddyy10.;

put 'new format=' date2;

run;

LOG:

new format=01/01/2011

new format=01/02/201

Thanks!