topic dates problem in SAS Procedures

dates problem

podarum — Thu, 05 Nov 2015 21:52:31 GMT

Hi ,

I have to pull these dates form our Taradata datawarehouse in this format 30APR2015 and it's a date9. format

I am trying SAS SQL to pull trhe date but getting no results...error actually.

I tried :

where date = '30APR2016'

where date = '30APR2016'd

where put (date, date9.) = '30APR2015'

where put (date, yymmdd10.)= '30APR2015'

where put (date, yymmdd9.)= '30APR2015'

where input (date, yymmdd10.)= '30APR2015'

where input (date, yymmdd9.)= '30APR2015'

Nothing works...

Got this error:

ERROR: Teradata prepare: Syntax error: Data Type "snap_dt" does not match a Defined Type name.

SQL statement was: select * from ddwv01.MORTG_CLM_LOSS as LP where put(snap_dt, yymmdd9.)

= '30APR2016'.

Any suggestions? Thanks.

Re: dates problem

Steelers_In_DC — Thu, 05 Nov 2015 22:01:47 GMT

I would pull the date in it's current format. If you need to change it to date9. do it in SAS after you have the dataset.

Re: dates problem

Reeza — Thu, 05 Nov 2015 23:09:45 GMT

What does the rest of your query look like? Are you using pass through sql or proc sql or a data step?

Re: dates problem

podarum — Thu, 05 Nov 2015 23:33:39 GMT

proc sql

Re: dates problem

Reeza — Fri, 06 Nov 2015 03:16:15 GMT

Teradata typically stores dates as date times.
Try

where datepart(date) = '30APR2016'd

Re: dates problem

RW9 — Fri, 06 Nov 2015 09:43:39 GMT

Start by doing a simple:

create temp_dataset as select * from your_table

Now, goto your work library, and open the properties of the temp_dataset. What format is the variable in question, what data does it hold? Post a proc contents if your still having problems, and some of the data.

Re: dates problem

podarum — Fri, 06 Nov 2015 13:57:21 GMT

Thanks everyone...

This worked :

WHERE DATE = DATE'2016-04-30'