DATA Step, Macro, Functions and more

resolve macro for xml

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

resolve macro for xml

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!


Accepted Solutions
Solution
‎03-26-2013 09:23 PM
Frequent Contributor
Posts: 87

Re: resolve macro for xml

Try:

data _null_ ;

    formid = '1234' ;

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

    put x ;

run ;

View solution in original post


All Replies
Solution
‎03-26-2013 09:23 PM
Frequent Contributor
Posts: 87

Re: resolve macro for xml

Try:

data _null_ ;

    formid = '1234' ;

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

    put x ;

run ;

New Contributor
Posts: 3

Re: resolve macro for xml

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 2 in conversation