change format of column to date

[sasprogramming]

I have a column portfolio date that when loaded into sas is not recognised as a date column. How do I change it to the format YYDDMM?

Thanks

[Kurt_Bremser · Accepted solution]

I've never seen a YDM order in dates in real life; are you sure you do not mean YMD?

In this case, the conversion would be

data want:
set have;
portfolio_date = datepart(portfolio_date);
format portfolio_date yymmdd10.;
run;