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

[RAmarapuram]

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

[Kurt_Bremser]

Did you migrate the dataset?

[Steelers_In_DC]

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®

[RAmarapuram]

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

[Kurt_Bremser]

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.

[ChrisHemedinger]

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:

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

Chris