Macro variable in file path

[Ujjawal]

I want to pass a macro variable in a file path.

ODS HTML FILE ="C:/User/" || &macrovariable || ".html";

Everything is same except filename. I have tried concatenating the remaining portion of the path with macro varible. But it seems not be working.

[ballardw · Accepted solution]

Try

ODS HTML FILE ="C:/User/&macrovariable..html"; /* the first . is to tell the macro processor that you want to append some text and is needed to add the . into the name.

[SteveED]

I think @ballardw got this correct. I'd probably add in a %trim to ensure no trailing blanks given that its a file name that's being created.

So I'd use:

ODS HTML FILE ="C:/User/%trim(&macrovariable).html";

nice solution @ballardw!