topic Inserting Date Column - SAS enterprise Guide in SAS Programming

Inserting Date Column - SAS enterprise Guide

Kenmar — Tue, 01 Dec 2015 16:16:36 GMT

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.

Re: Inserting Date Column - SAS enterprise Guide

sassharp — Tue, 01 Dec 2015 16:28:58 GMT

data new;

set old;

date=define date format as needed;

run;

Re: Inserting Date Column - SAS enterprise Guide

Reeza — Tue, 01 Dec 2015 16:37:10 GMT

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.

Re: Inserting Date Column - SAS enterprise Guide

Kenmar — Tue, 01 Dec 2015 16:39:40 GMT

Thank you! I was missing the " "d.