Desktop productivity for business analysts and programmers

"Column" vs "Alias" in Query Builder's "Computed Columns"

Reply
Trusted Advisor
Posts: 2,114

"Column" vs "Alias" in Query Builder's "Computed Columns"

What is the difference between the the value put in for the "Column" vs "Alias" in the Computed Columns part of the Query Builder? I see that the "alias" becomes the "column name" and the 'column' becomes the 'Input' in the "Select data" display, but I can't figure out any function for the differentiation. I Googled and didn't find anything useful.
Community Manager
Posts: 2,889

Re: "Column" vs "Alias" in Query Builder's "Computed Columns"

Doc,

Most of the time these values can be the same, and we've considered simplifying the UI to reflect that.

The "Column" field is what you want to show in the query builder -- you can regard that as the "friendly name" -- something that's easy to understand based on its name.

The "Alias" field is the name that's assigned via the SQL syntax, and you might want that to be different to make the syntax more readable or easier to maintain if you use the SQL as part of another SAS program.

Chris
Community Manager
Posts: 2,889

Re: "Column" vs "Alias" in Query Builder's "Computed Columns"

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