topic from char to mmddyy10. in SAS Programming

from char to mmddyy10.

serrld113 — Thu, 27 Jun 2019 18:05:13 GMT

Hey all,

I have this:

data have;
input chardate $ 1-10;
datalines;
2017-10-30
2019-01-12
2011-08-01
;
run;

and want my dates to look like this:

10/30/2017

12/01/2019

08/01/2011

I tried this:

input(compress(chardate,'-'), 8.) as wantdate format = MMDDYY10.

because I saw somewhere that you have to change it to num. but when I run this piece of code in a proc sql all I get is *******.

Thanks for the help

Re: from char to mmddyy10.

PeterClemmensen — Thu, 27 Jun 2019 18:08:45 GMT

proc sql;
   create table want as
   select input(chardate, yymmdd10.) as wantdate format = MMDDYY10.
   from have;
quit;

Re: from char to mmddyy10.

Kurt_Bremser — Thu, 27 Jun 2019 18:08:46 GMT

wantdate = input(chardate,yymmdd10.);
format wantdate mmddyy10.;

Re: from char to mmddyy10.

Tom — Thu, 27 Jun 2019 19:58:36 GMT

If you take a number like 20,171,030 are ask SAS to format it as a date you are asking for the date that 20 million days after start of 1960.

It would take 5 digits for the just the year part to display that. SAS formats cannot handle dates that far into the future.

522   data _null_;
523     days=20171030;
524     years=int(days/365.25);
525     year=1960+years;
526     put (years year) (=comma10.);
527   run;

years=55,225 year=57,185