Desktop productivity for business analysts and programmers

Create Macro Variable using Query Builder (computed column)

Reply
Occasional Contributor
Posts: 14

Create Macro Variable using Query Builder (computed column)

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

Community Manager
Posts: 2,882

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 370 views
  • 1 like
  • 2 in conversation