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?
newvar = input(oldvar,yymmdd10.);
format newvar yymmddd10.;
newvar = input(oldvar,yymmdd10.);
format newvar yymmddd10.;
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;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.