change format of column to date

sasprogramming — Fri, 21 May 2021 04:48:40 GMT

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

Re: change format of column to date

Kurt_Bremser — Fri, 21 May 2021 05:17:25 GMT

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;