topic Re: Macro variable in file path in SAS Data Management

Macro variable in file path

Ujjawal — Mon, 04 Aug 2014 18:17:31 GMT

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.

Re: Macro variable in file path

ballardw — Mon, 04 Aug 2014 18:46:13 GMT

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.

Re: Macro variable in file path

SteveED — Wed, 13 Dec 2017 15:22:54 GMT

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!