topic Re: Error in Date column in SAS Programming

Error in Date column

Helannivas — Tue, 02 Jul 2013 09:12:42 GMT

My source file for eg.

DOB

28/10/1988

25/10/1988

I am loading into target table.I am getting the same o/p in SAS DI.(Right click on target table in sas DI job and open).

But,When I check in oracle database,Its showing the o/p as

DOB

01-Jan-1960

01-Jan-1960.

What we we need to do?Pls help

Re: Error in Date column

LinusH — Tue, 02 Jul 2013 10:43:18 GMT

Is the target Oracle?

It seems that your source data is in date format, and the target is datetime. Check the data type in oracle, the SAS format applied to it. There are also some options that handles date/datetime conversions between SAS and oracle.

Re: Error in Date column

Helannivas — Tue, 02 Jul 2013 12:09:55 GMT

Yes,my target in oracle database.

My source s in flat file and extracted as character datatype in sas DI and

i checked my target column (DOB) is in date format in oracle.

I have tried some fncs ,its not workin..

Re: Error in Date column

LinusH — Tue, 02 Jul 2013 12:18:06 GMT

Make sure that you have date. format on the last table (and on the target table) for DOB.

If that does not help, try to play with the dbtype= data set option.

http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p1dqaq7ub1cm1pn1ow3x9qkmkxe8.htm

Re: Error in Date column

CTorres — Tue, 02 Jul 2013 14:02:25 GMT

You can also try the SASDATEFMT Data set option:

SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Editio