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,
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.