topic Re: in query builder select all columns with * in SAS Enterprise Guide

in query builder select all columns with *

Jaheuk — Fri, 03 Aug 2018 09:24:30 GMT

dear all,

I am doing a proc transpose. the number of columns is based on the data.

If I put a query afterwards I would fetch all transposed columns: select *.T1 from . . . .

HOW do I do this with query builder ??

Kr,

Herman

Re: in query builder select all columns with *

RW9 — Fri, 03 Aug 2018 09:43:31 GMT

You are facing the (well one of the several) reason why not to transpose data. SQL is built to work with few columns (i.e. small structure, lots of records), in fact SAS also works that way with by groups, although its a lot more flexible. So unless you want that data that way for a report and no furter processing, then just don't transpose it. It is far simpler to code with a normalised data structure, than to mess around trying to work out what columns are present etc.

Re: in query builder select all columns with *

CaseySmith — Fri, 03 Aug 2018 13:21:40 GMT

EG's point-and-click Query Builder does not currently support generating "SELECT *" syntax. It currently explicitly lists each column that you select in the Query Builder GUI. So, you can select all the columns in the Query Builder GUI, but the generated SELECT statement will look like "SELECT col1, col2, ..., coln", rather than "SELECT *".

Adding explicit support for "SELECT *" to the Query Builder is on our roadmap. It is a reasonable thing to want to do.

Thanks for the feedback.

Casey

Re: in query builder select all columns with *

PhilC — Wed, 08 Jul 2020 17:57:02 GMT

Casey,
why doesn't query builder support "select * "? Is there a reason? I want to request the incorporation of this but is there an obvious reason known amongst experts why it isn't that way?