topic Re: extract from teradata in SAS Programming

extract from teradata

santosh_pat69 — Thu, 26 Jan 2017 00:24:20 GMT

Hi All,

I am trying to extract data from teradata.

i am using Pass thru to do this, i need to extract only the records which have an expiry date greater than today.

I have created a Macro variable tdy, as this code needs to be run daily only the stores keeps changing.

Where a. Exp_date > &tdy. and Sales GT 500 and Store_loc in ('xxxxx','yyyyy','oooo','zzzz');

but i am getting more records when i am extracting the data using SAS pass thru facility but when i run the similar query on Teradata

i get less number of records .

Where a. Exp_date > Current_date and Sales GT 500 and Store_loc in ('xxxxx','yyyyy','oooo','zzzz');

And also i need to pass few Store names in the Where clause as shown in the above where clause. i am planning to do this by passing the comma separated macro variables.

I have already read in the stores details in a comma separated macro variable but i am struggling to get this macro variable in.

Any suggestion or guidance is helpful.

Re: extract from teradata

Patrick — Thu, 26 Jan 2017 02:41:17 GMT

Post your code and log if available. Make sure you also post the bit which shows us to what the macro variables you're using in your code resolve.

Re: extract from teradata

LinusH — Thu, 26 Jan 2017 07:10:52 GMT

"Similar"? Explicit pass thru means that you actually are executing within teradata.
It seems you have a simple filter which means you don't gain anything by doing an explicit pass through.

Re: extract from teradata

santosh_pat69 — Thu, 16 Feb 2017 15:25:49 GMT

Hi All,

Thank you for the suggestions, I was trying to compare the Dates in Teradata and SAS
I have figured out this and it is working for me.
Where Cast(Sales_date as date) > %unquote(%str(%'&td.'%)) ;
Here I have read the &td consists of todays date (&sysdate) in the desired format.

Thanks
Santosh