Create Macro Variable using Query Builder (computed column)

bendsteel6 — Wed, 03 Aug 2016 18:13:36 GMT

Is there a way to create a macro variable in a query builder node (while building a computed column) using the "INTO:" syntax. Or, is there another way to do it? If not, should this be reviewed for the next version? I'm using SAS EG 6.1 (running SAS 9.2 TS2M3).

Thanks

Re: Create Macro Variable using Query Builder (computed column)

ChrisHemedinger — Wed, 03 Aug 2016 18:19:27 GMT

The EG Query Builder does not allow you to funnel results INTO a macro var. That would be a cool capability, but it's a different use case than most of the scenarios that the Query Builder supports today (making new tables).

Only single-value result sets, or result sets that generated a straight list of values (for a range of macro vars) would make sense for this case.

topic Create Macro Variable using Query Builder (computed column) in SAS Enterprise Guide

Create Macro Variable using Query Builder (computed column)

Re: Create Macro Variable using Query Builder (computed column)