09-28-2017 05:08 PM
data want; format new_date1 yymmdd10.; date='2017-09-28'; new_date1=input(date,yymmdd10.); /* SAS numberic date format- better approach */ new_date=put(input(date,yymmdd10.),mmddyy10.); /* character format */ run;
Is this what you are looking for? Your question is not clear.
09-28-2017 07:06 PM
It may help to show what you did and why you weren't satisfied with the result.
A common issue is people trying to change an existing variable from numeric to character. SAS doesn't do that.
09-29-2017 09:09 PM
09-28-2017 07:21 PM - edited 09-28-2017 07:25 PM
Should be easy. So you have something like this where your existing variable is an actual date.
data have ; date='28SEP2017'd; format date e8601da. ; put date= comma7. +1 date e8601da. +1 date date9.; run;
date=21,090 2017-09-28 28SEP2017
And you want to create a new variable that has a string in it that looks like a date.
data want ; set have; string = put(date,e8601da.); run;