Inserting Date Column - SAS enterprise Guide

[Kenmar]

I have an existing SAS table and I want to add a date column to the table. Is there an easy way to add say JAN 2003? I am using SAS enterprise Guide. I have been going to Edit - Columns - Add Columns and adding the numeric value, however this is very cumbersome. It would be much easier to add just Jan 2003 and have SAS read it as a date.

[sassharp]

data new;

set old;

date=define date format as needed;

run;

[Reeza · Accepted solution]

What numeric value? 15706? You can add a date value with a date literal as : "01Jan2003"d but that does mean including a day. You can then apply a format to display the date as desired.

[Kenmar]

Thank you! I was missing the " "d.