topic Re: character to date variable in SAS Enterprise Guide

character to date variable

woo — Fri, 02 Oct 2015 18:35:46 GMT

can i please get help on this,

wants to convert below character value to date value

Have

char_var=2015.09.19 /*sorry but this is character value that i ended up by pulling it out from long string)*/

want

date_var=09192015 /*want it as a date*/

thank you in advance,

Re: character to date variable

PaigeMiller — Fri, 02 Oct 2015 18:45:46 GMT

date_Var=mdy(scan(char_var,2,'.')+0,scan(char_var,3,'.')+0,scan(char_var,1,'.')+0);

format date_Var mmddyy8.;

Re: character to date variable

Astounding — Fri, 02 Oct 2015 18:49:19 GMT

While I can't test this at the moment, you should be able to read the character string directly:

date_var = input(char_var, yymmdd10.);

That will give you the proper date value. For display purposes, choose the date format that you would like. To match the result you originally asked for:

format date_var mmddyyn8.;

Good luck.

Re: character to date variable

woo — Fri, 02 Oct 2015 18:55:53 GMT

to Astounding

i don't know why but i used that trick already and i am receiving error saying "limit set by errors= option reached,..."

Miller trick worked though after using format function date9.;

Re: character to date variable

Reeza — Fri, 02 Oct 2015 19:11:10 GMT

date_want=input(date_have, anydtdte10.);
format date_want date9.;

This works for me.

Re: character to date variable

woo — Fri, 02 Oct 2015 20:13:23 GMT

Yes Reeza that worked, thanks