Desktop productivity for business analysts and programmers

SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

Reply
Contributor
Posts: 27

SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

Hi Team

We are currently doing UAT for migration from SAS EG 4.1 to SAS EG 7.1.

One of the variable Application_Date has format DATETIME20. on SAS EG 7.1 whereas in the results from the SAS EG 4.1 Application_Date has format DATETIME22.3.

Please advice on how to change the default value on SAS EG 7.1 to DATETIME22.3 .

Thanks

Raj

Esteemed Advisor
Posts: 6,646

Re: SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

Did you migrate the dataset?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Valued Guide
Posts: 854

Re: SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

Is the problem when you are importing the dataset?  While importing you will go to the date field and select the format that you want.  35315 - Converting Variable Types in SAS® Enterprise Guide®

Contributor
Posts: 27

Re: SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1


Hi Mark/Kurt

Thanks for your response.

The problem is not while importing the data. Currently, we are doing a UAT on old and new system. We are doing a PROC COMPARE to test if the results on both the SAS EG 4.1 and SAS EG 7.1 are same. It is at this time the PROC COMPARE shows a difference.

SAS EG 7.1 --> DATETIME20.

SAS EG 4.1 --> DATETIME22.3

How to make the default format of SAS EG 7.1 to DATETIME22.3.

Regards

Raj

Esteemed Advisor
Posts: 6,646

Re: SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

The question remains: how did you create the dataset? If not by migration, then SHOW THE CODE.

Because if you open an existing SAS dataset in a new environment, it is opened "as is" and attributes like formats are not changed.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Community Manager
Posts: 2,692

Re: SAS EG DATETIME Format on SAS EG 4.1 vs SAS EG 7.1

In SAS Enterprise Guide 7.1 you can now easily search your project for any text in programs, tasks, and logs.  To find where in the project the format is being applied, enter DATETIME20. in the search field (upper right corner of the application).

Example:

eg71srch.png

That will help you to track down which step in the project might be generating different code than your v4.1 version.

Chris

Ask a Question
Discussion stats
  • 5 replies
  • 675 views
  • 0 likes
  • 4 in conversation