07-08-2013 03:18 AM
I have source tables in oracle .For Eg (Date of Birth is in Date datatype)
When we import into SAS DI,Its taking DOB column as numeric datatype.
I need to convert that into character.
I have used put function(put(Date of Birth,10.)),but its not working.
I need that output in same form.
Date of Birth o/p
How to do these?
07-08-2013 03:24 AM
Since it's a date column in Oracle, you need a SAS date format, not just a plain numerical format.
Why do you want to convert it to char?
07-08-2013 03:52 AM
First, is the date value being returned as a DATE or a DATETIME? Best way to test is to put the value to the log
Next, convert the numeric date into a character date: if DOB = 19546, then put(DOB,10.) will get " 19546".
What layout do you want your date to be, such as dd-mm-yyyy, yyyy-mm-dd? It should then be a relatively straightforward task to select the appropriate format.
07-08-2013 04:45 AM
Foe me,the date is returned as datetime first (format and unformat both as datetime).getting as 01Jun1958:00.00.00
And in table loader transformation ,I have used (put(DOB,10.)) and changing datatype column as character because i have
used put(numeric to char) function
When I change into char,i am not able to define the appropriate formats in SAS DI.
Its having format like($,$binary,$varying....not ddmmyy...)