topic Re: How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy in New SAS User

How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy

ScotchCat — Mon, 04 Mar 2019 17:34:24 GMT

I have a char date that is formatted mm/dd/yyyy, I need to keep the date in a char format and change it to be a mm/dd/yy. Any assistance is appreciated. Thanks

Re: How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy

PeterClemmensen — Mon, 04 Mar 2019 17:38:32 GMT

You can do something like this

data test;
   chardate='03/04/2019';
   newchardate=put(input(chardate, mmddyy10.), mmddyy8.);
run;

Re: How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy

novinosrin — Mon, 04 Mar 2019 17:44:01 GMT


data have;
do date=today()-7 to today();
char_date=put(date,mmddyy10.);
output;
end;
drop date;
run;

data want;
set have;
substr(char_date,7,2)=' ';
char_date=compress(char_date);
run;

Re: How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy

novinosrin — Mon, 04 Mar 2019 17:46:45 GMT


data want;
set have;
want=cats(substr(char_date,1,6),substr(char_date,9));
run;

Re: How to format a char date from mm/dd/yyyy to a char date of mm/dd/yy

ScotchCat — Mon, 04 Mar 2019 17:56:07 GMT

Perfect! Thanks so much!!