topic Re: Converting character yyyy-mm-dd to mm/dd//yyyy format in SAS Programming

Converting character yyyy-mm-dd to mm/dd//yyyy format

mlogan — Tue, 13 Oct 2020 20:43:19 GMT

Hi there,

I have a column which is showing as character (yyyy-mm-dd) and I want to change that to mm/dd//yyyy date format, can someone please help.

Thanks,

Mike

Re: Converting character yyyy-mm-dd to mm/dd//yyyy format

Kurt_Bremser — Tue, 13 Oct 2020 20:46:08 GMT

Create a new variable, use the INPUT function with the YYMMDD10. informat.

Re: Converting character yyyy-mm-dd to mm/dd//yyyy format

jimbarbour — Tue, 13 Oct 2020 20:55:56 GMT

Here's a code sample (tested) bringing the text data in yyyy-mm-dd format and putting it out in MMDDYYS10. format. Results below.

You can either create a formatted text variable (New) or a SAS date variable with a format (New2).

Jim

DATA	DATE_DATA2;
	Old		=	'2020-10-13';
	New		=	PUT(INPUT(OLD, ANYDTDTE10.), MMDDYYS10.);
	New2	=	INPUT(OLD, ANYDTDTE10.);
	FORMAT	New2	MMDDYYS10.;
RUN;

Re: Converting character yyyy-mm-dd to mm/dd//yyyy format

Reeza — Tue, 13 Oct 2020 20:52:48 GMT

Do you want a SAS date or a character variable for the new variable?

I generally recommend a SAS date as it offers more flexibility.

data demo;

char_date = "2020-01-01";

SAS_date1 = input(char_date, yymmdd10.);
format sas_date1 yymmdd10.;

SAS_date2 = sas_date1;
format sas_date2 mmddyyd10.;

sas_date3 = sas_date1;
format sas_date3 date9.;

date_char_new = put(sas_date1, mmddyyd10.);

run;

proc print data=demo;run;

@mlogan wrote:

Hi there,

I have a column which is showing as character (yyyy-mm-dd) and I want to change that to mm/dd//yyyy date format, can someone please help.

Thanks,

Mike