- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-23-2018 03:48 PM
(3945 views)
I'd like to add a column to an existing query in EG that displays today's date in the result.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
column=today();
I don't know how to do that in EG using GUI
i assume there must be code editor or something, you would open up and find a sql query, if this is true
add the assignment in the select clause
today() as new_column
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you wish to use "Query Builder" point-and-click feature in SAS EG instead of programming then in query builder you have and option "Computed Column" at top right in query builder. Then navigate New>Advanced expression> Add TODAY() in expression window> assign column name, format and length accordingly.
Thanks,
Suryakiran
Suryakiran
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
That one worked. I knew it was a relatively simple move - just didn't know where to start.
Thanks much for the response!
Thanks much for the response!