topic Re: Convert character values to date in SAS Programming

Convert character values to date

lovecoding — Tue, 23 May 2023 07:40:15 GMT

AETRT = 22459
How I can it compare with this ?

AESTDTC = 2021-07-05

Re: Convert character values to date

MayurJadhav — Tue, 23 May 2023 08:52:39 GMT

@lovecoding

Your question is not clear. Though I'd recommend to look at this SAS Date format.

Here is how you can check formatted date values:

data test;
format AETRT_Formatted yymmdd10.;
AETRT = 22459 ;
AETRT_Formatted = AETRT;
run;

You can also use PUT function if this is something you want to achieve:

AETRT_Formatted=put(AETRT,yymmdd10.);

Re: Convert character values to date

PaigeMiller — Tue, 23 May 2023 09:54:56 GMT

@lovecoding wrote:

AETRT = 22459
How I can it compare with this ?

AESTDTC = 2021-07-05

Is AETRT numeric or character? Is AESTDTC really a character variable, or is it numeric with a format? Please check PROC CONTENTS and determine if each of these variables is numeric or character. Let us know.

Re: Convert character values to date

JosvanderVelden — Tue, 23 May 2023 10:08:50 GMT

To understand more about dates and times in SAS you can read:

For a way to compare see the following code:

data _null_;
   date1 = 22459;
   date2 = mdy(5, 7, 2021);
   days_between_1_2 = intck('day', date1, date2);
   days_between_2_1 = intck('day', date2, date1);
   formatted_date1 = date1;
   formatted_date2 = date2;
   format formatted_date1 formatted_date2 date9.;
   put date1= '|'  formatted_date1= / 
       date2= '|'  formatted_date2= / 
       'days_between date1 and date2 is ' days_between_1_2 /
       'days_between date2 and date1 is ' days_between_2_1;
run;

Re: Convert character values to date

Tom — Tue, 23 May 2023 14:05:11 GMT

@lovecoding wrote:

AETRT = 22459
How I can it compare with this ?

AESTDTC = 2021-07-05

Assuming that the variable whose name ends with the letter C is a CHARACTER variable you can convert its contents to a date value using the INPUT() function. Looks like the string is in a style that the YYMMDD informat can read.

To have the numeric value print in the same style attach the YYMMDD format to the it.

data want;
  set have;
  difference = aetrt - input(aestdtc,yymmdd10.);
  format aetrt yymmdd10.;
run;

Result

Obs         AETRT     AESTDTC      difference

 1     2021-06-28    2021-07-05        -7