Desktop productivity for business analysts and programmers

in query builder select all columns with *

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 90
Accepted Solution

in query builder select all columns with *

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


Accepted Solutions
Solution
a week ago
SAS Super FREQ
Posts: 401

Re: in query builder select all columns with *

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

View solution in original post


All Replies
Super User
Super User
Posts: 9,840

Re: in query builder select all columns with *

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.

Solution
a week ago
SAS Super FREQ
Posts: 401

Re: in query builder select all columns with *

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 64 views
  • 0 likes
  • 3 in conversation