topic Re: Issue with the Title Date & Time in SAS Programming

Issue with the Title Date & Time

unwashedhelimix — Sun, 01 Dec 2024 03:58:12 GMT

I have the following parts of some code I have:

proc import datafile="FILE_PATH" 
    out=sample_data 
    dbms=csv 
    replace;
    getnames=yes;
run;


/* get current date and time for titles in AM/PM format */
%let current_datetime = %sysfunc(datetime(), datetimeampm.);

proc sql;
    create table my_output as
    SQL Code
quit;

title1 "First Name & Last Name";
title2 "Date and Time: &current_datetime";
title3 "Title of Output";

proc print data=my_output; 
run;

However, the title2 in my output shows up as:

Date and Time: 2048615388.473

Why isn't it showing in a MM/DD/YYYY AM/PM format? How can I fix it?

Re: Issue with the Title Date & Time

Tom — Sun, 01 Dec 2024 04:10:13 GMT

SAS does not have FORMAT with that name.

69   %put current_datetime = %sysfunc(datetime(), datetimeampm.);
ERROR: Format name DATETIMEAMPM. not found or the width and/or decimal specified for the format used are out of range.
current_datetime = 2048627120.622

Did you mean to use the DATEAMPM format instead? Or perhaps DATEAMPM23.?

70   %put current_datetime = %sysfunc(datetime(), dateampm.);
current_datetime = 30NOV24:11:08:28 PM
71   %put current_datetime = %sysfunc(datetime(), dateampm23.);
current_datetime =   30NOV2024:11:09:40 PM

Re: Issue with the Title Date & Time

Ksharp — Sun, 01 Dec 2024 06:02:40 GMT

%let current_datetime = %sysfunc(datetime(), mdyampm.);
title1 "First Name & Last Name";
title2 "Date and Time: &current_datetime";
proc print data=sashelp.class;
run;