topic Re: Adding a Date Column to a Query with Today's Date in SAS Enterprise Guide

Adding a Date Column to a Query with Today's Date

EHittner — Wed, 23 May 2018 19:48:15 GMT

I'd like to add a column to an existing query in EG that displays today's date in the result.

Re: Adding a Date Column to a Query with Today's Date

novinosrin — Wed, 23 May 2018 20:07:01 GMT

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

Re: Adding a Date Column to a Query with Today's Date

SuryaKiran — Wed, 23 May 2018 20:26:00 GMT

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.

Re: Adding a Date Column to a Query with Today's Date

EHittner — Wed, 23 May 2018 21:32:48 GMT

That one worked. I knew it was a relatively simple move - just didn't know where to start.
Thanks much for the response!