topic How to combine two sas date environment variables in SAS Programming

How to combine two sas date environment variables

Sathya3 — Tue, 22 Aug 2023 02:35:03 GMT

I want to combine outputs of sysdate and systime

and get them in below format. I want the output to be stored in macro variable

DDMMYYYY_HH:MM:SS

I tried doing like this but it is not working

%let dt=%sysfunc(put(&sysdate9,ddmmyy8.))||"_"||%sysfunc(put(&systime,tod8.));

Re: How to combine two sas date environment variables

Tom — Tue, 22 Aug 2023 03:25:58 GMT

You don't need to do much to combine macro variable values. Just put the reference where you want the value to appear.

%let dt=&sysdate9._&systime.;

Example:

1    %put dt=&sysdate9._&systime.;
dt=21AUG2023_22:20

The reason your code failed is you tried to run code like:

%let dt=%sysfunc(put(&sysdate9,ddmmyy8.))||"_"||%sysfunc(put(&systime,tod8.));

First issue is that %SYSFUNC() cannot call the PUT() function (or the INPUT() function). You can only use the type specific functions of PUTN() or PUTC() and INPUTN() or INPUTC().

Second issue is that the PUTN() function needs a NUMERIC VALUE. But you gave it the STRING value 21AUG2023 instead. If you want to have SAS treat that string as a date you need to add quotes and the letter D to convert it into a date literal instead of just a string in the style generated by the DATE format. Similarly for the time value.

Third issue is I don't think you really want to put double quote characters and pipe characters into the value of your new macro variable. Instead I suspect you just wanted the underscore character.

And finally I doubt you want to use only TWO digits for the YEAR value. So either use 10 for the width of the date format. Or use a format that does not use a delimiter so that 8 characters is enough to include the century number.

And and it is best to avoid MDY or DMY ordering for date value. Whichever one you pick will cause confusion for half of your audience. Was that July eight or the seventh of August?

6    %put dt=%sysfunc(putn("&sysdate9"d,yymmddn8.))_%sysfunc(putn("&systime"t,tod8.));
dt=20230821_22:20:00

Re: How to combine two sas date environment variables

whymath — Tue, 22 Aug 2023 03:30:17 GMT

I think you are looking for

%let dt=%sysfunc(date(),ddmmyyn8.)_%sysfunc(time(),tod8.);

You can test it with

%put &=dt;

The output will be

DT=22082023_11:18:21

There are several points you may want to know:

1. put() function is not supported to be used in %sysfunc(), the replacement is putn() and putc() function;

2. the macro function %sysfunc() has the second arguement, which allows us to write a format name here then %sysfunc() would return formatted value as we specified;

3. the syntax is kind of different between macro language and data step language, connecting character can be very simple in macro language;

4. ddmmyy8. will format date with slash, like 22/08/23, ddmmyyn8. will format date without slash, like 22082023;