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
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®
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
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: