topic Date extraction from datetime variable in SAS Programming

Date extraction from datetime variable

RAVI2000 — Thu, 05 Aug 2021 00:03:33 GMT

Hello everyone,

my date format is 2012-11-06 00:00:00


data sj.have;
length date $21.;
date = "2012-11-06 00:00:00";
run;

I want just the date from that string in mm/dd/yyyy (for eg: 03/15/1979) format.

Thanks

Re: Date extraction from datetime variable

SASKiwi — Thu, 05 Aug 2021 00:29:33 GMT

data _null_;
  datetime = "2012-11-06 00:00:00";
  format date date9.;
  date = input(substr(datetime,1, 10), yymmdd10.);
  put _all_;
run;

Re: Date extraction from datetime variable

Kurt_Bremser — Thu, 05 Aug 2021 08:47:24 GMT

Create a date variable, and apply the fitting format:

data sj.have;
length
  date $21
  num_date 4
;
date = "2012-11-06 00:00:00";
num_date = input(scan(date,1),yymmdd10.);
format num_date mmddyy10.;
run;