topic Convert Char 30. to Date9. in sas in SAS Programming

Convert Char 30. to Date9. in sas

Divya12 — Tue, 15 Sep 2020 22:28:27 GMT

Hi,

Please help me to convert Char format $30. to Date9. format in SAS.

Date - 2017-10-24

New Date - 24OCT2017.

I tried the below code
format New Date date9.;
New Date= input(date,MMDDYY10.);

But I get blank values in the column.

Thanks

ballardw — Tue, 15 Sep 2020 23:12:01 GMT

Look closely at the value of "date" such as 2017-10-14. Does that start with a Month? The MMDDYY informat is Month, day, year order.

You would use YYMMDD10. instead of MMDDYY10.

Bad idea to place spaces in the middle of variable names too.

NewDate= input(date,MMDDYY10.);

format newdate date9.;

Though one wonders why "date" is supposedly Char 30 if it only has 10 characters...

novinosrin — Tue, 15 Sep 2020 23:13:03 GMT

Date='2017-10-24';
NewDate= input(date,yymmdd10.);
format 	NewDate date9.;