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

[SamUser]

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,

[jebjur · Accepted solution]

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.

[SamUser]

Thank you this helped. much appreciated.