topic Re: SAS Studio query builder in SAS Studio

SAS Studio query builder

stephenjdunn — Tue, 26 Apr 2016 09:44:36 GMT

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!

Re: SAS Studio query builder

Reeza — Tue, 26 Apr 2016 09:52:13 GMT

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.

Re: SAS Studio query builder

stephenjdunn — Tue, 26 Apr 2016 10:24:15 GMT

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.

Re: SAS Studio query builder

vazmena1 — Thu, 07 Jun 2018 15:58:47 GMT

Please could you provide the code? I have the same problem. Thanks

Re: SAS Studio query builder

Reeza — Thu, 07 Jun 2018 19:20:43 GMT

@vazmena1 wrote:

Please could you provide the code? I have the same problem. Thanks

Please post a new question, not add on to a several year old one.

Build your code using the query builder and then copy the code to a code node. Then manually add in the calcuations you want.

It follows the format below, in red, with the BMI calculation.

proc sql;
create table WANT as
select age, name, weight,   weight/height**2 as BMI 
from sashelp.class;
quit;