resolve macro for xml

[cam03]

Hello,

I am creating an xml file and trying to resolve a macro unsuccessfully. The ultimate goal is the line must read:

<Form formId="1234 " lastModifiedDate="03/26/13" status="D">

In the above, the formId will be generated from an existing variable. The problem area is lastModifiedDate, which I want to generate from a macro.

%let currentdate=%sysfunc (today(), worddate.);

put ' <Form formId=" 'formId $12.' " lastModifiedDate= " ' &currentdate ' " status="D"> ' ;

Suggestions?

Thank you so much!

[SteveNZ · Accepted solution]

Try:

data _null_ ;

    formid = '1234' ;

    x = cats('<Form formId="',formid,'" lastModifiedDate = "', put(today(),mmddyy8.) ,'" status = "D">') ;

    put x ;

run ;

[cam03]

Thank you so much! Very much appreciated! Thank you from a health department still learning their way around SAS