topic Re: Query with Computed Columns after changing a field from character format to Date or numeric form in SAS Enterprise Guide

Query with Computed Columns after changing a field from character format to Date or numeric format.

SamUser — Fri, 12 Mar 2021 18:53:09 GMT

Hi,

I am using SAS EG 8.3 and have a field that it is called AQ_DATE which has 8-digit numbers (Ex: 20201216). I am trying to use Summary Table to change the format of the date, but I get the following error:

ERROR: You are trying to use the numeric format YYMMS with the character variable AQ_DATE in data set WORK.QUERY.

I was wondering if it possible to change the AQ_DATE field format using Computed Columns in the Query Builder so I can utilize the Summary Table to change the format.

Thank you,

Re: Query with Computed Columns after changing a field from character format to Date or numeric form

jebjur — Fri, 12 Mar 2021 19:17:52 GMT

In the query builder, you can create a new computed column with the INPUT function and the YYMMDDw. informat, to create a numeric date field, and format it with the YYMMS. format.

Re: Query with Computed Columns after changing a field from character format to Date or numeric form

SamUser — Fri, 12 Mar 2021 20:55:03 GMT

Thank you this helped. much appreciated.