Concatenating two dates

[LNM]

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.

[Astounding]

Try it this way:

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

[ChrisNZ]

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

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

[LNM]

Thanks a lot, it works!!

[LNM]

Thank you, it works!