topic Re: Date time in SAS Programming

Date time

kajal_30 — Thu, 11 Jun 2020 05:51:09 GMT

Hi ,

I need help creating one dataset which should contain two variables

B_date = today's date and start time 12:00:00 am

E_date = today's date and end time 11:59:59 pm

Thanks in advance.

sgottipati — Thu, 11 Jun 2020 06:00:16 GMT

Please below code.

data temp1;
    b_date=dhms(today(),0,0,0);
    e_date=dhms(today(),23,59,59);
    format b_date e_date datetime.;
    put b_date e_date;
    run;

ed_sas_member — Thu, 11 Jun 2020 08:21:39 GMT

I you only need macrovariables, you can define a %let statement:

%let b_date=%sysfunc(dhms(%sysfunc(today()),0,0,0));
%let e_date=%sysfunc(dhms(%sysfunc(today()),23,59,59));

Best,