topic Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable in SAS Programming

ODS Writing Interface - Return or copy the format that is associated with the specified variable

Brian — Mon, 08 Jul 2019 16:06:23 GMT

Hi all

I'm using the ODS Writing Interface to dynamically generate reports. The dataset (wide format) that I'm referencing has the correct format specified for each column. However, when using format_cell, the format doesn't appear to be attached to the variable specified.

As a workaround, I've used the PUT function to return the string with the specified format. It works if I hard code the format but I would like to dynamically pull the format from the variable I'm referencing.

This works:

obj.format_cell(data: PUT(VAR1, dollar10.2)) ;

I would like instead:

obj.format_cell(data: PUT(VAR1, %SYSFUNC(VFORMAT(VAR1))));

i.e. %SYSFUNC(VFORMAT(VAR1)) should equal dollar10.2

Result:

ERROR: The function VFORMAT referenced by %SYSFUNC, %QSYSFUNC, or %SYSCALL cannot be used within the MACRO function/call-routine interfaces.

Any thoughts on a fix? Similarly, I would like to replace VAR1 with an array element V(1).

Thanks for your help!

Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable

Reeza — Mon, 08 Jul 2019 16:17:30 GMT

PUT()/PUTC() will take a variable as the second parameter.

Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable

ballardw — Mon, 08 Jul 2019 16:17:41 GMT

@Brian wrote:

Hi all

I'm using the ODS Writing Interface to dynamically generate reports. The dataset (wide format) that I'm referencing has the correct format specified for each column. However, when using format_cell, the format doesn't appear to be attached to the variable specified.

As a workaround, I've used the PUT function to return the string with the specified format. It works if I hard code the format but I would like to dynamically pull the format from the variable I'm referencing.

This works:

obj.format_cell(data: PUT(VAR1, dollar10.2)) ;

I would like instead:

obj.format_cell(data: PUT(VAR1, %SYSFUNC(VFORMAT(VAR1))));

i.e. %SYSFUNC(VFORMAT(VAR1)) should equal dollar10.2

Result:

ERROR: The function VFORMAT referenced by %SYSFUNC, %QSYSFUNC, or %SYSCALL cannot be used within the MACRO function/call-routine interfaces.

Any thoughts on a fix? Similarly, I would like to replace VAR1 with an array element V(1).

Thanks for your help!

SYSFUNC is to allow you to call data step functions in a macro. Since the RWI is part of a data step then there is no need to use SYSFUNC at all.

You will need to pay attention to how you pass the variable to VFORMAT which will not take an expression, requiring either the literal variable name or an array reference to variable so VFORMAT(V[1]) should work just fine assuming you have properly defined your array V.

Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable

Brian — Mon, 08 Jul 2019 16:29:13 GMT

When I remove %SYSFUNC, I receive the following:

ERROR 85-322: Expecting a format name.

I hoped to use %SYSFUNC to resolve the format name first.

Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable

Reeza — Mon, 08 Jul 2019 16:31:14 GMT

You still need to use PUTC(), it won't work with the format otherwise.

Re: ODS Writing Interface - Return or copy the format that is associated with the specified variable

Brian — Mon, 08 Jul 2019 16:41:23 GMT

Thank you everyone for your help. Have a great day!