topic Converting a string into a date SAS enterprise guide in SAS Programming

Converting a string into a date SAS enterprise guide

sheller — Fri, 14 Oct 2016 20:43:26 GMT

I have a column in a data set that has dates in a string format YYYY-MM-DD.

How can I convert this into a date column?

Re: Converting a string into a date SAS enterprise guide

Kurt_Bremser — Fri, 14 Oct 2016 20:45:37 GMT

newvar = input(oldvar,yymmdd10.);
format newvar yymmddd10.;

Re: Converting a string into a date SAS enterprise guide

Reeza — Fri, 14 Oct 2016 22:09:16 GMT

The code provided should have worked so either your data isn't as specified or you did something wrong. How did you use the code provided? In a query builder or as a data step? What did your log say?

Verify the type and format of your variable.

Run a proc contents and post the results for that variable.

data test;
length x $10.;
x="2016-10-12";
y=input(x, yymmdd10.);
format y date9.;
run;

proc print data=test;
run;