topic Re: Oracle to EG Date Format Issue in SAS Enterprise Guide

Oracle to EG Date Format Issue

turcay — Fri, 14 Aug 2015 07:13:43 GMT

I encounter a problem about transfering datas from Oracle to EG. I want the format in EG DD\MM\YYYY instead of DD\MMM\YYYY : Time. Is here anyone who can help me ?

Re: Oracle to EG Date Format Issue

Haikuo — Fri, 14 Aug 2015 20:21:22 GMT

Your question involves two parts: 1. Convert DateTime value to Date value. 2. Format the way you want. It can be easily done using Base code.

In EG, you will need to create computed variable: Query builder - select data - create new computed column - 1 of 4 Select a type, select 'Advanced expression' - 2 of 4 Enter an expression: DATEPART(your-Oracle-datetime) - 3 of 4, enter your new date variable name, on the bottom Format, enter ddmmyy10. and click through.

Good luck,

Haikuo

Re: Oracle to EG Date Format Issue

Ksharp — Sat, 15 Aug 2015 11:37:13 GMT

You need to make a Environment variable like:

export sasdatefmt=dd/mm/yy

I forget something, search it at support.sas.com .You are going to find it .

Re: Oracle to EG Date Format Issue

turcay — Sun, 16 Aug 2015 13:39:59 GMT

Thank you for your help. In fact, my purpose is to change the "Format" column in the "Properties" window as you see in the picture(table -> right click -> columns) . Could you give information to me on how to do that, please ? I think if i can change the “Format” column as i wanted, the “Format” column will come as DD\MM\YYYY format by default when i receive the data every time.

Re: Oracle to EG Date Format Issue

SASKiwi — Sun, 16 Aug 2015 22:31:57 GMT

How are you reading your data from Oracle? With a Query Builder query, or with a SAS program? If you are using a program, please post it.

We can't advise you on the best way of changing the date format if we don't know how you are reading your data in the first place.

Re: Oracle to EG Date Format Issue

sinancanturk — Tue, 18 Aug 2015 06:13:14 GMT

We use query builders, and only thing we need is to view date colums with format of date9 (which is default date format for SAS). I found SASDATEFMT option but how can we set it as global variable ?

Thanks

Re: Oracle to EG Date Format Issue

SASKiwi — Tue, 18 Aug 2015 19:32:52 GMT

SAS can be configured globally - see this link: 6413 - SASDATEFMT option can be defined globally in the config file or as an environment variable with SAS/ACCESS® Interface to Oracle