Write and run SAS programs in your web browser

SAS Studio query builder

Reply
Occasional Contributor
Posts: 6

SAS Studio query builder

Hi

Is there a way of creating calculated columns with the query builder in SAS Studio (SAS9.4 M2 for Linux) like there is in Enterprise Guide? It's pretty useless as a query tool without it! 

Grand Advisor
Posts: 17,428

Re: SAS Studio query builder

I can't see a way by default, but the code generated is below and can be modified, so you can add your computed column directly to the code. 

 

This doesn't mean one doesn't exist - just that it's not intuitively obvious. 

 

Annoying, but easily worked around for sure. 

 

 

Occasional Contributor
Posts: 6

Re: SAS Studio query builder

Hi

I can see you can generate code and edit it but it sort of destroys the point of visual programming. Odd that they have not incorporated such a basic feature. It makes it a hard sell to get the team to use visual programming if the functionality is very low.

Ask a Question
Discussion stats
  • 2 replies
  • 242 views
  • 0 likes
  • 2 in conversation