Date from prompt's macro variable needs coverted to mmddyy10 format for report header

[eg_michael]

Platform: SAS EG

Problem: I have a macro variable (&PV_EndDate) from a date prompt that I display in a reaport header. The date is displayed as 31Dec2016, but I want it displayed as 12/31/2016. After much trial an error I cannot get it to work. Any Suggestions?

My Code:

data _null_;

    %put &PV_EndDate; /* prints '31Dec2016' to log */

    End_Date="&PV_EndDate"d;

    newDate = put(&&End_Date,mmddyy10.);

    put newDate; /* prints '12/31/2016' to log */

     %Global MV_EndDate;

    %let MV_EndDate = newDate;

run;

%put &MV_EndDate; /* prints 'newDate' to log */

 Header Code: 

  TITLE3 "End Date: &MV_EndDate";

[Kurt_Bremser · Accepted solution]

You need to transfer the value of the data step variable into the macro variable.

Do

call symput('mv_enddate',mv_enddate);

in the data step.

%let is a macro statement and therefore executed when the code is gathered to be compiled for the data step. It can never access data step variables.

[eg_michael]

Thank You!