topic Re: Convert Datetime variable to numeric in New SAS User

Convert Datetime variable to numeric

salvavit — Tue, 23 Jun 2020 12:05:15 GMT

Hi all, I have a list of Datetime values (e.g. 02JAN1970:01:00:02) that I want to convert into numerical having the following format: 19700102

I have wrote the following code, but it ends up showing a list of dots instead of the actual dates.

data table_2;
set table_1;
day_p = datepart(day_p);
format day_p yymmddn8.;
run;

data table_3; 
set table_2; 
day_p = input(put(input(day_p,date9.),yymmddn8.),8.);
format day_p 8.;
run;

May anyone help me in solving this issue?

Thank you in advance

Re: Convert Datetime variable to numeric

Kurt_Bremser — Tue, 23 Jun 2020 12:24:14 GMT

You have an INPUT() too many:

data want;
dt = "02JAN1970:01:00:02"dt; 
day_p = datepart(dt);
day_n = input(put(day_p,yymmddn8.),8.);
format
  dt datetime19.
  day_p yymmddd10.
  day_n 8.
;
run;

Be advised that the result is not useful for anything. You can't use it in calculations, cannot display it nicely, and can't use the gazillion goodies that SAS provides for handling dates. It needs more bytes than a SAS date (which can be stored with 4) on top.

Re: Convert Datetime variable to numeric

salvavit — Tue, 23 Jun 2020 12:36:11 GMT

Hi Kurt, Thanks for your help and suggestions. So what should I do if
I need to compare it to another date which is stored in the same
format (19700201)?
If I have understood correctly, your solution is to convert both dates
into SAS dates and then compare them?

Re: Convert Datetime variable to numeric

Kurt_Bremser — Tue, 23 Jun 2020 13:28:19 GMT

Absolutely. Anything that is a date, time or datetime value should be stored as such in SAS. Even things that show only periods (year/month) should be stored as a date (1st of month) with a format that shows year/month only, like yymmd7. Because then you can still use functions to calculate intervals etc.