topic Re: SAS EG Dates in SAS Programming

SAS EG Dates

AliMN — Tue, 18 Feb 2014 17:44:45 GMT

Can you please help to change SAS EG dates? it's SAS EG version: 5.1

this is the current format I dont want

Type: Character Length:500

Group: Character

Format: $500.

Informat:$500.

2014-01-01 00:00:00

I want this below format

Type: Numeric Length: 8

Group: Date

Format:DATETIME20.

Informat:DATETIME20.

01JAN2014:00:00:00

Your help is greatly appreciated.

Re: SAS EG Dates

DBailey — Tue, 18 Feb 2014 18:57:28 GMT

Are you importing a file using the EG wizard? If so, you can change the type and format of the data in the wizard. If not, then what are you doing that is creating these text formats?

Re: SAS EG Dates

Reeza — Tue, 18 Feb 2014 18:57:45 GMT

Use the conversion function

input(date_var, anydtdtm.)

You can use this in a query with a calculate column or in a data step.

Re: SAS EG Dates

AliMN — Tue, 18 Feb 2014 19:28:36 GMT

I tried to change it in the wizard but after I changed the whole column become blank.

Re: SAS EG Dates

AliMN — Tue, 18 Feb 2014 19:30:38 GMT

Reeza - Do you mean like the following?
newdatecolumn = input(date_var, anydtdtm.)

Can you explain more?

Re: SAS EG Dates

Reeza — Tue, 18 Feb 2014 19:33:28 GMT

In a query, create a calculated field, custom calculation, using the above formula.