topic Re: Concatenating two dates in SAS Programming

Concatenating two dates

LNM — Thu, 23 Mar 2017 21:01:33 GMT

I need help concatenating my two dates to a comment field. Here's what I have

DATA PRX;

SET BICS_02;

format prx_startdt prx_enddt mmddyy10.; /*format to mm/dd/yyyy*/

prx_startdt = datepart(Optional_1_start_date); /*optional date is date and time*/

prx_enddt = datepart(Optional_1_end_date); /*optional date is date and time*/

period_comments = prx_startdt||" to "||prx_enddt; /*combine the dates in comment "start date to end date"*/

run;

prx_startdt and prx_enddt just post the date values. I have converted it to the right format but in the doesn't translate correctly to my comments field. Please help.

Re: Concatenating two dates

Astounding — Thu, 23 Mar 2017 21:05:57 GMT

Try it this way:

period_comments = put(prx_startdt, mmddyy10.) || " to " || put(prx_enddt, mmddyy10.);

Re: Concatenating two dates

ChrisNZ — Fri, 24 Mar 2017 02:32:03 GMT

Since the variable already has a format, this works too:

PERIOD_COMMENTS = vvalue(PRX_STARTDT) || ' to ' || vvalue(PRX_ENDDT);

Re: Concatenating two dates

LNM — Fri, 24 Mar 2017 13:58:37 GMT

Thanks a lot, it works!!

Re: Concatenating two dates

LNM — Fri, 24 Mar 2017 14:00:25 GMT

Thank you, it works!